Query Cache Thread States
by satheeshkumar[ Edit ] 2012-09-19 23:25:39
Query Cache Thread States ,
->checking privileges on cached query
The server is checking whether the user has privileges to access a cached query result.
->checking query cache for query
The server is checking whether the current query is present in the query cache.
->invalidating query cache entries
Query cache entries are being marked invalid because the underlying tables have changed.
->sending cached result to client
The server is taking the result of a query from the query cache and sending it to the client.
->storing result in query cache
The server is storing the result of a query in the query cache.