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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
