Optimize PSA InnoDB database

[Phil Wareham]

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...

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

 

[IgorG]

Look at this.
I hope it will help.

 

[Phil Wareham]

So if I'm in phpmyadmin, select the PSA database, click the SQL tab and then use...

ALTER TABLE tablename ENGINE='InnoDB';

Where 'tablename' is whatever table I want to target, that should work?

 

[IgorG]

Yes, I think it should work but create backup of table before just in case.