maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04996
Re: MariaDB threads optimalization
Hi!
> Le 7 févr. 2018 à 11:34, Reindl Harald <h.reindl@xxxxxxxxxxxxx> a écrit :
>
>
>
> Am 07.02.2018 um 11:28 schrieb Sergey Vojtovich:
>> I'm afraid query cache doesn't scale well. Try turning it off
>
> well, the question is why on a read-bound workload because there is no valid reason that it locks reads for other threads
>
> and no remove query-cache like MySQL 8.0 is no solution because when you have a few terrible optimized queries on your server which takes seconds to run query-cache will save your ass while you can (and we did) write known fast queries with "select SQL_NO_CACHE" to get the locking relaxed
You could also take a look at software like https://www.heimdalldata.com which tries to replace the query cache (and much more BTW)
HTH,
--
Jocelyn Fournier
Founder
M : +33 6 51 21 54 10
https://www.softizy.com
Softizy - At your side to Optimize your PHP / MySQL applications
Follow ups
References