• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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