How to repair, optimise MySQL Databases through phpMyAdmin for optimum WordPress Website Performance over the years

Introduction

 
As we use & utilise our WordPress website running with MySQL database it gets cluttered & overheads with extra information or data in database tables sometimes it crashes of it’s own burden.

 
So what we should do at first place is that repair & optimise it for optimum performance.

 
So, Here is how to do it…!!!

 
Warning & Precautions

 
First backup all of your websites & relevant databases so if something goes wrong you have backup copy of your server files & databases.

 
Initial Step:

 
Initial Step is to Sign in to your web hosting’s ‘phpMyAdmin’ MySQL Database Portal then Select your choice of database.

 
First note down overheads & database size of your MySQL tables so that you can compare it in future after optimisation.

 
Now you will come to Step 01

 

 
As shown on above image click on ‘Check All’ to select all tables

 
Step 02

 

 
Now under drop down menu where it says ‘With Selected’

 

 
Select ‘Repair’ to repair Database or Select ‘Optimise’ to optimise database as per your requirement & need of time.

 
Now you can compare numbers displayed at bottom of tables to numbers you noted before you optimise the table.

 
Note: But do it carefully as it doesn’t give second chance so if you choose drop tables it will delete all tables from your database.

 
Hope this information helps,

 
Thanks & Regards
Mandar Apte