Index WP MySQL For Speed

How to Use This Plugin

Once you've installed and activated this plugin, navigate to the Index MySQL Tool located under the Tools menu. Click the Add Keys Now button to start the process. If your tables are large, consider using the WP-CLI to avoid timeouts. For more information, refer to the WP-CLI section.

Benefits of the Plugin

This plugin enhances the efficiency of your MySQL database by integrating high-performance keys into your selected tables. It can monitor your site's MySQL database usage to identify which operations are slowest, making it particularly useful for large sites with numerous users, posts, pages, or products. Additionally, it can restore WordPress's default keys if necessary.

Understanding the Plugin's Role

Your WordPress site's data - including pages, posts, products, media, users, custom fields, metadata, and content - is stored in the MySQL relational database management system. As your site expands, your MySQL tables also grow, which can slow down page loads, affect user experience, and even harm your search-engine rankings. This plugin's solution to these issues is to add database keys to your MySQL tables, enabling WordPress to locate the required information more efficiently.

Tables Enhanced by the Plugin

This plugin adds and updates keys in the following WordPress and WooCommerce tables:

• wp_comments
• wp_commentmeta
• wp_posts
• wp_postmeta
• wp_termmeta
• wp_users
• wp_usermeta
• wp_options
• wp_wc_orders_meta
• wp_woocommerce_order_itemmeta
• wp_automatewoo_log_meta

For optimal results, you only need to run this plugin once.

Monitoring Your Database Operations

On the Index MySQL page (