Query Cache Thread States

This article documents thread states that are related to the Query Cache. These correspond to the STATE values listed by the SHOW PROCESSLIST statement or in the Information Schema PROCESSLIST Table as well as the PROCESSLIST_STATE value listed in the Performance Schema threads Table.

checking privileges on cached queryChecking whether the user has permission to access a result in the query cache.
checking query cache for queryChecking whether the current query exists in the query cache.
invalidating query cache entriesMarking query cache entries as invalid as the underlying tables have changed.
sending cached result to clientA result found in the query cache is being sent to the client.
storing result in query cacheSaving the the result of a query into the query cache.
Waiting for query cache lockWaiting to take a query cache lock.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.