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

 
wordpress databse optimise 1

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

 
Step 02

 
wordpress databse optimise 2

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

 
databse repair optimise options

 
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

Leave a Reply

Your email address will not be published. Required fields are marked *