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: