MySQL replication generate huge disk write IO
Noticed that MySQL replication is generating enormous disk write activity
iotop 10-20Mb/s
AWS volume monitor - 700-800 IOPS
And it lasts for hours. Historical graphs show that this repeats every day for 8-10 hours.
Replication processes in the state: "Reading event from the relay log" and "Waiting for master to send event" Replication is lagging behind master, it is running but VERY slow.
There are no active processes in MySQL that can generate this activity. No backups at this time. Replication activity is constant but not so high to generate this problem.
If I stop slave SQL thread - activity drops to zero immediately. After starting slave it increases again. Stopping mysqld doesn't help.
What parameters/configs/metrics sould I check?
Any help would be appreciated.
Percona server 5.5 on CentOS
Replicated database about 500Gb, about 300 tables.
I have similar environment with 800Gb replicated DB with the same user activity but disk IO is 20 times lower.
Subject
Views
Written By
Posted
MySQL replication generate huge disk write IO
4700
May 30, 2013 05:30PM
1966
May 31, 2013 07:32PM
1815
June 03, 2013 03:41PM
1754
June 06, 2013 10:27PM
1847
June 11, 2013 02:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.