From: Igor Shevtsov
Date: June 19 2012 9:04pm
Subject: optimize DB - bad experience
List-Archive: http://lists.mysql.com/mysql/227703
Message-Id: <4FE0E940.7070606@googlemail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 stories on this one?
Many thanks,
Igor