My test environment is:
Ubuntu 14.04 Trusty Tahr
MySQL Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)
MySQL uses sql cache to store results of queries that have been executed so that when the same query is executed again it retrieves the result data set from the cache instead of getting it again from db. So it is faster data access.
It is by default enabled in MySQL.
This is interesting since there is one question we ought to ask here whether we should use it or disable it or just leave it as it is who cares :).
Ok, moving forward today's session goals are:
- How useful is MySQL cache?
- When to use it and when not to use it?
- What to do if you do not want to use it?
There are some catchy areas here too like not all your queries will be stored in cache. …