mysqldump triggering repair of MySQL tables

Posted by Rhodri on Server Fault See other posts from Server Fault or by Rhodri
Published on 2010-04-13T07:50:04Z Indexed on 2010/04/13 7:53 UTC
Read the original article Hit count: 362

Filed under:
|
|
|

I have an automated backup of a 6 Gigabyte MySQL database running very two hours. I also have a script which checks every minute for the need to repair MySQL tables.

Increasingly I'm getting tables having to be repaired during the backup process with the message returned of: Auto-increment value: 0 is smaller than max used value: xx

Is this being caused by corruption? Are the two scripts conflicting? Any ideas?

© Server Fault or respective owner

Related posts about mysql

Related posts about repair