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

Mandar Apte

This website contains a design articles blog by Mandar Apte. He writes and shares his iOS development, graphic, web, & animation film design experience through articles. Mandar is Mumbai based multi-disciplinary designer with expertise in UI, UX, Logo, Symbol, and Brand Identity design. He is an alumnus of Sir J. J. Institute of Applied Art, Mumbai. He currently runs his studio in the heart of the city of Mumbai.

Leave a Reply

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