How to Optimise WordPress Database through Code and Plugin
                     How to Optimize WordPress 
Database through Code and 
Plugin
Introduction
• While static HTML destinations store information inside the pages, the 
WordPress depends on MySQL database to store every one of the 
information. 
• At the point when the database gets enlarged, it hinders your site 
execution in light of the fact that the server will require more 
opportunity to discover data from enormous database. 
• Subsequently, it is imperative to improve WordPress database to 
accelerate the site.
Optimize through phpMyAdmin
• The phpMyAdmin is a typical method for dealing with the 
WordPress database. 
• In the event that your WordPress facilitating plan 
accompanies a control board (cPanel), at that point you 
can utilize phpMyAdmin database the board device.
Command using phpMyAdmin
• To advance the tables influenced by a lot of messiness, you have to 
utilize the SQL direction "OPTIMIZE TABLE". 
• For example, in the event that you need to improve the 
wp_commentmeta table, at that point execute the accompanying 
SQL command: 
• OPTIMIZE  TABLE 'wp_commentmeta' 
• Further, the phpMyAdmin additionally enables you to upgrade 
tables from the principle drop-down menu.
Also, there are plugins to optimize the WordPress data base.
Let’s discuss them one by one  in the coming slides.
1. WP-Optimize
• WP-Optimize is one of the best modules to 
naturally clean your WordPress database with the 
goal that your site can run at most extreme 
proficiency. 
• It expels all the pointless information like 
destroyed/unapproved/spam remarks, pingbacks, 
trackbacks, and lapsed transient choices.
Image source: gracethemes.com
2. WP-DBManager
• It enables you to proficiently oversee and 
upgrade database directly from the administrator 
dashboard. You should simply to introduce this 
module and enact it.
Image source: gracethemes.com
3. Anti Spam Plugin
• At the point when your site gets a ton of spam 
remarks, they pointlessly devour space in the 
database. The spam remarks take up a ton of 
columns in the wp_comments table. 
• To address this, you can introduce an enemy of 
the spam module to stop all the nasty remarks.
Image source: gracethemes.com
Delete command
• To delete spam comments, one can also use the 
delete command.
• The command is:
• DELETE FROM wp_comments WHERE 
comment_approved = ‘spam’
Conclusion
• It isn't so difficult to improve the WordPress 
database in the event that you utilize appropriate 
modules and coding knowledge which 
computerize certain procedures.