I've posted a few times about problems with index corruption, problems with inconsistent select results using indexes, and problems with hanging count(*) and distinct(*) on indexes. No good suggestions were provided other than upgrade to 3.23.34, (which I am loath to do unless I understand why), upgrade linux kernel due to certain problems with SMP boxes, or even turn off a processor. I've done two things, and had a clean day so far, the first clean day in several weeks! It is too soon to say the problems have gone, but it is looking better (touch wood). Fix #1 : reboot the box The box had half a year of uptime. I regarded this a badge of honor. Unfortunately, even though the filesystem was clean, it may be that the kernel had partly lost the plot sometime in the last six months, and was no longer functioning perfectly. (Not that any hint of that was provided in log messages). Fix #2: upgrade to kernel 2.4.2 If I get no weirdness by the end of this week, then I am 100% sure that either or both of these steps solved the problem.. Unfortunately I don't know which! It may be more the reboot, than the new kernel, since problems definitely started in the last few months.. I put it down to increased load, but maybe that was incorrect. So if your SMP server starts doing odd things and has been up for a while .. a simple reboot costs nothing and may very well help. -Justin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
