Performance

Topics 

  • Query cache
    • Overview 
    • System variables 
  • Indexing 
    • Overview 
    • Example query 
    • Strategy 
    • Runtime counters 
  • EXPLAIN 
  • 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 and Lab Zip of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.