Phil Wareham
New Pleskian
Hi there,
I have a new server install with Plesk 10.2, and am optimizing mySQL to get the server as speedy as possible. Running mysqltuner I'm informed that the InnoDB tables for PSA are fragmented and need optimizing - I've run optimize commands on that database using myphpmadmin and get the following message...
Can you run me through step-by-step how to optimize InnoDB tables please anyone?
Cheers,
Phil
I have a new server install with Plesk 10.2, and am optimizing mySQL to get the server as speedy as possible. Running mysqltuner I'm informed that the InnoDB tables for PSA are fragmented and need optimizing - I've run optimize commands on that database using myphpmadmin and get the following message...
Code:
Table does not support optimize, doing recreate + analyze instead
Can you run me through step-by-step how to optimize InnoDB tables please anyone?
Cheers,
Phil