Overhead:wordpress database optimization

Published on:
Last updated:

This post is also available in: 日本語 (Japanese)

[Postscript] The case to use wordpress plugin is more good

If wordpress is normally displayed(not stopped),you should use wordpress plugin "WP-DBManager".

Please refer to the "“WP-DBManager”:plug-in to back up and optimization of wordpress database" for more information.

What is overhead?

The overhead, It is a wasted space that can be when you are in and out data into a database which is managed by the MYSQL("INSERT, DELETE, UPDATE").

Capacity of overhead and become greater, capacity to read from the database increases.

It cause heavy, or white page is displayed,or web site stop.

Solution of overhead

1.use the "wp-dbmanager"
2.optimize from PhpMyAdmin

1.use the "wp-dbmanager"

Please refer to the "“WP-DBManager”:plug-in to back up and optimization of wordpress database" for more information.

2.optimize from PhpMyAdmin

Please log in to PhpMyAdmin

Then, select the database name of wordpress.
Show the list of databases, such as the image below.

web_overhead001

web_overhead001

Then,put a check in the database table overhead occurs like the image below.

web_overhead002

web_overhead002

Finally, select "optimize table" like the image below. You are finished.

web_overhead003

web_overhead003

About
Kuniyoshi Takemoto is the founder of Amelt.net LLC, and editor of this blog(www.amelt.net).Learn more and follow me on LinkedIn.