Oliver Jones

The npm package at https://www.npmjs.com/package/ebml is not yet updated to the May 3 commits made here. If you use the npm package, you should use its README.md for documentation.

Thanks for the report! Your uploaded metadata says that you've used Index WP Mysql to add the high-performance keys to all your tables, and that you use MariaDB 10.4. All...

It's a query fingerprint (percona calls them query hashes) thing.... WP does queries like `SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (627329,627330,627331,627332,627333,627334,627335,627336,627337,627338,627339,627340,627341,627342,627343,627344,627345,627346,627347,627348,627349,627350,627351,627352,627353,627354,627355,627356,627357,627358,627359,627360,627361,627362,627363,627364,627365,627366,627367,627368,627369,627370,627371,627372,627373,627374,627375,627376,627377,627378,627379,627380,627381,627382,627383,627384,627385,627386,627387,627388,627389,627390,627391,627392,627393,627394,627395,627396,627397,627398,627399,627400,627401,627402,627403,627404,627405,627406,627407,627408,627409,627410,627411,627412,627413,627414,627415,627416,627417,627418,627419,627420,627421,627422,627423,627424,627425,627426,627427,627428,627429,627430,627431,627432,627433,627434,627435,627436,627437,627438,627439,627440,627441,627442,627443,627444,627445,627446,627447,627448,627449) ORDER BY meta_id ASC` The fingerprint...

WPML is not open source. But I have obtained a dev license.

Thanks for this info, @tridoan-px @tridoan @rjasdf . It looks like the `wp_icl_translations` table is performance-critical, judging from the three queries you provided. The indexes on there are not bad....

Here are a couple of query monitors and the SQL defining a WordPress + WPML database. They're from an absurdly small WPML site, so query-planner index choices are distorted. But...

Sure, please sent me an email . Address on my github profile. (I've been away on vac. back in the saddle now.)

I asked the user to capture a monitor from within the plugin, but they haven't gotten back to me. I've been fooling around with the taxonomy / term / relationships...

Thanks for this!

Sweet! Happy to have help! I'm about to push version 1.4.1 of the plugin. Once you have it, please use the Monitor feature to capture some of the slow stuff...