- 7.5.6 Examining Thread Information
- 7.5.6.1 Thread Command Values
- 7.5.6.2 General Thread States
- 7.5.6.3 Delayed-Insert Thread States
- 7.5.6.4 Query Cache Thread States
- 7.5.6.5 Replication Master Thread States
- 7.5.6.6 Replication Slave I/O Thread States
- 7.5.6.7 Replication Slave SQL Thread States
- 7.5.6.8 Replication Slave Connection Thread States
- 7.5.6.9 MySQL Cluster Thread States
- 7.5.6.10 Event Scheduler Thread States
These thread states are associated with the query cache (see Section 7.5.5, “The MySQL Query Cache”).
-
checking privileges on cached queryThe server is checking whether the user has privileges to access a cached query result.
-
checking query cache for queryThe server is checking whether the current query is present in the query cache.
-
invalidating query cache entriesQuery cache entries are being marked invalid because the underlying tables have changed.
-
sending cached result to clientThe server is taking the result of a query from the query cache and sending it to the client.
-
The server is storing the result of a query in the query cache.
User Comments
Add your own comment.