How do I optimze mysql in plesk ?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin. To perform the optimization,

1)  Log in to Plesk.

2)  Click on Databases & Select the Databases

2) Click on phpMyAdmin and select the database whose tables you wish to optimize.

A list with all the database's tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.


From the [With selected:] drop-down menu choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

How do I check the size of my database?

Using the below mentioned steps, we will show you how to check the size of your database so you...

I need a different version of PHP/MySQL

If for some reason you cannot install programs on your server like Joomla, Drupal, WordPress,...

How do I optimze mysql in Cpanel?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How to check and repair MySQL database tables?

In case you stumble across an error like: “Table ‘table_name’ is marked as crashed and should be...