I have several large MyISAM tables that are frequently updated by certain events in the application. I find that the queries get considerably slower over time, and I run OPTIMIZE TABLE to defragment the datafiles. The user comments on http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html seem to indicate that OPTIMIZE TABLE has been known to crash the datafiles (which versions?) though I have never experienced that myself.
I'm now considering running OPTIMIZE TABLE on a few key tables immediately after the application does something that fragments the datafile. Locking of the table is not an issue. However, backing up (dump) those tables every time before running OPTIMIZE TABLE would be difficult to implement. The application would have to create backups, detect weather OPTIMIZE TABLE crashed the tables, then try to restore from backups if it did. My question is whether you have experienced crashes due to OPTIMIZE TABLE? Have there been any recent bug fixes pertaining to OPTIMIZE TABLE? Any other suggestions? I currently run Ver 3.23.47-max-debug on Windows 2000. Alek --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
