MariaDB MDEV-21377 (exact ticket may vary) has known performance issues. This can me migrated by setting
optimizer_use_condition_selectivity=1
in the server's config
If poor performance with occurs with MySQL 8+ (or MariaDB without the above configuration change), please use
Optimized List Queries v2.3.0 with the "Better Thread List Page Threshold" option set to
0
.
This will inject a work-around which should migrate the poor query performance until this add-on can be restructured to avoid that query