Site5 - Built For Designers & Developers MENU

Corrupt read only tables

[2 Grey Star Level]

How can a read only MYISAM table become corrupt?

I have to do a myisamchk -r approx. once a week as the table gets marked as crashed.

I can’t see how this is happening though as no changes are being made to it, it’s read only.

It’s running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so far.

Answer #1

There are any number of ways that a table can become corrupt, but the most common ways are a disconnect while writing to the table or, simply, the MySQL server dropping unexpectedly.

Honestly, the myisamchk -r may be doing this, as well – if this is run at the same time as the table is being modified by something else, it will corrupt the table.

Answers Answered By: jdavey [359 Blue Star Level]

Answer #2

Visit following thread, where the same trouble was already solved

Answers Answered By: samuelbergius [2 Grey Star Level]

Answer #3

That thread would also work, but please note that is related directly to innoDB tables.

Answers Answered By: jdavey [359 Blue Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.