WordPressのデータベースを最適化する方法をお探しですか？
データベースを最適化することで、不要なデータを一掃し、データベースサイズを縮小してパフォーマンスを向上させます。
この投稿では、WordPressのデータベースをワンクリックで簡単に最適化する方法をご紹介します。
なぜWordPressデータベースを最適化するのか？
WordPressをしばらく使っていると、投稿リビジョン、スパムコメント、ゴミ箱内のゴミ、一時的なオプション、孤立したメタデータなど、データベース内に無駄なデータがたくさんあることでしょう。
このデータはWordPressデータベースのサイズを増加させ、WordPressのバックアップに多くのディスク容量と復元時間がかかることを意味します。
この不要なデータをクリーンアップすることで、WordPressデータベースのサイズが大幅に削減され、バックアップの高速化、リストアの容易化、データベースパフォーマンスの向上が実現します。
それでは、WordPressのデータベースを簡単に最適化し、ごちゃごちゃしたものを取り除く方法を見ていきましょう。
動画チュートリアル
動画が気に入らなかったり、もっと説明が必要な場合は、このまま読み進めてください。
WordPressデータベースを最適化する方法
WordPressのデータベースを操作することになるので、先に進む前にWordPressの完全なバックアップを作成しておく必要があります。
次に、WP-Optimizeプラグインをインストールして有効化する必要があります。詳しくは、WordPressプラグインのインストール方法のステップバイステップガイドをご覧ください。
このプラグインは、人気のWordPressバックアッププラグイン、UpdraftPlusを開発した同じチームによってビルトインされています。さらに詳しく知りたい方は、WP-Optimizeのレビューをご覧ください。
プラグインを有効化すると、WordPress管理バーにWP-Optimizeという新しいメニュー項目が追加されます。それをクリックすると、プラグインの設定ページに移動します。
プラグインがデータベースに対して実行する操作のリストが表示されます。これらの項目をよく確認し、現在実行したくない項目のチェックを外してください。
赤でマークされた項目は、より集中的なデータベース操作が必要です。操作中にプロセスが中断されると、データが破損する可能性があります。そのため、赤で表示されている項目を選択する前に、WordPressサイトのバックアップを作成することを強くお勧めします。
項目を選択したら、上部にある「選択した項目すべてで実行」ボタンをクリックする。
プラグインはWordPressデータベースの最適化を開始し、進捗状況を表示します。
これですべてです。WordPressデータベースの最適化が完了しました！
注：MySQLデータベーステーブルがInnoDBエンジンを使用している場合、WP-Optimizeはデータベーステーブルの最適化を行いません。phpMyAdminを使用して手動でその操作を行うことができます。詳しい手順については、phpMyAdminを使用したWordPressデータベース管理の初心者ガイドをご覧ください。
WordPressデータベースのエキスパートガイド
WordPressのデータベースを最適化する方法はおわかりいただけたと思いますが、WordPressのデータベースに関連する他のガイドもご覧ください：
- 用語集データベース
- 用語集MySQL
- 用語集クエリー
- 初心者のためのphpMyAdminによるWordPressデータベース管理ガイド
- WordPressデータベース内のテキストを簡単に検索・置換する方法
- WordPressデータベースを手動でバックアップする方法
- WordPressデータベースを初期設定に戻す方法
- WordPressデータベースの接頭辞を変更してセキュリティを向上させる方法
- WordPressでカスタムデータベースエラーページを追加する方法
- ベストWordPressデータベースプラグイン – Expert Pick
- WordPressデータベースの修復方法（6つの簡単な方法）
この投稿がWordPressデータベースの最適化にお役に立てば幸いです。WordPressのスピードとパフォーマンスを向上させる究極のガイドや、専門家が選ぶ最高のInstagram WordPressプラグインもご覧ください。
If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.
Syed Balkhi says
Hey WPBeginner readers,
Did you know you can win exciting prizes by commenting on WPBeginner?
Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
You can get more details about the contest from here.
Start sharing your thoughts below to stand a chance to win!
Usman says
Is it necessary to take a backup first then Optimize the Database?
WPBeginner Support says
While not necessary, we strongly recommend it on the off chance something goes wrong or you run into an error. While it is rare for that to happen, it is better to be safe
管理者
Nikita Shevchenko says
Hello! Great article! I have one question. Can I use this plugin simultaneously with autooptimize and wp3 total cache plugins?
Editorial Staff says
This is a plugin that you can use and then disable once you’re done cleaning the database. We recommend using this plugin once every 6 – 12 months.
管理者
ANTESH KUMAR SINGH says
How to fix “Optimize InnoDB tables anyway” in WP-Optimize plugin?
Have any solution to optimize InnoDB tables in WordPress?
James Finn says
Hey guys,
In this article:
/plugins/how-to-clean-up-your-wordpress-database-for-improved-performance/
It is stated:
“… the main [benefit of wp-sweep over wp-optimize] is that it uses proper WordPress delete functions as much as possible instead of running direct delete MySQL queries. Whereas the WP-Optimize plugin uses direct delete SQL queries which can leave orphaned data left behind. In other words, WP-Sweep is a better coded plugin than WP-Optimize.”
Quote and closed quote!
Perhaps you can explain why you have two clearly contradictory articles published on your site at the same time. Edit one, or the other, please!
An incredibly influential site such as this needs more attentive editorial review.
Thanks bunches!
WPBeginner Support says
Hi James,
We often recommend plugins that do the same thing. If there is a difference, then we also try to highlight it as you have quoted. One great thing about WordPress is that you often have plenty of excellent solutions for a problem.
管理者
Neal Umphred says
You used to recommend WP-Sweep for this service:
(https://www.wpbeginner.com/plugins/how-to-clean-up-your-wordpress-database-for-improved-performance/).
What happened?
WPBeginner Support says
Hey Neal,
We still recommend it. You can use either of these two plugins for the job.
管理者
Neal Umphred says
Thanks for the response!
If I use WP-Optimize, do I need an occasional clean-up from WP-Sweep?
Ian Spare says
In a previous article (https://www.wpbeginner.com/plugins/delete-old-post-revisions-in-wordpress-with-better-delete-revision/) you made an update stating that post revisions would not impact database performance. Are you now saying they do?
Mayank Debnath says
Yea! I am confused too ..
Ian Spare says
It’s clear that actions like removing post revisions will make no difference whatsoever to “database performance”. I think the confusion is caused by some misunderstanding about how relational databases work and specifically about how indexed queries are executed.
The problem is exacerbated by so many WordPress users being quite certain that optimising their database is required. Given that relations databases and related technologies like Indexed Sequential Access Method (ISAM) on which the internals are based have been around for some 50 years it ought to be well understood.
The entire point of using a database is to access data in a way that scalable. The time it takes to find an indexed record, for example, a published WordPress post, is not dependent on the size of the database.
I’d invite the authors of this article to actually test this. Create a WordPress install and create a few thousand revisions of a post. You’ll find it makes zero difference to performance.
The time it takes to find a post is dependent on the number of seeks it takes. You can work this out like this:
log(row_count) / log(index_block_length / 3 * 2 / (index_length + data_pointer_length)) + 1
I can tell you that the number of seeks will not increase between thousands of revisions and tens of thousands. You’ll get an extra seek when you enter the hundred of thousands of rows. But, the odds are it’s in query cache anyway so it won’t matter.
I know from testing, for no reason at all, that having a post with 200,000 revisions is just as quick to access as one with none.
Matilda Moo says
So if my host is saying my sites keep going down because i need to optimise my db, really it’s the number of hits/seeks that my hosting can’t cope with?
Rob Smelik says
I can’t speak for the author but thought I would throw some thoughts out there.
When it comes to loading your site on the front end, WordPress is actually smart enough to ignore previous revisions as it loads individual pages. However, overall database bloat can slow down a site if you have a large site with many pages and posts. Post revisions do add to the overall size of a database but are certainly not the only contributor. That being said… anything that you can do to reduce the size of your database will keep your site running at peak performance.
I have been using WP Optimize for years both on personal and client sites and can honestly say it does an excellent job at keeping your database clean. I have also noticed speed boosts when installing on older sites with larger databases that haven’t been optimized. With regard to post revisions, It has a great setting that allows you to limit the number of stored revisions. I keep it set at about 10 which is more than enough for post revision backup purposes.
I believe the premium version of the plugin also lets you schedule optimization cycles without having to manually go in and click the optimize button.
WPBeginner Support says
Hi Ian Spare,
Post revisions don’t affect database performance or your site’s page load times. However, they do increase database size. On older websites with lots of content, cleaning up or limiting post revisions can significantly reduce database backup file size. This means you will be to do on-demand backups, restore from backups, or move backup files around a bit faster. It will also save space on your cloud storage service where you save your backups.
管理者
Ian Spare says
Thanks, I think you’re moving closer to an accurate position now.
I think we can dismiss size considerations pretty quickly. A MySQL dump of WordPress database is pretty small. It’s highly compressible data as well, I’d suggest as pure text with a midrange compressional level you’d get around 10:1.
So I suggest this site might have 1000 posts with 10 revisions per post which for some (unlikely) reason are all the same size (in practice, they’ll be smaller you’d think). And we’ll say a post is about 2800 characters in size because that’s around the size of your post here, we’ll add a bit because it’s not going to make a lot of difference and say 3000 chars.
1000 * 10 * 3000 = 30000000
or about 28mb which is going to be around 2.8mb in compressed size.
Which is, in technical terms, diddly squat. A handful of images at best.
The footprint of an average WordPress post is very often the associated images. They’ll need backing up as well. That footprint will only be trivially impacted by the number of revisions.
There’s not a realistic chance these backups will fit into, for example, the free cloud storage of 2gb on Dropbox. So, anyone storing backups in the cloud might well have paid for a service which will be delivering unlimited storage (ie the jetpack backup service) or terabytes.
It’s hardly a realistic concern to be bothered about a couple of mb in size for a backup file. I appreciate there’ll be some who’ll produce a contrived use case where 10k makes a difference which is fine, I’m just saying in general usage, this is nothing.