#5 by installs
LiteSpeed Cache
All-in-one unbeatable acceleration & PageSpeed improvement: caching, image/CSS/JS optimization...
- Installs
- 7+ million
- Rating
- 4.8 (2.8K)
- Updated
- 11 days ago
Index WP MySQL For Speed
Speed up your WordPress site by adding high-performance keys (database indexes) to your MariaDB / MySQL database tables.
- Active installs
- 50,000+
- #721 of 1,000
- Downloads, all time
- 853.6K
- 853,577
- Downloads, 30 days
- 52.6K
- 7K in the last 7
- Rating
- 4.8 / 5
- 99 reviews
- Last updated
- 26 days ago
- Oct 5, 2026
- Version
- 1.6.0
- 40 releases
Upkeep and compatibility
| Last updated | October 5, 2026Updated in the last 3 months |
|---|---|
| Tested up to | WordPress 7.1.4Covers WordPress 7.1.4, the current release |
| Needs WordPress | 4.2 or newer |
| Needs PHP | 5.6 or newer |
| First published | June 13, 2021 |
| Support, last two months | 4 of 4 threads resolved (100%) |
Reviews
4.8 / 5 from 99 reviews
| 5 stars | 95 |
|---|---|
| 4 stars | 0 |
| 3 stars | 0 |
| 2 stars | 1 |
| 1 star | 3 |
Downloads, last 30 days
What the author says it does
How do I use this plugin?
After you install and activate this plugin, visit the Index MySQL Tool under the Tools menu. From there you can press the Add Keys Now button. If you have large tables, use it with WP-CLI instead to avoid timeouts. See the WP-CLI section to learn more.
What does it do for my site?
This plugin works to make your MySQL database work more efficiently by adding high-performance keys to the tables you choose. On request it monitors your site’s use of your MySQL database to detect which database operations are slowest. It is most useful for large sites: sites with many users, posts, pages, and / or products.
You can use it to restore WordPress’s default keys if need be.
What is this all about?
Where does WordPress store all that stuff that makes your site great? Where are your pages, posts, products, media, users, custom fields, metadata, and all your valuable content? All that data is in the MySQL relational database management system. (Many hosting providers and servers use the MariaDB fork of the MySQL software; it works exactly the same way as MySQL itself.)
As your site grows, your MySQL tables grow. Giant tables can make your page loads slow down, frustrate your users, and even hurt your search-engine rankings. And, bulk imports can take absurd amounts of time. What can you do about this?
The opening of the plugin's own description. The full text, installation notes and changelog are on its WordPress.org page.
Questions the author answers
Should I back up my site before using this?
Yes. You already knew that.
I don’t see any changes to my database speed. Why not?
- Just installing and activating the plugin is not enough to make it work. Don’t forget to visit the Index MySQL Tool under the Tools menu. From there you can press the Add Keys Now button.
- On a modestly sized site (with a few users and a few hundred posts) your database may be fast enough without these keys. The speed improvements are most noticeable on larger sites with many posts and products.
I use a nonstandard database table prefix. Will this work ?
Yes. Some WordPress databases have nonstandard prefixes. That is, their tables are named something_posts, something_postmeta, and so forth instead of wp_posts and wp_postmeta. This works with those databases.
My WordPress host offers MariaDB, not MySQL. Can I use this plugin?
Yes.
Which versions of MySQL and MariaDB does this support?
MySQL versions 5.5.62 and above, 5.6.4 and above, 8 and above. MariaDB versions 5.5.62 and above.
What database Storage Engine does this support?
InnoDB only. If your tables use MyISAM (the older storage engine) or the older COMPACT row format, this plugin offers to upgrade them for you.
Latest changelog entry
- Support the new keys on the posts table defined in WordPress 7.2.
- Handle the mu plugin update correctly.
- Provided provisioning suggestions for innodb_buffer_pool_size.
- Miscellaneous linting fixes.
Screenshots
Use Tools > Index MySQL to view the Dashboard panel. 
Choose tables and add High-Performance Keys. 
Start Monitoring Database Operations, and see saved monitors. 
View a saved monitor to see slow database queries.
Tagged
Plugins that share its tags
#36 by installs
WP Super Cache
A very fast caching engine for WordPress that produces static html files.
- Installs
- 1+ million
- Rating
- 4.3 (1.3K)
- Updated
- 31 days ago
#44 by installs
Speed Optimizer – The All-In-One Performance-Boosting Plugin
Boost your website performance and page speed, and increase conversions with powerful caching, frontend, media, and environment optimizations.
- Installs
- 1+ million
- Rating
- 4.2 (641)
- Updated
- 11 days ago
#47 by installs
WP Fastest Cache – WordPress Cache Plugin
The simplest and fastest WP Cache system
- Installs
- 1+ million
- Rating
- 4.9 (4.2K)
- Updated
- 21 days ago
#55 by installs
ManageWP Worker
A better way to manage dozens of WordPress websites.
- Installs
- 1+ million
- Rating
- 4.6 (679)
- Updated
- 2 months ago
Image Optimizer is an easy-to-use WordPress plugin that reduces image size through various compression and resizing techniques – all of which preserve …
- Installs
- 1+ million
- Rating
- 1.7 (81)
- Updated
- 39 days ago
Where this page's numbers come from
Read from the WordPress.org plugin API on , when WordPress 7.1.4 was the current release. WordPress.org rounds active installs into buckets. These are the directory's figures, not my verdict, and I haven't tested this plugin. The author takes donations at their donate page.