[MariaDB discuss] Re: Query Cache: Does a SELECT query tagged with SQL_NO_CACHE really touch the QC mutex?

Hi, hellomaria-letmetrythisfirst---, On Dec 23, hellomaria-letmetrythisfirst--- via discuss wrote:

Awesome, thanks!

And how about this statement: "The QC, unless it is OFF & 0, is consulted for _every_ SELECT"

When "query_cache_type=DEMAND", I would expect that the mutex is only accessed for queries that are tagged with "SQL_CACHE"?

Query cache is consulted before the query is parsed. That is, before it knows if there is SQL_CACHE in your SELECT or not. Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org