If you want to optimize your WordPress database, then you can simply use WP-Optimize for this purpose but if you don’t want to use any plugin for that, then you can simply optimize your database from your Cpanel. Even we suggest you not to use any plugin for this. As more plugins will be in your site, more your site loading speed will be affected. So its better to do this simple process from cpanel. The procedure to optimize your WordPress Database using Cpanel is given below.
Steps To Optimize WordPress Database Using Cpanel
1.) First Login to your Cpanel by entering your site URL along with /Cpanel.
2.) After you enter your Cpanel, You need to scroll down a little bit and go to the Databases Section. And you will see phpMyAdmin over there. Just Click on phpMyAdmin.
3.) In phpMyAdmin click on the database of your site from the left hand side panel.
4.) Ok now you will be able to see all of your database elements and tables. Just scroll down a little bit and click on check all. All of your database tables will get selected.
5.) Now just click on the drop down menu labelled as with selected and you will see option like below image over there.
6.) Click Repair Table, it will repair your table.
7.) Now click on structure at the top. And you will see same table once again, just check them all using check all at the bottom and from drop down menu select Optimize Table.
Optimized WordPress Database From Cpanel
If you will see something like above image, then it means your WordPress database has been optimized. Now sit back and enjoy better website loading speed.