This guide concerns the MySQL query cache which, when enabled, stores the results of already executed queries in memory.

Preamble

• MySQL Query Cache allows to speed up subsequent identical queries by avoiding to execute them again.
• This can improve the overall performance of the database server by reducing the load and decreasing the response time for frequent queries.

query_cache_type ON or OFF?

On Shared Web Hosting (i.e. excluding Cloud Server) MySQL Query Cache is neither enabled nor enableable.

On Cloud Server, enable MySQL Query Cache via Fast Installer.