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

Introduction

• MySQL Query Cache speeds up subsequent identical queries by preventing them from being executed 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), the MySQL Query Cache is neither enabled nor can it be enabled.

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