How can it be that MariaDB 5.5.68 is performing several orders of magnitude faster than 10.11.x for these specific operations?
Hello, if you have means, could you test 10.4.34 which while EOL is the last version based on 5.5/5.6 MySQL and issues like these appeared https://jira.mariadb.org/browse/MDEV-30501#comment-272740 https://jira.mariadb.org/browse/MDEV-29988 https://jira.mariadb.org/browse/MDEV-26055 Which while marked Closed, point to different issues/problems where situation is still unclear .. I haven't tried the 10.11.x nor 11.x but none of the short-term release branches after 10.4 have performed even close (though not that dramatically) at least for our workload, so currently stuck on 10.4.x p.s. sorry for not answering your questions and possibly increasing the load :) wbr rr