Am 28.03.2013 19:43, schrieb Rick James: > I have never traced a performance issue in InnoDB to the need for OPTIMIZE.
but with files_per_table you can get back GIGABTYES of disk-space depending on your backups this may be relevant > The Query Cache is irrelevant to this discussion it is NOT because look at the server-stats after a optimize table hint: cached results for any of the tables are thrown away
signature.asc
Description: OpenPGP digital signature