Thanks for your suggestion. I tried binary install
but the problem doesn't disappear. Though mysql no
longer consume 99% CPU, the load still go up till
the server hangs. Wonder why.
I seem to have a workaround now. My application
does lots of INSERTs, and after I change them to
INSERT DELAYED, the
Please download MySQL official binaries and install. Then check if
the problem disappears.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor
At first, I thought it was a low memory problem. I
reduced my buffers in my.cnf and run the test
again. The master still hung and this is a
screenshot of "top" command just before it died:
http://choonkeng.hopto.org/temp/replication-hang.gif
There are still plenty of memory and no disk
swapping w
Hello everyone,
The master is moderately busy with load average of
2-3. This has worked very well for a long time
before I started replication (few months). When
replication is started, both master and slave
appear to work fine with no significant increase of
load on either side.
But, after a fe