← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB threads optimalization

 

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     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp


References