From: Rick James
Date: June 19 2012 10:38pm
Subject: RE: optimize DB - bad experience
List-Archive: http://lists.mysql.com/mysql/227704
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1487608105@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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
>=20
> 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
>=20
> What's your stories on this one?
> Many thanks,
> Igor
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql