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 SHOW PROCESSLIST;
What can be the reason for that?
UPDATE
Processlist: http://pastebin.com/5Pq7f0GF
(I don't know how to paste SQL here...)
SHOW PROCESSLIST;
. If the processlist is too long, then runSELECT * FROM information_schema.processlist WHERE user='system user'\G