Dear All,
I having issues with MySQL on Linux corrupting our MYD and MYI files frequently. We get errors such as "Can't open file: 'TABLE.MYD' which tells me the table data is corrupt/damaged. I can rebuild the index and recover the data correctly but this is the 2nd time in 2 weeks that this has occured. The server would average a few thousand reads and writes per minute, notably to the table we are having problems with. This server is in production and is part of a two system fail over mechanism so downtime for short periods is acceptable the system is mirrorred to another fail over server. The other server does not experience the same problem, notably probably due to the lower amount of reads/writes. This server is a Primary (the one with the MYD problem) and the other one (without the problem) is a Secondary and gets at least 95% less requests per/second. The server is a decent sized dell server with raid5, ultra 160 drivers, 512mb of ram, 1gig swap, and a 1000mhz CPU. The load average for this server is always around 0.15 or less and is very rarely any higher. Has anyone experienced this in the past? What is the recommended solution? Is this a bug? Any ideas of advice on this would be greatly appreciated Here are some stats I've gathered in case these help in working out a solution Kernel Linux server01 2.4.7 #3 SMP Tue Dec 18 07:59:25 EST 2001 i686 unknown MySQL Version mysql Ver 11.15 Distrib 3.23.46, for pc-linux-gnu Server Uptime 4:00pm up 59 days, 1:45, 1 user, load average: 0.03, 0.00, 0.75 File sizes NOTE: The MYD is in fact 3.7GB and contains over 12million records. -rw-r----- 1 mysql mysql 3749779904 Mar 24 03:50 OURTABLE.MYD -rw-r----- 1 mysql mysql 119045120 Mar 25 16:01 OURTABLE.MYI -rw-r----- 1 mysql mysql 9090 Jan 15 09:19 OURTABLE.frm Regards, Paul --------------------------------------------------------------------- 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