ShinLim
Active member
Last edited:
This is GA Real Time visitors right?
Why do you need him?This is why I sent you inbox @Xon
Because I'm using his add-on, which is https://xenforo.com/community/resources/redis-cache-by-xon.5562/Default xenforo can do full page caching already.
set global optimizer_use_condition_selectivity=1;
set global join_cache_level=0;
join_cache_level=0
optimizer_use_condition_selectivity=1
Hmm ... we are running MariaDB 10.4 with XF 2.1 and 1.5 since quite tome time and I havn't noticed anything major, in fact performance has improved a bit.MariaDB 10.4.x has major performance regressions when running XenForo.
Quite a few;Hmm ... we are running MariaDB 10.4 with XF 2.1 and 1.5 since quite tome time and I havn't noticed anything major, in fact performance has improved a bit.
What exact issues did you notice?
xf_thread
and xf_thread_post
table is large enough.So should I downgrade to 10.3 or should I use "optimizer_use_condition_selectivity=1"I dumped the database and downgraded to 10.3.x
Will give it a go.Try updating to MariaDB 10.3.21, there are some query performance regression fixes in as 10.3.18 had some bugs backported to it.
We use essential cookies to make this site work, and optional cookies to enhance your experience.