Optimize the PLESK database

[Toepes]

Is there a tool to optimize the PLESK database ? I optimize (and repair) the customertables once a day with the command mysqlcheck -u -p -A -r -o


OR is it not advisable to do ?

 

[Pavluha]

Yes, You can do it, but mysqlcheck verities index for database.
You can optimize database by ini file.

 

[Toepes]

could you be more specific, as for now i don't understand what you mean with the .ini ?

 

[jbuts]

Actually, I recommend you install Plesk 7.5.6. It uses more optimised queries for Mysql.

 

[Toepes]

This version 7.5.6 is installed. But i let a batchjob optimize and repair all customer databases once a day. So i thought maybe it would also be good to include the plesk database.

 

[cybernova]

the default plesk runs on port 8306 ....so you can use the myisamchek binary to check and repair the tables....