Optimising your databases Print

As you are editing databases they end up a bit like Swiss cheese, full of holes! Every now and again you need to compress these holes  i.e freeing up space to optimise your tables performance. 

I have made a list of steps to follow below should you wish to carry out a file compression: -  

  1. Login to CPanel
  2. Look for and click on PHPmyadmin
  3. On the left hand side click the database that you would like to optimise
  4. Scroll to the bottom and click where it says select all tables with overheads 
  5. In the drop down menu, Select optimise tables

If you should have any issues or have any questions regarding this topic please contact us via a support ticket (open a ticket) with our hosting department and we will get back to you as soon as possible.

Was this answer helpful?

  • Tagged in MYSQL, cPanel
« Back

Powered by WHMCompleteSolution