This post is also available in: 日本語 (Japanese)
Contents
[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.
Then,put a check in the database table overhead occurs like the image below.
Finally, select "optimize table" like the image below. You are finished.