I recompiled my sql with "nocona" instead of k8 and the problem persists.
Now, I found this:
http://bugs.mysql.com/bug.php?id=17329
which definitely sounds similar to my problems.
I'm gonna give a shot to disabling delayed_key_write.
On 6/6/07, Quentin Gouedard <[EMAIL PROTECTED]> wrote:
Hello
Hello,
So I have this somewhat busy mysql box (300qps - 1100 qps) holding a bunch
(20) of myISAM tables.
The Box is Core2Duo 2.4 / 4GB RAM / Gentoo64 / MySQL 5.0.38
There are a number of scripts accessing those tables, both located on the
same machine and on others.
Every day, 1 to 3 tables get c