{"id":3255,"date":"2025-02-14T09:22:34","date_gmt":"2025-02-14T09:22:34","guid":{"rendered":"https:\/\/s-o-s.net\/index-wp-mysql-for-speed\/"},"modified":"2025-02-14T09:22:34","modified_gmt":"2025-02-14T09:22:34","slug":"index-wp-mysql-for-speed","status":"publish","type":"post","link":"https:\/\/s-o-s.net\/en_gb\/index-wp-mysql-for-speed\/","title":{"rendered":"Index WP MySQL For Speed"},"content":{"rendered":"<p> <br \/>\n<\/p>\n<article id=\"post-142465\" class=\"alignwide post-142465 plugin type-plugin status-publish hentry plugin_tags-index plugin_tags-key plugin_tags-mysql plugin_tags-performance plugin_tags-wp-cli plugin_category-performance plugin_category-utilities-and-tools plugin_contributors-olliejones plugin_contributors-rjasdfiii plugin_business_model-community plugin_committers-olliejones plugin_committers-rjasdfiii\">\n<div class=\"plugin-banner\" id=\"plugin-banner-index-wp-mysql-for-speed\"><\/div>\n<header class=\"plugin-header\">\n<div class=\"entry-heading-container\">\n<div>\n<div class=\"entry-thumbnail\">\n\t\t\t\t\t<img decoding=\"async\" class=\"plugin-icon\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/icon-128x128.png?rev=2652667\" alt=\"\">\t\t\t\t<\/div>\n<div>\n<h1 class=\"plugin-title\">Index WP MySQL For Speed<\/h1>\n<p>\t\t\t\t\t<span class=\"byline\">By <span class=\"author vcard\"><a target=\"_blank\" class=\"url fn n\" href=\"https:\/\/profiles.wordpress.org\/olliejones\/\" rel=\"noopener\">OllieJones<\/a><\/span><\/span>\n\t\t\t\t<\/div>\n<\/p><\/div>\n<div class=\"plugin-actions\">\n<div class=\"wp-block-button is-small plugin-download download-button\"><a target=\"_blank\" class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/downloads.wordpress.org\/plugin\/index-wp-mysql-for-speed.1.5.2.zip\" rel=\"noopener\">Download<\/a><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/header>\n<p><!-- .entry-header --><\/p>\n<p>\t<span id=\"description\"><\/span><br \/>\n\t<span id=\"reviews\"><\/span><br \/>\n\t<span id=\"installation\"><\/span><br \/>\n\t<span id=\"developers\"><\/span><br \/>\n\t<span id=\"advanced\" class=\"\"><\/span><br \/>\n\t<span id=\"section-links\"><\/p>\n<ul class=\"tabs clear\">\n<li id=\"tablink-description\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/index-wp-mysql-for-speed\/#description\" rel=\"noopener\">Details<\/a><\/li>\n<li id=\"tablink-reviews\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/index-wp-mysql-for-speed\/#reviews\" rel=\"noopener\">Reviews<\/a><\/li>\n<li id=\"tablink-installation\">\n\t\t\t\t<a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/index-wp-mysql-for-speed\/#installation\" rel=\"noopener\">Installation<\/a>\n\t\t\t<\/li>\n<li id=\"tablink-developers\"><a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/index-wp-mysql-for-speed\/#developers\" rel=\"noopener\">Development<\/a><\/li>\n<\/ul>\n<div id=\"link-support\">\n\t\t\t<a target=\"_blank\" href=\"https:\/\/wordpress.org\/support\/plugin\/index-wp-mysql-for-speed\/\" rel=\"noopener\">Support<\/a>\n\t\t<\/div>\n<p>\t<\/span><br \/>\n\t<script type=\"text\/javascript\">if ( '#changelog' == window.location.hash ) { window.setTimeout( function() { window.location.hash=\"#developers\"; }, 10 ); }<\/script><\/p>\n<div class=\"entry-content\">\n<div id=\"tab-description\" class=\"plugin-description section\">\n<h2 id=\"description-header\">Description<\/h2>\n<h4>How do I use this plugin?<\/h4>\n<p>After you install and activate this plugin, visit the Index MySQL Tool under the Tools menu. From there you can press the <em>Add Keys Now<\/em> button. If you have large tables, use it with <a target=\"_blank\" href=\"https:\/\/wp-cli.org\/\" rel=\"nofollow ugc noopener\">WP-CLI<\/a> instead to avoid timeouts. See the WP-CLI section to learn more.<\/p>\n<h4>What does it do for my site?<\/h4>\n<p>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\u2019s 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.<\/p>\n<p>You can use it to restore WordPress\u2019s default keys if need be.<\/p>\n<h4>What is this all about?<\/h4>\n<p>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 <a target=\"_blank\" href=\"https:\/\/www.mysql.com\/\" rel=\"nofollow ugc noopener\" class=\"broken_link\">MySQL<\/a> relational database management system. (Many hosting providers and servers use the <a target=\"_blank\" href=\"https:\/\/mariadb.org\/\" rel=\"nofollow ugc noopener\">MariaDB<\/a> fork of the MySQL software; it works exactly the same way as MySQL itself.)<\/p>\n<p>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?<\/p>\n<p>You can install and use a database cleaner plugin to get rid of old unwanted data and reorganize your tables. That makes them smaller, and therefore faster. That is a good and necessary task. That is not the task of this plugin. You can, if your hosting provider supports it, install and use a <a target=\"_blank\" href=\"https:\/\/developer.wordpress.org\/reference\/classes\/wp_object_cache\/#persistent-cache-plugins\" rel=\"nofollow ugc noopener\">Persistent Object Cache plugin<\/a> to reduce traffic to your database. That is not the task of this plugin either.<\/p>\n<p>This plugin adds database <a target=\"_blank\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/mysql-indexes.html\" rel=\"nofollow ugc noopener\" class=\"broken_link\">keys<\/a> (also called indexes) to your MySQL tables to make it easier for WordPress to find the information it needs. All relational database management systems store your information in long-lived <em>tables<\/em>. For example, WordPress stores your posts and other content in a table called <em>wp_posts<\/em>, and custom post fields in another table called <em>wp_postmeta<\/em>.  A successful site can have thousands of posts and hundreds of thousands of custom post fields. MySQL has two jobs:<\/p>\n<ol>\n<li>Keep all that data organized.<\/li>\n<li>Find the data it needs quickly.<\/li>\n<\/ol>\n<p>To do its second job, MySQL uses database keys. Each table has one or more keys. For example, <code>wp_posts<\/code> has a key to let it quickly find posts when you know the author. Without its <em>post_author<\/em> key MySQL would have to scan every one of your posts looking for matches to the author you want. Our users know what that looks like: slow. With the key, MySQL can jump right to the matching posts.<\/p>\n<p>In a new WordPress site with a couple of users and a dozen posts, the keys don\u2019t matter very much. As the site grows the keys start to matter, a lot. Database management systems are designed to have their keys updated, adjusted, and tweaked as their tables grow. They\u2019re designed to allow the keys to evolve without changing the content of the underlying tables. In organizations with large databases adding, dropping, or altering keys doesn\u2019t change the underlying data. It is a routine maintenance task in many data centers. If changing keys caused databases to lose data, the MySQL and MariaDB developers would hear howling not just from you and me, but from many heavyweight users. (You should still back up your WordPress instance of course.)<\/p>\n<p>Better keys allow WordPress\u2019s code to run faster <em>without any code changes<\/em>.  Experience with large sites shows that many MySQL slowdowns can be improved by better keys. Code is poetry, data is treasure, and database keys are grease that makes code and data work together smoothly.<\/p>\n<h4>Which tables does the plugin add keys to?<\/h4>\n<p>This plugin adds and updates keys in these WordPress and WooCommerce tables.<\/p>\n<ul>\n<li>wp_comments<\/li>\n<li>wp_commentmeta<\/li>\n<li>wp_posts<\/li>\n<li>wp_postmeta<\/li>\n<li>wp_termmeta<\/li>\n<li>wp_users<\/li>\n<li>wp_usermeta<\/li>\n<li>wp_options<\/li>\n<li>wp_wc_orders_meta<\/li>\n<li>wp_woocommerce_order_itemmeta<\/li>\n<li>wp_automatewoo_log_meta<\/li>\n<\/ul>\n<p>You only need run this plugin once to get its benefits.<\/p>\n<h4>How can I monitor my database\u2019s operation?<\/h4>\n<p>On the Index MySQL page (from your Tools menu on your dashboard), you will find the \u201cMonitor Database Operations\u201d tab. Use it to request monitoring for a number of minutes you choose.<\/p>\n<p>You can monitor<\/p>\n<ul>\n<li>either the site (your user-visible pages) or the dashboard, or both.<\/li>\n<li>all pageviews, or a random sample. (Random samples are useful on very busy sites to reduce monitoring overhead.)<\/li>\n<\/ul>\n<p>Once you have gathered monitoring information, you can view the captured queries, and sort them by how long they take. Or you can save the monitor information to a file and show it to somebody who knows about database operations. Or you can upload the monitor to the plugin\u2019s servers so the authors can look at it.<\/p>\n<p>It\u2019s a good idea to monitor for a five-minute interval at a time of day when your site is busy. Once you\u2019ve completed a monitor, you can examine it to determine which database operations are slowing you down the most.<\/p>\n<p>Please consider uploading your saved monitors to the plugin\u2019s servers. It\u2019s how we learn from your experience to keep improving. Push the Upload button on the monitor\u2019s tab.<\/p>\n<h4>WP-CLI command line operation<\/h4>\n<p>This plugin supports <a target=\"_blank\" href=\"https:\/\/wp-cli.org\/\" rel=\"nofollow ugc noopener\">WP-CLI<\/a>.  When your tables are large this is the best way to add the high-performance keys: it doesn\u2019t time out.<\/p>\n<p>Give the command <code>wp help index-mysql<\/code> for details. A few examples:<\/p>\n<ul>\n<li><code>wp index-mysql status<\/code> shows the current status of high-performance keys.<\/li>\n<li><code>wp index-mysql enable --all<\/code> adds the high-performance keys to all tables that don\u2019t have them.<\/li>\n<li><code>wp index-mysql enable wp_postmeta<\/code> adds the high-performance keys to the postmeta table.<\/li>\n<li><code>wp index-mysql disable --all<\/code> removes the high-performance keys from all tables that have them, restoring WordPress\u2019s default keys.<\/li>\n<li><code>wp index-mysql enable --all --dryrun<\/code> writes out the SQL statements necessary to add the high-performance keys to all tables, but does not run them.<\/li>\n<li><code>wp index-mysql enable --all --dryrun | wp db query<\/code> writes out the SQL statements and pipes them to wp db to run them.<\/li>\n<\/ul>\n<p>Note: avoid saving the \u2013dryrun output statements to run later. The plugin generates them to match the current state of your tables.<\/p>\n<h4>Why use this plugin?<\/h4>\n<p>Three reasons (maybe four):<\/p>\n<ol>\n<li>to save carbon footprint.<\/li>\n<li>to save carbon footprint.<\/li>\n<li>to save carbon footprint.<\/li>\n<li>to save people time.<\/li>\n<\/ol>\n<p>Seriously, the microwatt hours of electricity saved by faster web site technologies add up fast, especially at WordPress\u2019s global scale.<\/p>\n<h4>How can I learn more about making my WordPress site more efficient?<\/h4>\n<p>We offer several plugins to help with your site\u2019s database efficiency. You can <a target=\"_blank\" href=\"https:\/\/www.plumislandmedia.net\/wordpress\/performance\/optimizing-wordpress-database-servers\/\" rel=\"nofollow ugc noopener\">read about them here<\/a>.<\/p>\n<h4>Credits<\/h4>\n<ul>\n<li>Michael Uno for Admin Page Framework.<\/li>\n<li>Marco Cesarato for LiteSQLParser.<\/li>\n<li>Allan Jardine for Datatables.net.<\/li>\n<li>Leho Kraav and Sebastian Sommer for suggesting the WooCommerce tables.<\/li>\n<li>Japreet Sethi for advice, and for testing on his large installation.<\/li>\n<li>Rick James for everything.<\/li>\n<li>Jetbrains for their IDE tools, especially PhpStorm. It\u2019s hard to imagine trying to navigate an epic code base without their tools.<\/li>\n<\/ul>\n<\/div>\n<div id=\"screenshots\" class=\"plugin-screenshots section\">\n<h2 id=\"screenshots-header\">Screenshots<\/h2>\n<ul class=\"plugin-screenshots\">\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-1.png?rev=2660091\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-1.png?rev=2660091\" alt=\"\"><\/a><figcaption>Use Tools &gt; Index MySQL to view the Dashboard panel.<\/figcaption><\/figure>\n<\/li>\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-2.png?rev=2660091\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-2.png?rev=2660091\" alt=\"\"><\/a><figcaption>Choose tables and add High-Performance Keys.<\/figcaption><\/figure>\n<\/li>\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-3.png?rev=2660091\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-3.png?rev=2660091\" alt=\"\"><\/a><figcaption>Start Monitoring Database Operations, and see saved monitors.<\/figcaption><\/figure>\n<\/li>\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-4.png?rev=2660091\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-4.png?rev=2660091\" alt=\"\"><\/a><figcaption>View a saved monitor to see slow database queries.<\/figcaption><\/figure>\n<\/li>\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-5.png?rev=3015488\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-5.png?rev=3015488\" alt=\"\"><\/a><figcaption>About the plugin.<\/figcaption><\/figure>\n<\/li>\n<li>\n<figure><a target=\"_blank\" href=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-6.png?rev=2660091\" rel=\"nofollow noopener\"><img decoding=\"async\" class=\"screenshot\" src=\"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/screenshot-6.png?rev=2660091\" alt=\"\"><\/a><figcaption>Use WP CLI to run the plugin\u2019s operations.<\/figcaption><\/figure>\n<\/li>\n<\/ul>\n<\/div>\n<div id=\"tab-installation\" class=\"plugin-installation section\">\n<h2 id=\"installation-header\">Installation<\/h2>\n<p>You may install this plugin by visiting Plugins &gt; Add New on your site\u2019s Dashboard, then searching for <em>Index WP MySQL For Speed<\/em> and following the usual installation workflow.<\/p>\n<p>When you activate it, it will copy <a target=\"_blank\" href=\"https:\/\/www.plumislandmedia.net\/reference\/filtering-database-changes-during-wordpress-updates\/\" rel=\"nofollow ugc noopener\">a php source file<\/a> into the <a target=\"_blank\" href=\"https:\/\/wordpress.org\/support\/article\/must-use-plugins\/\" rel=\"ugc noopener\">must-use plugins directory<\/a>, <code>wp-content\/mu-plugins<\/code>. Some sites\u2019 configurations prevent the web server from writing files into that directory. In that case the plugin will still work correctly. But, after WordPress core version upgrades you may have to revisit the Tools &gt; Index MySQL page and correct the keying on some tables. Why? The mu-plugin prevents core version updates from trying to change keys.<\/p>\n<h4>Composer<\/h4>\n<p>If you configure your WordPress installation using composer, you may install this plugin into your WordPress top level configuration with the command<\/p>\n<pre><code>composer require \"wpackagist-plugin\/index-wp-mysql-for-speed\":\"^1.4\"\n<\/code><\/pre>\n<p>During composer installation the plugin can automatically copy the necessary source file (see the previous section) into the must-use plugins directory. If you want that to happen, you should include these scripts in your top-level <code>composer.json<\/code> file.<\/p>\n<pre><code> \"scripts\": {\n         \"install-wp-mysql-mu-module\": [\n                 \"@composer --working-dir=wordpress\/wp-content\/plugins\/index-wp-mysql-for-speed install-mu-module\"\n         ],\n         \"post-install-cmd\": [\n                 \"@install-wp-mysql-mu-module\"\n         ],\n         \"post-update-cmd\": [\n                 \"@install-wp-mysql-mu-module\"\n         ]\n     },\n<\/code><\/pre>\n<\/div>\n<div id=\"faq\" class=\"plugin-faq section\">\n<h2 id=\"faq-header\">FAQ<\/h2>\n<dl>\n<dt id=\"should%20i%20back%20up%20my%20site%20before%20using%20this%3F\">\n<h3>Should I back up my site before using this?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes.<\/strong> You already knew that.<\/p>\n<\/dd>\n<dt id=\"i%20don%27t%20see%20any%20changes%20to%20my%20database%20speed.%20why%20not%3F\">\n<h3>I don\u2019t see any changes to my database speed. Why not?<\/h3>\n<\/dt>\n<dd>\n<ul>\n<li>Just installing and activating the plugin is <strong>not enough to make it work<\/strong>. Don\u2019t forget to visit the Index MySQL Tool under the Tools menu. From there you can press the <strong>Add Keys Now<\/strong> button.<\/li>\n<li>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.<\/li>\n<\/ul>\n<\/dd>\n<dt id=\"i%20use%20a%20nonstandard%20database%20table%20prefix.%20will%20this%20work%20%3F\">\n<h3>I use a nonstandard database table prefix. Will this work ?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes.<\/strong> Some WordPress databases have <a target=\"_blank\" href=\"https:\/\/codex.wordpress.org\/Creating_Tables_with_Plugins#Database_Table_Prefix\" rel=\"nofollow ugc noopener\">nonstandard prefixes<\/a>. That is, their tables are named <em>something_posts<\/em>, <em>something_postmeta<\/em>, and so forth instead of <em>wp_posts<\/em> and <em>wp_postmeta<\/em>. This works with those databases.<\/p>\n<\/dd>\n<dt id=\"my%20wordpress%20host%20offers%20mariadb%2C%20not%20mysql.%20can%20i%20use%20this%20plugin%3F\">\n<h3>My WordPress host offers MariaDB, not MySQL. Can I use this plugin?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes.<\/strong><\/p>\n<\/dd>\n<dt id=\"which%20versions%20of%20mysql%20and%20mariadb%20does%20this%20support%3F\">\n<h3>Which versions of MySQL and MariaDB does this support?<\/h3>\n<\/dt>\n<dd>\n<p>MySQL versions 5.5.62 and above, 5.6.4 and above, 8 and above. MariaDB versions 5.5.62 and above.<\/p>\n<\/dd>\n<dt id=\"what%20database%20storage%20engine%20does%20this%20support%3F\">\n<h3>What database Storage Engine does this support?<\/h3>\n<\/dt>\n<dd>\n<p><strong>InnoDB only.<\/strong> If your tables use MyISAM (the older storage engine) or the older COMPACT row format, this plugin offers to upgrade them for you.<\/p>\n<\/dd>\n<dt id=\"what%20tables%20and%20keys%20does%20the%20plugin%20change%3F\">\n<h3>What tables and keys does the plugin change?<\/h3>\n<\/dt>\n<dd>\n<p><a target=\"_blank\" href=\"https:\/\/www.plumislandmedia.net\/index-wp-mysql-for-speed\/tables_and_keys\/\" rel=\"nofollow ugc noopener\">Please read this<\/a>.<\/p>\n<\/dd>\n<dt id=\"is%20this%20safe%3F%20can%20i%20add%20high-performance%20keys%20and%20revert%20back%20to%20wordpress%20standard%20keys%20safely%3F\">\n<h3>Is this safe? Can I add high-performance keys and revert back to WordPress standard keys safely?<\/h3>\n<\/dt>\n<dd>\n<p>Yes. it is safe to add keys and revert them. Changing keys is a routine database-maintenance operation.<\/p>\n<p>As you know you should still keep backups of your site: other things can cause data loss.<\/p>\n<\/dd>\n<dt id=\"my%20site%20uses%20woocommerce%20hpos%20%28high%20performance%20order%20storage%29.%20is%20this%20plugin%20still%20helpful%3F\">\n<h3>My site uses WooCommerce HPOS (High Performance Order Storage). Is this plugin still helpful?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes.<\/strong> WooCommerce still uses core WordPress tables for your shop\u2019s products, posts, pages, and users. This plugin adds high-performance keys to those tables.<\/p>\n<p>High Performance Order Storage, true to its name, stores your shop\u2019s orders in a more efficient way. Formerly orders were stored in those same core WordPress tables.<\/p>\n<\/dd>\n<dt id=\"is%20this%20plugin%20compatible%20with%20some%20other%20specific%20plugin%3F\">\n<h3>Is this plugin compatible with some other specific plugin?<\/h3>\n<\/dt>\n<dd>\n<p>This plugin only changes database indexes. If the other plugin does not change database indexes, it is very likely compatible with this one.<\/p>\n<p>Of course, if you find an incompatibility please open a support topic.<\/p>\n<\/dd>\n<dt id=\"i%20got%20a%20fatal%20error%20trying%20to%20add%20keys.%20how%20can%20i%20fix%20that%3F\">\n<h3>I got a fatal error trying to add keys. How can I fix that?<\/h3>\n<\/dt>\n<dd>\n<p>Sometimes the Index WP MySQL For Speed plugin for WordPress generates errors when you use it to add keys. These can look like this or similar:<\/p>\n<pre><code>Fatal error: Uncaught ImfsException: [0]: Index for table 'wp_postmeta' is corrupt; try to repair it\n<\/code><\/pre>\n<p>First, don\u2019t panic. This (usually) does not mean your site has been corrupted. It simply means your MariaDB or MySQL server was not able to add the keys to that particular table. Your site will still function, but you won\u2019t get the benefit of high-performance keys on the particular table. Very large tables are usually the ones causing this kind of error. Very likely you ran out of temporary disk space on your MariaDB or MySQL database server machine. The database server makes a temporary copy of a table when you add keys to it; that allows it to add the keys without blocking your users.<\/p>\n<p>It\u2019s possible to correct this problem by changing your MariaDB or MySQL configuration. <a target=\"_blank\" href=\"https:\/\/wordpress.org\/support\/topic\/fatal-error-uncaught-exception-29\/\" rel=\"ugc noopener\">Instructions are here<\/a>.<\/p>\n<\/dd>\n<dt id=\"what%20happens%20to%20my%20tables%20and%20keys%20during%20a%20wordpress%20version%20update%3F\">\n<h3>What happens to my tables and keys during a WordPress version update?<\/h3>\n<\/dt>\n<dd>\n<p>If the plugin is activated during a WordPress version update, it prevents the update workflow from removing your high-performance keys (Version 1.4.7).<\/p>\n<\/dd>\n<dt id=\"my%20site%20has%20thousands%20of%20registered%20users.%20my%20users%2C%20posts%2C%20and%20pages%20panels%20in%20my%20dashboard%20are%20still%20load%20slowly%20even%20with%20this%20plugin.\">\n<h3>My site has thousands of registered users. My Users, Posts, and Pages panels in my dashboard are still load slowly even with this plugin.<\/h3>\n<\/dt>\n<dd>\n<p>We have another plugin to handle lots of users, <a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/index-wp-users-for-speed\/\" rel=\"ugc noopener\">Index WP Users For Speed<\/a>. Due to the way WordPress handles users, just changing database keys is not enough to solve those performance problems.<\/p>\n<\/dd>\n<dt id=\"how%20can%20i%20enable%20persistent%20object%20caching%20on%20my%20site%3F\">\n<h3>How can I enable persistent object caching on my site?<\/h3>\n<\/dt>\n<dd>\n<p>Persistent object caching can help your site\u2019s database performance by reducing its workload. You can read about it <a target=\"_blank\" href=\"https:\/\/developer.wordpress.org\/reference\/classes\/wp_object_cache\/#persistent-cache-plugins\" rel=\"nofollow ugc noopener\">here<\/a>. If your hosting provider doesn\u2019t offer redis or memcached cache-server technology you can try using our <a target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/sqlite-object-cache\/\" rel=\"ugc noopener\">SQLite Object Cache<\/a> plugin for the purpose.<\/p>\n<\/dd>\n<dt id=\"why%20did%20the%20size%20of%20my%20tables%20grow%20when%20i%20added%20high-performance%20keys%3F\">\n<h3>Why did the size of my tables grow when I added high-performance keys?<\/h3>\n<\/dt>\n<dd>\n<p>Database keying works by making copies of your table\u2019s data organized in ways that are easy to randomly access. Your MariaDB or MySQL server automatically maintains the copies of your data as you insert or update rows to each table.  And, the keying task adjusts the amount of free space in each block of your table\u2019s data in preparation for the insertion of new rows. When free space is available, inserting new rows doesn\u2019t require relatively slow block splits. Tables that have been in use for a long time often need new free space in many blocks. When adding keys, it is normal for table sizes to increase. It\u2019s the oldest tradeoff in computer science: time vs. space.<\/p>\n<\/dd>\n<dt id=\"will%20the%20new%20keys%20be%20valid%20for%20new%20data%20in%20the%20tables%3F\">\n<h3>Will the new keys be valid for new data in the tables?<\/h3>\n<\/dt>\n<dd>\n<p><strong>Yes<\/strong>. Once the high-performance keys are in place MariaDB and MySQL automatically maintain them as you update,  delete, or insert rows of data to your tables. There is no need to do anything to apply the keys to new data: the DBMS software does that for you.<\/p>\n<\/dd>\n<dt id=\"how%20do%20i%20revert%20to%20wordpress%27s%20standard%20keys%2C%20undoing%20the%20action%20of%20this%20plugin%3F\">\n<h3>How do I revert to WordPress\u2019s standard keys, undoing the action of this plugin?<\/h3>\n<\/dt>\n<dd>\n<p>You can revert the keys from the Index MySQL Tool under the Tools menu, or use the wp-cli command <code>wp index-mysql disable --all<\/code>. <em>Notice<\/em> that if you deactivate or delete the plugin without doing this, the high-performance keys <em>remain<\/em>.<\/p>\n<\/dd>\n<dt id=\"how%20do%20i%20get%20an%20answer%20to%20another%20question%3F\">\n<h3>How do I get an answer to another question?<\/h3>\n<\/dt>\n<dd>\n<p>Please see more questions and answers <a target=\"_blank\" href=\"https:\/\/plumislandmedia.net\/index-wp-mysql-for-speed\/faq\/\" rel=\"nofollow ugc noopener\">here<\/a>.<\/p>\n<\/dd>\n<\/dl>\n<\/div>\n<div id=\"tab-reviews\" class=\"plugin-reviews section\">\n<h2 id=\"reviews-header\">Reviews<\/h2>\n<div class=\"plugin-reviews\">\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/6106bc5e3abccd66f196d133fa692d0c6c53cc2cac1b58528c510ee8de9e791e?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/6106bc5e3abccd66f196d133fa692d0c6c53cc2cac1b58528c510ee8de9e791e?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/elegant-way-to-speed-up-woo-sites\/\" rel=\"noopener\">Elegant way to speed up Woo sites<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/headwall\/\" title=\"Posts by Paul\" rel=\"author noopener\">Paul<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">February 10, 2025<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">An excellent little plugin that does one thing, and does it well. I run it on all my Woo clients\u2019 sites now, with the WP CPI interface. Recommended.<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/9d8616c4f904cde25a9aa8d7e5a9ee5a9b603d6a84b2a55ef69f38c85159307c?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/9d8616c4f904cde25a9aa8d7e5a9ee5a9b603d6a84b2a55ef69f38c85159307c?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/simple-and-effective-plugin-36\/\" rel=\"noopener\">Simple and Effective Plugin<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/nmxde\/\" title=\"Posts by nmxde\" rel=\"author noopener\">nmxde<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">January 15, 2025<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">My favourite type of plugin: Solves a problem effectively in the most simple and unobtrusive way.<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/e64d87118cd9b414a087813f2914cad1d69a6523a3fe44ec9d9a8566e53eb1d8?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/e64d87118cd9b414a087813f2914cad1d69a6523a3fe44ec9d9a8566e53eb1d8?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/works-like-a-charm-2371\/\" rel=\"noopener\">Works like a charm<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/karlgallucks\/\" title=\"Posts by karlgallucks\" rel=\"author noopener\">karlgallucks<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">January 8, 2025<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">Thank you Ollie!<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/1f0e4070e161b5b87be424d83e0bd8b0985094a9da1abd3029f6e7c72154173b?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/1f0e4070e161b5b87be424d83e0bd8b0985094a9da1abd3029f6e7c72154173b?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/magical-solution\/\" rel=\"noopener\">Magical Solution<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/sgeray\/\" title=\"Posts by freevision\" rel=\"author noopener\">freevision<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">January 3, 2025<\/span><br \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"review-replies\">1 reply<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">Okay, I know exactly what this plugin does but I never thought about it until now, my product editing page that used to load in 11 seconds magically started loading in 2-3 seconds, thank you so much.<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/87840adbd0fa87663d38f87ca6d76ef85dfd23dbd76258cf1ea9c6e8122ba780?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/87840adbd0fa87663d38f87ca6d76ef85dfd23dbd76258cf1ea9c6e8122ba780?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/mariadb-100-cpu-but-thanks-to-this-plugin-the-breakthrough\/\" rel=\"noopener\">mariadb 100% cpu but thanks to this plugin the breakthrough<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/eddyg93\/\" title=\"Posts by eddyg93\" rel=\"author noopener\">eddyg93<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">November 24, 2024<\/span><br \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"review-replies\">1 reply<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">It was days that I had problems with mariadb that every time I opened the homepage or any article it started to go 100\/200% cpu, it became unmanageable, I tried a lot of solutions but nothing was solving, a friend found me this plugin that solved (at least from the first 4 hours it didn\u2019t happen anymore) the problem.Thank you very much.<\/div>\n<\/p><\/div>\n<\/article>\n<article class=\"plugin-review\">\n<div class=\"review-avatar\">\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/f731bd1ab0eb2acd6aee8eea248e8e0ff440053ff9de27f459e5b1bcaee7aa67?s=60&amp;d=retro&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/f731bd1ab0eb2acd6aee8eea248e8e0ff440053ff9de27f459e5b1bcaee7aa67?s=120&amp;d=retro&amp;r=g 2x\" class=\"avatar avatar-60 photo\" height=\"60\" width=\"60\">\t\t\t\t\t<\/div>\n<div class=\"review\">\n<header>\n<div class=\"header-top\">\n<div class=\"wporg-ratings\" aria-label=\"5 out of 5 stars\" data-title-template=\"%s out of 5 stars\" data-rating=\"5\" style=\"color:#ffb900;\"><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><span class=\"dashicons dashicons-star-filled\"><\/span><\/div>\n<h3 class=\"review-title\"><a target=\"_blank\" class=\"url\" href=\"https:\/\/wordpress.org\/support\/topic\/great-for-huge-databases\/\" rel=\"noopener\">Great for huge databases!<\/a><\/h3>\n<\/p><\/div>\n<div class=\"header-bottom\">\n\t\t\t\t\t\t\t\t<span class=\"review-author author vcard\"><a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/notblowingsmoke\/\" title=\"Posts by E-Liquids UK\" rel=\"author noopener\">E-Liquids UK<\/a><\/span><br \/>\n\t\t\t\t\t\t\t\t<span class=\"review-date\">October 2, 2024<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/header>\n<div class=\"review-content\">We have been using this plugin since its initial release, their updates are brilliant never a hitch and being a fast based ecommerce company we need all the speed we can get. Their most recent update covering post_meta tables is a welcomed addition to an already underrated plugin that should be built into core. We will continue to use these plugins on all our larger installs.<\/div>\n<\/p><\/div>\n<\/article><\/div>\n<p>\t\t<a target=\"_blank\" class=\"reviews-link\" href=\"https:\/\/wordpress.org\/support\/plugin\/index-wp-mysql-for-speed\/reviews\/\" rel=\"noopener\"><br \/>\n\t\t\tRead all 86 reviews\t\t<\/a><\/div>\n<div id=\"tab-developers\" class=\"plugin-developers section\">\n<h2 id=\"developers-header\">Contributors &amp; Developers<\/h2>\n<div class=\"plugin-contributors\">\n<p>\u201cIndex WP MySQL For Speed\u201d is open source software. The following people have contributed to this plugin.<\/p>\n<p><span class=\"screen-reader-text\">Contributors<\/span><\/p>\n<ul id=\"contributors-list\" class=\"contributors-list\">\n<li>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/6ac7c2e9bb1e43d09d87b780c06c09b391a52680c3b1512bcd094176376a1a26?s=32&amp;d=mm&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/6ac7c2e9bb1e43d09d87b780c06c09b391a52680c3b1512bcd094176376a1a26?s=64&amp;d=mm&amp;r=g 2x\" class=\"avatar avatar-32 photo\" height=\"32\" width=\"32\">\t\t\t\t<a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/olliejones\/\" rel=\"noopener\"><br \/>\n\t\t\t\t\tOllieJones\t\t\t\t<\/a>\n\t\t\t<\/li>\n<li>\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/9d2819e6e21bb18630474928416bdf095d392715dffbcc2ca5acc7ef0b0c1482?s=32&amp;d=mm&amp;r=g\" srcset=\"https:\/\/secure.gravatar.com\/avatar\/9d2819e6e21bb18630474928416bdf095d392715dffbcc2ca5acc7ef0b0c1482?s=64&amp;d=mm&amp;r=g 2x\" class=\"avatar avatar-32 photo\" height=\"32\" width=\"32\">\t\t\t\t<a target=\"_blank\" href=\"https:\/\/profiles.wordpress.org\/rjasdfiii\/\" rel=\"noopener\"><br \/>\n\t\t\t\t\trjasdfiii\t\t\t\t<\/a>\n\t\t\t<\/li>\n<\/ul><\/div>\n<div class=\"plugin-development\">\n<p>\u201cIndex WP MySQL For Speed\u201d has been translated into 3 locales. Thank you to <a target=\"_blank\" href=\"https:\/\/translate.wordpress.org\/projects\/wp-plugins\/index-wp-mysql-for-speed\/contributors\" rel=\"noopener\">the translators<\/a> for their contributions.<\/p>\n<p><a target=\"_blank\" href=\"https:\/\/translate.wordpress.org\/projects\/wp-plugins\/index-wp-mysql-for-speed\" rel=\"noopener\">Translate \u201cIndex WP MySQL For Speed\u201d into your language.<\/a><\/p>\n<h3>Interested in development?<\/h3>\n<p><a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/browser\/index-wp-mysql-for-speed\/\" rel=\"noopener\" class=\"broken_link\">Browse the code<\/a>, check out the <a target=\"_blank\" href=\"https:\/\/plugins.svn.wordpress.org\/index-wp-mysql-for-speed\/\" rel=\"noopener\">SVN repository<\/a>, or subscribe to the <a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/log\/index-wp-mysql-for-speed\/\" rel=\"noopener\" class=\"broken_link\">development log<\/a> by <a target=\"_blank\" href=\"https:\/\/plugins.trac.wordpress.org\/log\/index-wp-mysql-for-speed\/?limit=100&amp;mode=stop_on_copy&amp;format=rss\" rel=\"noopener\" class=\"broken_link\">RSS<\/a>.<\/p>\n<\/div>\n<\/div>\n<div id=\"tab-changelog\" class=\"plugin-changelog section\">\n<h2 id=\"changelog-header\">Changelog<\/h2>\n<h4>1.5.2<\/h4>\n<p>Correct release error.<\/p>\n<h4>1.5.1<\/h4>\n<p>Add support for the WooCommerce tables wp_automatewoo_log_meta, wp_wc_orders_meta, and  wp_woocommerce_order_itemmeta.<\/p>\n<h4>1.4.19<\/h4>\n<p>Report information about host machine using meminfo and procinfo if those files are available.<\/p>\n<h4>1.4.18<\/h4>\n<p>Security update.<\/p>\n<h4>1.4.17<\/h4>\n<p>Back out a miscellaneous bug fix from the previous version. It was an attempt to avoid a warning from Query Monitor\u2019s hooks display.<br \/>\nUpload the full MariaDB \/ MySQL version information with monitors as well as metadata.<\/p>\n<h4>1.4.16<\/h4>\n<p>(no changes to keys)<br \/>\nWordPress 6.5 compatibility.<br \/>\nSupport WordPress versions back to 4.2 (At MDDHosting\u2019s request).<br \/>\nAvoid attempting to upgrade from storage engines except MyISAM and Aria.<br \/>\nWP-CLI upgrade, enable, and disable commands are idempotent now. They don\u2019t generate errors when they find no tables to process.<br \/>\nMiscellaneous bug fixes<\/p>\n<\/div><\/div>\n<p><!-- .entry-content --><\/p>\n<p>\t<!-- .entry-meta --><br \/>\n<\/article>\n<p><br \/>\n<br \/><a href=\"https:\/\/wordpress.org\/plugins\/index-wp-mysql-for-speed\/\" target=\"_blank\" rel=\"noopener\">Source link <\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Index WP MySQL For Speed By OllieJones Download Details Reviews Installation Development Support Description 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 [&hellip;]<\/p>","protected":false},"author":75,"featured_media":3256,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"give_campaign_id":0,"footnotes":""},"categories":[1933,39,40],"tags":[2213,2214,1963],"class_list":["post-3255","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-community-plugin","category-lite-version","category-wp-plugin-solution","tag-index","tag-mysql","tag-speed"],"acf":[],"fifu_image_url":"https:\/\/ps.w.org\/index-wp-mysql-for-speed\/assets\/banner-772x250.png?rev=2652667","_links":{"self":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts\/3255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/comments?post=3255"}],"version-history":[{"count":0,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/posts\/3255\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/media\/3256"}],"wp:attachment":[{"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/media?parent=3255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/categories?post=3255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/s-o-s.net\/en_gb\/wp-json\/wp\/v2\/tags?post=3255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}