Hi, hellomaria-letmetrythisfirst---, On Dec 20, hellomaria-letmetrythisfirst--- via discuss wrote:
Hello,
I found the query cache in MariaDB to be super useful and especially powerful when used in DEMAND mode. So I'd like to learn more about the performance characteristics.
The documentation says that for the query cache, "the mutex is hit even for SQL_NO_CACHE":
https://mariadb.com/kb/en/mariadb-memory-allocation/#query-cache
Is there some more information about this somewhere?
The above is incorrect. Queries with SQL_NO_CACHE will not take query cache mutex. They used to, but it was fixed more than 10 years ago. I've removed that claim from the manual, thanks for pointing it out. Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org