Transient mysqlcheck errors about "size of datafile" (file too small)
- by Adam Backstrom
Running mysqlcheck on a live database is giving me transient errors like this one:
mydatabase.mytable
error : Size of datafile is: 500719688 Should be: 501000484
error : Corrupt
When I run the command again or check the table one-off using mysql, it's listed as OK. Is this just a side effect of running checks on live tables? Is it possible that data is not flushed, hence the strange discrepancy?
We moved several databases this morning by shutting down mysqld on the source and rsyncing files across to the new server, but these are all MyISAM tables so I don't believe the two things are related. (But I mention it just in case.)