I run CHECK commands against all tables nightly. Our dataset is
small, so it's quick & easy; for large and/or static datasets daily
might be impractical. However, if you don't run CHECK regularly, you
don't know your data is good, and it's possible you might have
corruption for a long time befor
In the last episode (Oct 27), wolverine my said:
> Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
> preference order to execute these commands?
OPTIMIZE calculates statistics as it rebuilds the table, so there's no
need to run an ANALYZE pass after it. You shouldn't ever need to
Hi!
Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
preference order to execute these commands?
We would like to schedule and execute these commands every month...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
