List:General Discussion« Previous MessageNext Message »
From:Rick James Date:June 19 2012 10:38pm
Subject:RE: optimize DB - bad experience
View as plain text  
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
> Example:
> shell> mysqlcheck -o  --skip-write-binlog database
> 
> What's your stories on this one?
> Many thanks,
> Igor
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
optimize DB - bad experienceIgor Shevtsov19 Jun
  • RE: optimize DB - bad experienceRick James19 Jun