Skip to main content
Agency Program Get 2× more leads and save 50% on hosting. Built for agencies ready to grow. Book a call
Index WP MySQL For Speed icon

Index WP MySQL For Speed

v1.5.2
by OllieJones · 4.8 (86 reviews)

Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.

40K+ active installs Updated Oct 28, 2024 Tested to 6.7.2 Requires PHP 5.6
Try Demo Download
Pre-installed Ready in ~10s No card

About Index WP MySQL For Speed

This plugin helps to optimize your WordPress site's MySQL database by adding high-performance keys to the tables. It improves the speed and efficiency of your site, particularly for large sites with a lot of content. You can also monitor your database operations and use WP-CLI for better performance.

Screenshots

Index WP MySQL For Speed screenshot
Index WP MySQL For Speed screenshot
Index WP MySQL For Speed screenshot
Index WP MySQL For Speed screenshot
Index WP MySQL For Speed screenshot
Index WP MySQL For Speed screenshot

Frequently asked questions

How do I use this plugin?
After installing and activating the plugin, visit the Index MySQL Tool under the Tools menu. Press the "Add Keys Now" button. For large tables, use WP-CLI to avoid timeouts.
What does this plugin do for my site?
This plugin makes your MySQL database more efficient by adding high-performance keys to chosen tables. It can monitor your site's database use to detect slow operations. It is most useful for large sites with many users, posts, pages, or products.
What is the purpose of this plugin?
WordPress stores all site content in a MySQL relational database. As your site grows, large tables can slow down page loads and impact search engine rankings. This plugin addresses this by adding database keys to improve performance.

Changelog

1.5.2

Correct release error.

1.5.1

Add support for the WooCommerce tables wp_automatewoo_log_meta, wp_wc_orders_meta, and wp_woocommerce_order_itemmeta.

1.4.19

Report information about host machine using meminfo and procinfo if those files are available.

1.4.18

Security update.

1.4.17

Back out a miscellaneous bug fix from the previous version. It was an attempt to avoid a warning from Query Monitor’s hooks display.
Upload the full MariaDB / MySQL version information with monitors as well as metadata.

1.4.16

(no changes to keys)
WordPress 6.5 compatibility.
Support WordPress versions back to 4.2 (At MDDHosting’s request).
Avoid attempting to upgrade from storage engines except MyISAM and Aria.
WP-CLI upgrade, enable, and disable commands are idempotent now. They don’t generate errors when they find no tables to process.
Miscellaneous bug fixes

Try other plugins

Yoast SEO icon

Yoast SEO

4.8 · 10M+ installs

Improve your WordPress SEO: Write better content and have a fully optimized WordPress site using the Yoast SEO…