MySQL Forums :: MyISAM :: static mysql tables randomly require an optimize to work properly again
Re: static mysql tables randomly require an optimize to work properly again
Posted by: Aftab Khan ()
Date: December 07, 2010 10:55AM
>It is not the same table every time either.
Looks like you don't regularly check myisam tables. Have you tried using CHECK TABLE command to check table status prior to running optimize table command?
You should check table using CHECK TABLE command prior to performing weekly/month "rolled"
Looks like you don't regularly check myisam tables. Have you tried using CHECK TABLE command to check table status prior to running optimize table command?
You should check table using CHECK TABLE command prior to performing weekly/month "rolled"
| Subject | Views | Written By | Posted |
|---|---|---|---|
| static mysql tables randomly require an optimize to work properly again | 1507 | Alex Spitzer | 12/02/2010 03:14PM |
| Re: static mysql tables randomly require an optimize to work properly again | 592 | Aftab Khan | 12/07/2010 10:55AM |
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.
© 2013, Oracle Corporation and/or its affiliates