Tagged articles
Query Cache
17 articles · Page 1 of 1
This guide walks through three defensive layers for MySQL performance—optimizing the connection pool, configuring the query cache and memory tables, and designing multi‑level application caches (including Cache‑Aside, Write‑Through, and Redis integration) with concrete code examples and best‑practice recommendations.
Memory TableMySQLPerformance Tuning
0 likes · 13 min read

This article examines two practical Elasticsearch filter‑context scenarios, showing how converting a must clause to a filter can activate the query cache and reduce latency, while also revealing cases where filter context offers no speed benefit and explaining the underlying ConstantScore behavior.
ConstantScoreElasticsearchQuery Cache
0 likes · 5 min read

This guide details a step‑by‑step MySQL performance optimization strategy covering hardware selection, disk I/O planning, operating‑system tweaks, vertical and horizontal sharding, my.cnf parameter tuning, query cache configuration, resource limits, table and index caching, and practical query‑level best practices.
ConfigurationMySQLQuery Cache
0 likes · 18 min read

This article explains the limitations of MySQL's built‑in query cache, how the InnoDB buffer pool works and can be tuned, and introduces ReadySet as an external caching middleware to improve query performance after a major product upgrade.
Buffer PoolDatabase MiddlewareInnoDB
0 likes · 5 min read

This article explains how MySQL permission modifications behave at table, database, and global levels, demonstrates verification steps with Uproxy's connection pool, and clarifies why query cache settings and USE statements affect the visibility of privilege changes.
MySQLQuery CacheSQL
0 likes · 8 min read

StarRocks introduces a Query Cache that stores intermediate aggregation results in memory, enabling reuse across semantically equivalent, partition‑overlapping, or append‑only queries, which can boost query performance by 3‑17× in high‑concurrency scenarios while reducing CPU and disk load.
MPP databaseQuery CacheStarRocks
0 likes · 13 min read

This article explains MySQL's query cache settings, clustered and non‑clustered index design, optimizer cost calculations, how to interpret EXPLAIN output, and the roles of redo/undo logs and transaction isolation levels, providing practical examples and performance tips.
MySQLOptimizerQuery Cache
0 likes · 23 min read

This article explains the complete MySQL architecture, covering its connection, service, storage‑engine, and system‑file layers, the role of each component such as connection pools, query cache, parser, optimizer, executor, and the differences between InnoDB and MyISAM, providing practical insights for developers and interview preparation.
Database ArchitectureInnoDBMyISAM
0 likes · 13 min read

This article explains MySQL's logical architecture, query processing steps, and the inner workings of the optimizer, then provides practical performance‑tuning advice covering data types, index design, cache usage, and specific query patterns such as COUNT, JOIN, LIMIT pagination and UNION.
MySQLPerformance TuningQuery Cache
0 likes · 37 min read


ITPUBOct 10, 2016 · Databases
A production MySQL 5.5 instance suffered intermittent latency and bursts of slow queries, which were traced to an oversized enabled query cache that caused mutex contention during frequent DML operations, and disabling the cache resolved the issue.
Isolation LevelMySQLQuery Cache
0 likes · 6 min read


21CTOFeb 6, 2016 · Databases
This guide walks through MySQL monitoring tools, enabling slow query logging, using mysqldumpslow and EXPLAIN for query analysis, optimizing the query cache, adjusting key configuration parameters, and applying proper normalization and denormalization techniques to improve database performance and reliability.
MySQLQuery Cache
0 likes · 12 min read

This article explains MySQL's query cache mechanism, covering its workflow, configuration parameters, cache‑management commands, internal data structures, experimental verification steps, and practical recommendations for when to enable or disable the feature.
Cache TuningDatabase PerformanceFree Block Management
0 likes · 15 min read

This article explains how MySQL's query cache works, why it uses the full SQL statement as a key, and lists ten typical situations—such as using SQL_NO_CACHE, volatile functions, or locks—that prevent a query from being cached.
Database PerformanceMySQLQuery Cache
0 likes · 2 min read

This guide explains how to monitor MySQL's Query Cache using the 'SHOW GLOBAL STATUS' command, interprets key metrics such as Qcache_hits, Qcache_inserts, and Qcache_free_memory, and shows how to assess cache fragmentation and calculate hit rates for performance tuning.
MetricsMySQLQuery Cache
0 likes · 3 min read

This article explains how MySQL's Query Cache invalidation works, which tables are suitable for caching, how to control caching with the SQL_NO_CACHE and SQL_CACHE hints, and how to handle large result sets using the query_cache_limit setting.
MySQLQuery CacheSQL Hint
0 likes · 3 min read

The article explains how MySQL's Query Cache, while simple and fast, can incur CPU overhead from hash calculations, suffer frequent invalidations on table changes, and consume excessive memory, making its use potentially counter‑productive under high‑concurrency or volatile data scenarios.
MySQLQuery Cachedatabase optimization
0 likes · 2 min read

MySQL’s Query Cache stores the results of SELECT statements by hashing the query, keeping the result set in memory, and invalidating cached entries whenever related tables change, allowing identical queries to be served instantly without re‑execution.
Database PerformanceMySQLQuery Cache
0 likes · 2 min read
