OPTIMIZE TABLE is almost never needed. I certainly don't blast away at all
tables.
> -Original Message-
> From: Igor Shevtsov [mailto:nixofort...@gmail.com]
> Sent: Tuesday, June 19, 2012 2:04 PM
> To: mysql@lists.mysql.com
> 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
Example:
shell> mysqlcheck -o --skip-write-binlog database
What's your