Skip navigation links

MySQL Forums :: MyISAM :: table corruption


Advanced Search

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: http://rus.leaping.net/mysql/test_db.pl
Link to my.cnf:http://rus.leaping.net/mysql/my.cnf

Every suggestion is appreciated!

Thanks!

Options: ReplyQuote


Subject Views Written By Posted
table corruption 4963 Ruslan Bondar 04/16/2007 11:05AM
Re: table corruption 2291 Ingo Strüwing 05/02/2007 04:22AM
Re: table corruption 2301 Shane Bester 07/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.