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 problem seems to disappear. --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Please download MySQL official binaries and > install. Then check if > the problem disappears. > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]