Database - Reduce / Optimise Table Size

To make it easier to get in touch with us, from the 24th of March 2016 all support tickets will need to be submitted from your Crucial Control Panel.

How to Reduce / Optimise A Database Table Size in cPanel

Optimising and reducing the size of your database is a great way to help speed your website up and reduce clutter in the database.

Step 1 - Log in to cPanel (click here for a guide) and click on phpMyAdmin

d78eed727e4570bc3f777003ad1776395e837fb5?t=7b13ad93398d875195ea78fca5e1272c

 

Step 2 - Click on the Database you want to optimise

3e02b7ee6c938e2291e099910f04b887c3c60893?t=b7eb3fd5d0234e155e881581c58d79c4

 

Step 3 - (1) click Check all then (2) select Analyze Table

217860b2108a2209eed4e179cb880ebff29b86ba?t=dfa496c3a0ba8bfaf6972a36aef46e24

 

Step 4 - Once the Analyze table function is complete, scroll down, and (1) click Check all then (2) select Optimize Table

a73d5fb517d9e689e43bd028a58348a09ddebd6e?t=7038f1837c4446a60e280bbb5d8b7c7e

 

Step 5 - Once the Optimize table function is complete, scroll down, and (1) click Check all then (2) select Repair Table

955ab787e671ec34d38287f60705cbc1fce53f7b?t=0eaf6bbce19902d2eaf346ed1a45d1a3

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk