- Query cache
- System variables
- Example query
- Runtime counters
- Slow query log
Query Cache: Overview
What is Query Cache?
- The query cache stores the text of a SELECT statement together with the corresponding result that was sent to the client
- If an identical statement (case sensitive) is received later, the server retrieves the results from the query cache rather than parsing and executing the statement again
- The query cache is shared among sessions, so a result set generated by one client can be sent in response to the same query issued by another client
You must have an active subscription to download PDF,Lab Zip and Recordings of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.