Optimising your databases

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.

  • MYSQL, cPanel
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is a cron job and how to set one up

We all have 'those' jobs we have to do every now and again (washing the car, tidying the house...

How to Disable Directory Listing in cPanel

Preventing directory listings is very simple and pretty useful. Its useful when, for example, you...

What PHP version is best to use?

Most software that your website runs will need to use PHP to interact with databases and create...

Powered by WHMCompleteSolution