Posted a reply to Background user index building in progress: 1% complete., on the site WordPress.org Forums:
Hello Todd. The plugin uses the WP_Cron subsystem to do the indexing-building in the background.…

Posted a reply to Queries still slow, on the site WordPress.org Forums:
Hello, thanks for your report of poor performance. The queries you showed are indeed the…

Posted a reply to Please add WPML support, on the site WordPress.org Forums:
This is a very good suggestion: several people have mentioned it. https://github.com/OllieJones/index-wp-mysql-for-speed/issues/36

Posted a reply to Incompatible with Index WP MySQL For Speed, on the site WordPress.org Forums:
It's true that Index WP MySQL For Speed drops the fulltext indexes. I'll fix that…

Posted a reply to Database errors during WP upgrade, on the site WordPress.org Forums:
The latest version of the plugin, 1.4.4, should deal correctly with the 5.9 upgrade, and…

Posted a reply to Fatal Error Uncaught Exception, on the site WordPress.org Forums:
Try running the query that threw the "MySQL server has gone away" error from a…

Posted a reply to Do we need to keep this plugin enabled, as opposed to your Index WP MySQL plugi?, on the site WordPress.org Forums:
Yes, this plugin needs to stay activated to work properly. Why? It hooks the functions…

Posted a reply to Add keys to wp_aws_index ?, on the site WordPress.org Forums:
Oh my my my. This Advanced WooCommerce Search plugin contains the single most notorious SQL…

Posted a reply to Add keys to wp_aws_index ?, on the site WordPress.org Forums:
Thanks for the heads up on this Advanced Woo Search with the unfortunate acronym (confusing…

Posted a reply to Fatal Error Uncaught Exception, on the site WordPress.org Forums:
Thanks for trying the /var/tmp fix; sorry to hear it didn't help your problem. Would…

Posted a reply to Fatal Error Uncaught Exception, on the site WordPress.org Forums:
Hi, sorry you're having difficulty. This is the heart of your error message: MySQL server…

Posted a reply to Awesome plugin!, on the site WordPress.org Forums:
Thanks for the kind words. I wonder: Did you use wp-cli to enable the high-performance…

Posted a reply to How to test if Index rebuilding process have actually stared?, on the site WordPress.org Forums:
Glad to hear it works for you. To a future release I'lll add a feature…

Posted a reply to How to test if Index rebuilding process have actually stared?, on the site WordPress.org Forums:
Ooops, sorry, I made a mistake, I should have mentioned wp_usermeta. This is the correct…

Posted a reply to How to test if Index rebuilding process have actually stared?, on the site WordPress.org Forums:
A lock timeout! The plugin should recover, but it may take some time. I'll check…

Posted a reply to Update to 6.4 – Problematic DB Update, on the site WordPress.org Forums:
Thanks for letting me know about this. I'll keep an eye on the problem. This…

Posted a reply to How to measure speed before and after activating plugin, on the site WordPress.org Forums:
We have the Monitor feature. You can capture a Monitor before changing the keys and…

Posted a reply to Loss of user relationships, on the site WordPress.org Forums:
Thanks for the heads-up on this. I've never heard of database table keys corrupting data,…

Posted a reply to Taxonomy Optimization, on the site WordPress.org Forums:
Thanks. I'll follow up by email.

Posted a reply to wp_dropdown_users() Optimization, on the site WordPress.org Forums:
Here is the newly released plugin, designed specifically to rework the user-lookup queries to make…

Posted a reply to Taxonomy Optimization, on the site WordPress.org Forums:
Looking at this, I have some comments. -- This query is generated by the [WP_Tax_Query…

Posted a reply to Re-run after a timeout?, on the site WordPress.org Forums:
I just had a chance to look at your upload. You should do wp index-mysql…

Posted a reply to Re-run after a timeout?, on the site WordPress.org Forums:
It looks to me like the convert operation completed correctly despite the web server timeout.…

Posted a reply to Improves Speed Greatly, on the site WordPress.org Forums:
Thanks for the kind words. The various caching plugins do their thing, of course. But…

Posted a reply to wp_dropdown_users() Optimization, on the site WordPress.org Forums:
I am on this, with a plugin under development.

Posted a reply to This database can not be repaired or optimized, on the site WordPress.org Forums:
If you do what I think you do, yes it is normal. OPTIMIZE and REPAIR…

Posted a reply to Indexing also autoload in wp_options, on the site WordPress.org Forums:
The plugin already adds PRIMARY KEY (term_id, meta_key, meta_id) as the clustered index on wp_termmeta,…

Posted a reply to A gift from the WordPress gods, on the site WordPress.org Forums:
Thanks for your kind words! If you encounter any query patterns that still run slowly…

Posted a reply to Indexing also autoload in wp_options, on the site WordPress.org Forums:
Standard WordPress databases already have an index on autoload, and this plugin leaves it in…

Posted a reply to The most potential plugin!, on the site WordPress.org Forums:
Thanks for your kind words and your offer to help! I know, of course, that…

Posted a reply to Plugin cannot be translated, on the site WordPress.org Forums:
Translatability is available in V1.4.4. Thanks for your patience.