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.

Value Description
checking privileges on cached query Checking whether the user has permission to access a result in the query cache.
checking query cache for query Checking whether the current query exists in the query cache.
invalidating query cache entries Marking query cache entries as invalid as the underlying tables have changed.
sending cached result to client A result found in the query cache is being sent to the client.
storing result in query cache Saving the the result of a query into the query cache.
Waiting for query cache lock Waiting to take a query cache lock.
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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.