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

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to