List:General Discussion« Previous MessageNext Message »
From:Igor Shevtsov Date:June 19 2012 9:04pm
Subject:optimize DB - bad experience
View as plain text  
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,
optimize DB - bad experienceIgor Shevtsov19 Jun
  • RE: optimize DB - bad experienceRick James19 Jun