• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Optimize PSA InnoDB database

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

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
 
So if I'm in phpmyadmin, select the PSA database, click the SQL tab and then use...

Code:
ALTER TABLE tablename ENGINE='InnoDB';

Where 'tablename' is whatever table I want to target, that should work?
 
Yes, I think it should work but create backup of table before just in case.
 
Back
Top