Tagged articles

16 articles

Page 1 of 1

Dec 5, 2024 · Databases

Practical Elasticsearch Filter Context Cases: When It Speeds Up Queries and When It Doesn't

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.

ConstantScoreElasticsearchfilter context

0 likes · 5 min read

Practical Elasticsearch Filter Context Cases: When It Speeds Up Queries and When It Doesn't

MaGe Linux Operations

Oct 11, 2024 · Databases

Comprehensive MySQL Optimization Guide: Hardware, OS, Config & Query Tuning

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.

ConfigurationDatabase Optimizationmysql

0 likes · 18 min read

Comprehensive MySQL Optimization Guide: Hardware, OS, Config & Query Tuning

Selected Java Interview Questions

Aug 6, 2024 · Databases

Understanding MySQL Query Cache, InnoDB Buffer Pool, and ReadySet Middleware for Performance Optimization

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.

Database MiddlewareInnoDBReadySet

0 likes · 5 min read

Understanding MySQL Query Cache, InnoDB Buffer Pool, and ReadySet Middleware for Performance Optimization

Aikesheng Open Source Community

Sep 26, 2023 · Databases

Understanding MySQL Permission Changes and Their Effectiveness in Uproxy

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.

PermissionsUproxydatabase

0 likes · 8 min read

Understanding MySQL Permission Changes and Their Effectiveness in Uproxy

StarRocks

Aug 22, 2023 · Databases

How StarRocks Query Cache Supercharges High‑Concurrency Aggregations

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 databaseStarRocksaggregation

0 likes · 13 min read

How StarRocks Query Cache Supercharges High‑Concurrency Aggregations

Liangxu Linux

Apr 26, 2021 · Databases

Master MySQL Internals: Query Cache, Indexes, Optimizer & Transaction Logs

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.

Isolation LevelsTransaction Logsindexes

0 likes · 23 min read

Master MySQL Internals: Query Cache, Indexes, Optimizer & Transaction Logs

Full-Stack Internet Architecture

Jan 6, 2021 · Databases

Understanding MySQL Architecture: Layers, Components, and Storage Engines

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

Understanding MySQL Architecture: Layers, Components, and Storage Engines

MaGe Linux Operations

Jan 26, 2019 · Databases

Master MySQL Query Optimization: Execution Flow, Caching, and Index Strategies

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.

cost‑based optimizerindex designmysql

0 likes · 37 min read

Master MySQL Query Optimization: Execution Flow, Caching, and Index Strategies

ITPUB

Oct 10, 2016 · Databases

Why MySQL Query Cache Slowed My Production Database and How We Fixed It

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.

Database OptimizationIsolation Levelmysql

0 likes · 6 min read

Why MySQL Query Cache Slowed My Production Database and How We Fixed It

21CTO

Feb 6, 2016 · Databases

Master MySQL Monitoring, Tuning, and Schema Design for Optimal Performance

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

Master MySQL Monitoring, Tuning, and Schema Design for Optimal Performance

dbaplus Community

Dec 19, 2015 · Databases

Unlocking MySQL Query Cache: How It Works, Tuning Tips, and Real‑World Experiments

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

Unlocking MySQL Query Cache: How It Works, Tuning Tips, and Real‑World Experiments

Java High-Performance Architecture

Oct 19, 2015 · Databases

Why MySQL Query Cache Fails: 10 Common Scenarios Explained

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

Why MySQL Query Cache Fails: 10 Common Scenarios Explained

Java High-Performance Architecture

Oct 16, 2015 · Databases

Master MySQL Query Cache: Metrics, Commands, and Optimization Tips

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.

Database OptimizationMetricsmysql

0 likes · 3 min read

Master MySQL Query Cache: Metrics, Commands, and Optimization Tips

Java High-Performance Architecture

Aug 5, 2015 · Databases

When to Use MySQL Query Cache: Hints, Best Practices, and Pitfalls

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.

SQL Hintmysqlquery cache

0 likes · 3 min read

When to Use MySQL Query Cache: Hints, Best Practices, and Pitfalls

Java High-Performance Architecture

Aug 4, 2015 · Databases

When Does MySQL Query Cache Hurt More Than Help?

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.

Database Optimizationmysqlquery cache

0 likes · 2 min read

When Does MySQL Query Cache Hurt More Than Help?

Java High-Performance Architecture

Aug 3, 2015 · Databases

How MySQL’s Query Cache Works: Inside the Hash‑Based Mechanism

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 PerformanceHashingmysql

0 likes · 2 min read

How MySQL’s Query Cache Works: Inside the Hash‑Based Mechanism