Why do we need to optimize the database

When with the use of MySQL, including BLOB and VARCHAR bytes table will become more burdensome, because these fields are different lengths, the records inserted, updated, or deleted, it will occupy the space of different sizes, the recording will become fragmented, and leaving free space. Like disk with debris, reduce performance, you need to sort out, so to optimize.

How to optimize WordPress database

The WordPress uses MySQL database it is, so when you feel relatively slow speed of WordPress, MySQL to perform under optimized to improve the speed of WordPress considerable extent. We can optimize MySQL tables by PHPMyAdamin:

Optimize MySQL tables in PHPMyAdmin

Use Optimize DB plugin to optimize WordPress MySQL database directly in the background

But if every time optimization into the PHPMyAdmin MySQL table, so it is very troublesome, so enter today's theme, today recommended plugins: Optimize DB, it allows you to optimize MySQL data tables directly in the WordPress backend.

The plug-in installation is very simple, you can upload activated, after activation, the background in WordPress Tools = Optimize DB will be able to optimize the MySQL data table:

Optimization WordPress MySQL table in the background

The image above is the database redundancy overhead, click Optimize Now, you can optimize.

Of course, we can modify this plugin, let it automatically timed to optimize the database.