WordPress.org

Posted a reply to Admin breaks when activating plugin, on the site WordPress.org Forums:
Sorry to say, there's no such version as MySQL 7.2. Could you be running mysql…

1 day ago

Posted a reply to Stuck at revert and reset keys without any progress, on the site WordPress.org Forums:
PLease upload your metadata from the About panel. This problem often crops up on big…

1 day ago

Posted a reply to Add additional indexes/keys to database, on the site WordPress.org Forums:
Can you please start a monitor and then run some queries showing issues with the…

1 day ago

Posted a reply to syntax error, unexpected ‘)’ in admin.php, line 237, on the site WordPress.org Forums:
Aha, Cloudflare... Something to add to my ever-growing test matrix. Thanks for your ongoing patience.

3 weeks ago

Posted a reply to syntax error, unexpected ‘)’ in admin.php, line 237, on the site WordPress.org Forums:
The timeouts are truly a problem, especially on budget hosting services. Try using wp-cli, or…

3 weeks ago

Posted a reply to Need WP-CLI to this plugin’s actions, on the site WordPress.org Forums:
Just a reminder: WP-CLI support is present in the current version, 1.3.3.

3 weeks ago

Posted a reply to Can we keep AriaDB and not switch to InnoDB?, on the site WordPress.org Forums:
InnoDB's developers (now Oracle) have made a *lot* of progress in the past half-decade. And,…

4 weeks ago

Posted a reply to Can we keep AriaDB and not switch to InnoDB?, on the site WordPress.org Forums:
That feature is not available in this plugin. If you really need it, please post…

4 weeks ago

Posted a reply to Rekeying wp_postmeta & Primary Keys, on the site WordPress.org Forums:
Hello again. Try using phpmyadmin or some other MySQL client program to run this DDL…

4 weeks ago

Posted a reply to [NSFW] Error: Error establishing a database connection, on the site WordPress.org Forums:
This is a duplicate of https://wordpress.org/support/topic/error-establishing-a-database-connection-1014/

4 weeks ago

Posted a reply to Error establishing a database connection, on the site WordPress.org Forums:
Holy cow! The ALTER TABLE ... ADD KEY statement really does crash your MySQL server.…

4 weeks ago

Posted a reply to Error establishing a database connection, on the site WordPress.org Forums:
I confess this is the first time I have seen an "error establishing a database…

4 weeks ago

Posted a reply to Temporary file write failure?, on the site WordPress.org Forums:
Thanks for that. It works if the web server host is the same as the…

4 weeks ago

Posted a reply to Error establishing a database connection, on the site WordPress.org Forums:
Sorry you're having trouble. It sure sounds like your database server crashed. Could you please…

1 month ago

Posted a reply to Rekeying wp_postmeta & Primary Keys, on the site WordPress.org Forums:
Thanks for the bug report. I will add sql_require_primary_key to my test suite. Please provide…

1 month ago

Posted a reply to Index BuddyPress and other *meta tables, on the site WordPress.org Forums:
More information is needed about the offending queries. Please, if you have a BuddyPress site…

1 month ago

Posted a reply to Key changes slowed down postmeta lookup, on the site WordPress.org Forums:
Hi, Rick, I didn't realize this was you.

1 month ago

Posted a reply to Key changes slowed down postmeta lookup, on the site WordPress.org Forums:
I put this in here to remind myself to change the so-called "high speed index"…

1 month ago

Posted a reply to Temporary file write failure?, on the site WordPress.org Forums:
Glad you got it working. I wish there were a way to ask MySQL or…

1 month ago

Posted a reply to Temporary file write failure?, on the site WordPress.org Forums:
I fear your MySQL server machine's temporary file system has filled up during the rekeying…

1 month ago

Posted a reply to Table ‘nf_options’ was not locked, on the site WordPress.org Forums:
Do SHOW CREATE TABLE nf_posts and look for the post_author index. If it contains these…

2 months ago

Posted a reply to Error on activation, on the site WordPress.org Forums:
Thanks for letting me know. Do you have any idea how that extra comma crept…

2 months ago

Posted a reply to Error on activation, on the site WordPress.org Forums:
Thanks for the report. The source code for that line is here: https://github.com/OllieJones/index-wp-mysql-for-speeed/blob/main/code/admin.php#L237 Do you…

2 months ago

Posted a reply to Optimize for WooCommerce: heavy shop_order post query ideas?, on the site WordPress.org Forums:
The plugin is built to help with WooCommerce queries like the one you mention. It's…

2 months ago

Posted a reply to Table ‘nf_options’ was not locked, on the site WordPress.org Forums:
If the dashboard tool panel says "revert keys now" then your keys are converted. Those…

2 months ago

Posted a reply to PHP Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, on the site WordPress.org Forums:
Please upload your metadata from the plugin's About tab. And please do wp index-mysql status…

2 months ago

Posted a reply to Website can not use U2F API after February 2022, on the site WordPress.org Forums:
Same problem here. I love your plugin and would rather not stop using it.

2 months ago

Posted a reply to Some tables not optimizes – “has unexpected keys” loop, on the site WordPress.org Forums:
This looks to me like the plugin's request to reset your keys is exceeding its…

2 months ago

Posted a reply to WP_Postmeta terribly slow, on the site WordPress.org Forums:
Following up: One slow query is this sql SELECT DISTINCT p1.post_id FROM wp_postmeta p1 WHERE…

2 months ago

Posted a reply to WP_Postmeta terribly slow, on the site WordPress.org Forums:
There are some queries we didn't imagine when writing the plugin. So, we're grateful you…

2 months ago

Posted a reply to Error: ‘index-mysql’ is not a registered wp command., on the site WordPress.org Forums:
Your error message says this The command index-mysql enable is indeed in a plugin. So,…

2 months ago

Posted a reply to Absolutely livechanger, on the site WordPress.org Forums:
Great to hear! A request: if you are willing, could you run a monitor from…

2 months ago

Posted a reply to Much awaited plugin for non techies and excellent support also, on the site WordPress.org Forums:
You're welcome. I (OllieJones) have a soft spot in my heart for people actually making…

3 months ago

Posted a reply to Specified key was too long;, on the site WordPress.org Forums:
Thanks for the followup, and I'm happy to hear you solved your problem. I reached…

3 months ago

Posted a reply to Big Database, on the site WordPress.org Forums:
As it turned out, this was resolved by flushing the redis Object Cache.

3 months ago

Posted a reply to Specified key was too long;, on the site WordPress.org Forums:
Try using the latest version of my plugin to monitor your database operations while you…

3 months ago

Posted a reply to Specified key was too long;, on the site WordPress.org Forums:
Yes, upgrading to MariaDB 10.4 will fix your problem. I have a fix in the…

3 months ago

Posted a reply to Specified key was too long;, on the site WordPress.org Forums:
I see you're using MariaDB 10.1.48. I haven't (yet) tested the plugin on that version.…

3 months ago

Posted a reply to Specified key was too long;, on the site WordPress.org Forums:
Did this happen with the latest (1.3.3) version of the plugin? If you used an…

3 months ago

Posted a reply to I cant find monitoring tab, on the site WordPress.org Forums:
In general, I agree with your Cloudways team: Horsing around with MySQL settings is something…

3 months ago

Posted a reply to Works incorrectly when ROW_FORMAT=COMPACT, on the site WordPress.org Forums:
Version 1.3.3 updates both the ENGINE and ROW_FORMAT.

3 months ago

Posted a reply to how to activate the monitoring tab?, on the site WordPress.org Forums:
Version 1.3.3, just released, has the monitoring tab.

3 months ago

Posted a reply to I cant find monitoring tab, on the site WordPress.org Forums:
I would not change those two settings from the default. And, version 1.3.3 with the…

3 months ago