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


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

Mandar Apte

Mandar is a Mumbai-based multi-disciplinary designer with UX/UI, Logo, Symbol, and Brand Identity design expertise. He currently runs his Mudrkashar Linguistic Apple iPhone, iPad, and Mac app business in the heart of Mumbai city.

Leave a Reply