I have a Master-Master cluster with 2 Percona 5.5.30 servers. (Lets name them 1 & 2) The OS is FreeBSD 9.1
I have an issue that server 2 is not processing the relay log fast enough.
I know that for sure, because when i create a new table on server 1, and i immidiatly check the relay-log on server 2, i see the
CREATE command there, but the table is not being created for another 5-15 minutes or so.
It looks like the thread that is supposed to executing the relay log is halting itself every once in a while, showing
NULL in its state when executing
What can be the reason for that?
(I don't know how to paste SQL here...)