Query Cache Thread States

by satheeshkumar 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.

Tagged in:

1475
like
0
dislike
0
mail
flag

You must LOGIN to add comments