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. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/query-cache-thread-states/