softmetz, 4 months ago I now run #mariadb with --optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.
I now run #mariadb with
--optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M
That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.