As time goes on, all the database operations performed on your WordPress tables (which square measure what store your diary posts and different data) can produce what’s referred to as “overhead.” To keep your database running swimmingly, you can get obviate this overhead by “optimizing” your tables (similar to defragmenting your arduous drive). we are suggesting you two types of How to Optimize Your WordPress info Tables
Method 1: WP-DBManager
Download and install the WP-DBManager plugin.
The plugin allows you to, among other things, optimize your tables from within your WordPress admin (just go to the “Databases” section and click on the “Optimize DB” tab), as well as schedule table optimizations on a daily basis.
However, the plugin also lets you delete tables ANd provides an interface for running MySQL queries, so if you don’t like the plan of all that power being unconditional in your WordPress admin, you can attempt the phpMyAdmin methodology instead.
Method 2: phpMyAdmin
Here are the steps for exploitation the phpMyAdmin computer code.
Go to your web hosting account’s cPanel and click on the “phpMyAdmin” icon. If you don’t see one, look for a “MySQL Databases” icon, click it, scroll to the bottom of the page, and click the “phpMyAdmin” link.
Select your WordPress info.
Look in the “Overhead” column. If you see a table with overhead, click the overhead value.
Click the “Optimize Table” link.
Once it’s done, click the Back button twice (to return to the tables list), and repeat from step 3.
And that’s it!