Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

8.14.4 Query Cache Thread States

These thread states are associated with the query cache (seeSection 8.10.3, “The MySQL Query Cache”).

  • 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.

  • Waiting for query cache lock

    This state occurs while a session is waiting to take the query cache lock. This can happen for any statement that needs to perform some query cache operation, such as anINSERT orDELETE that invalidates the query cache, aSELECT that looks for a cached entry,RESET QUERY CACHE, and so forth.