OPTIMIZE TABLE is almost never needed. I certainly don't blast away at all tables.
> -----Original Message-----
> From: Igor Shevtsov [mailto:nixofortune@stripped]
> Sent: Tuesday, June 19, 2012 2:04 PM
> To: mysql@stripped
> Subject: optimize DB - bad experience
> Hi Guys,
> Just curious if any of you had a bad experience running optimize table
> procedure. ERRORS, corrupted databases or tables caused by this.
> We have MySQL 5.1.46 server.
> I feel to run optimize of the full DB is quite safe
> shell> mysqlcheck -o --skip-write-binlog database
> What's your stories on this one?
> Many thanks,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql