Hi! > Le 7 févr. 2018 à 11:34, Reindl Harald <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
