Updated: 28 September 2026 · Applies to: MariaDB 10.6 to 11.4 and MySQL 8

The MySQL query cache stored the results of SELECT queries. It was removed completely in MySQL 8.0, and MariaDB has it switched off by default since version 10.1.7, because on modern multi-core servers it often slows things down.

Check the status (MariaDB)

mysql -e "SHOW VARIABLES LIKE 'query_cache%';"

query_cache_type = OFF (or query_cache_size = 0) means it is disabled.

Better alternatives

  • Application caching: a page cache plugin, or an object cache such as Redis for WordPress and Magento.
  • Enough InnoDB buffer pool (innodb_buffer_pool_size), so frequently used data stays in memory.
  • Indexes on the columns your slow queries filter by; the slow query log shows which ones.

Related services

KVM VPS hosting

NVMe SSD and full root access, with Free Basic Managed Support.

Managed cPanel VPS

cPanel included; we handle updates, security and monitoring.

Server management

on-demand administration, hardening, migrations and monitoring.

Was this answer helpful?

Still stuck? Open a ticket