How dangerous is OPTIMIZE TABLE? I have been reading through the FAQ, and came to the section on OPTIMIZE TABLE.
http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html That has my interest, as my MySQL XOVER database will expire articles ever so often. But then I read a comment there that OPTIMIZE TABLE is dangerous, and can corrupt your database. :( Not what I want, really. The author that gave the warning spoke of tables with millions of rows. Mine only hold a hundred thousand, or so, max (closer to ~ 20 - 30 thousand a group). I will need OPTIMIZE TABLE, however, as many articles will expire over time, and I want the empty space reclaimed, of course. So, how dangerous is OPTIMIZE TABLE, really? Thanks! - Mark --------------------------------------------------------------------- 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
