471,049 Members | 1,503 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Replication Master Crashed After 6 Hours

CK
Hello everyone,

I recently setup replication, the master and slaves appears to work
fine initially. After about 6 hours, the master mysqld process will
start to consume 99% CPU and the load (avg. load per minute) will go
to 3, 4, 6, 15, 24, 56, 312... in a matter of seconds! The master then
stops responding and needs a reboot. This problem is reproducible, I
have tested a few times.

This is a screenshot of "top" command just before the master died:
http://choonkeng.hopto.org/temp/replication-hang.gif

There are plenty of memory and no disk swapping when the master goes
99%. Error and slow logs don't show any useful information.

Can anyone shed some light?

Thanks in advanced.

Regards,
CK
Jul 20 '05 #1
0 1589

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Moritz Steiner | last post: by
reply views Thread by I.P. | last post: by
2 posts views Thread by HJ | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.