PmaControl logo PmaControl
  • Home
  • PmaControl
    • AI Agents 13 on-premise agents
    • Plans Community, Cloud, On-Premise, Premium
    • Documentation Guides, API, architecture
    • Changelog Every stable 5.x release
    • Marketplace Community plugins
    • Clients 28+ companies
    • FAQ 25 questions / 7 categories
    Databases
    • MariaDB 35 articles
    • MySQL 15 articles
    • Galera Cluster 6 articles
    • MaxScale 4 articles
    • ProxySQL 3 articles
    • Amazon Aurora MySQL 0 article
    • Azure Database 0 article
    • ClickHouse 0 article
    • GCP CloudSQL 0 article
    • Percona Server 0 article
    • SingleStore 0 article
    • TiDB 0 article
    • Vitess 0 article
    Solutions
    • Support 24×7 MariaDB & MySQL emergencies
    • SQL Observability Monitoring, alerts, topology
    • High Availability Replication, failover, Galera
    • Disaster Recovery Backup, restore, RPO/RTO
    • Security & Compliance Audit, GDPR, SOC2
    • Migration & Upgrade Zero downtime, pt-osc, gh-ost
  • Plans
  • Resources
    • Documentation Technical guides & API
    • MySQL optimization center Markdown index, metrics, parameters, incidents
    • FAQ 25 frequently asked questions
    • Testimonials Client feedback & use cases
    • Blog Articles & insights
    • Roadmap Upcoming features
    Areas of expertise
    • SQL Observability Monitoring, alerts, Dot3 topology
    • High Availability Replication, failover, Galera
    • Security & Compliance Audit, GDPR, SOC2, ISO 27001
    • Disaster Recovery Backup, restore, RPO/RTO
    • Performance & Optimisation Digests, EXPLAIN, tuning
    • Migration & Upgrade Zero downtime, pt-osc
    Quick links
    • GitHub Wiki 26 pages — install, engine, plugins
    • Source code Official GitHub repository
    • Support 24×7 MariaDB & MySQL emergencies
    • Book a demo 30 min — real architecture
  • Support 24×7
  • Book a demo
Book a demo
🇫🇷 FR Français 🇬🇧 EN English 🇵🇱 PL Polski 🇷🇺 RU Русский 🇨🇳 ZH 中文 🇸🇦 AR العربية
Resources › MySQL optimization center › MySQL Query Cache

MySQL Query Cache

Structured Markdown documentation to diagnose, measure, and optimize MySQL.

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Role

The query cache is a historical feature. It can speed up some repeated reads, but it introduces strong contention on modern write-heavy workloads.

Related Variables

  • query_cache_type
  • query_cache_size
  • query_cache_limit
  • query_cache_min_res_unit

Recommendation

On MySQL 5.7, disabling it is often preferable for concurrent applications. On MySQL 8, it no longer exists. If an old platform still uses it, measure hits, invalidations, and waits before deciding.

SHOW VARIABLES LIKE 'query_cache%';
SHOW GLOBAL STATUS LIKE 'Qcache%';
PmaControl
contact@pmacontrol.com
About Privacy Legal notice GitHub Developers Contact
Do not wait for an incident to understand your architecture. © 2014-2026 PmaControl — 68Koncept