MySQL Forums
Forum List  »  MyISAM

table corruption
Posted by: Ruslan Bondar
Date: April 16, 2007 11:05AM

My production system worked with mysql 4.1.x for about 2 years. For those 2 years we had about 3-5 table corruption problems. Hardware failure in most cases.
In January we switched to 5.0.28, and now we are getting around 1-2 corruptions per day.

I have 2 servers with Master-Save replication. Master gets ~200 qps and slave gets ~600 qps at the corruption moment. Top shows cpu load around 1.

In most cases corrupted tables happen with high delete/update/insert and only on Master server, Slave works perfect for all this month.

For testing purpose i wrote small script:
generate 15 table, with 4 field with about 50000 rec.
randomly send 11 type of query insert/update/select with 1,2,3 table

running this script on 3 different servers, shows that i get 1 crash in about 15 min 100%.

Trying different configuration, show that skip-concurrent-insert make test run for 3-4 hours without corruption, but when I leave it for a night, i get 1 table corrupted.

If I try different table creating options and different hardware configurations, i always get table corruption :(

Link to my script:
Link to my.cnf:

Every suggestion is appreciated!


Options: ReplyQuote

Written By
table corruption
April 16, 2007 11:05AM
May 02, 2007 04:22AM
July 17, 2007 12:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.