Reindl, QC was developed many years ago when scalability wasn't a concern. It is fixable, but unfortunately it was never a priority.
Regards, Sergey On Wed, Feb 07, 2018 at 11:34:02AM +0100, Reindl Harald wrote: > > > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
