BestHub
Sign in
Tagged articles
419 articles
Page 3 of 5
Open Source Linux
Open Source Linux
Mar 29, 2022 · Databases

Essential MySQL SQL Optimization Tips to Speed Up Your Queries

This guide presents a comprehensive set of MySQL optimization techniques—including proper use of EXPLAIN, limiting IN clause size, avoiding SELECT *, using LIMIT 1, minimizing sorting, replacing OR with UNION ALL, preferring UNION ALL over UNION, eliminating ORDER BY RAND(), distinguishing IN versus EXISTS, applying efficient pagination, segmenting large scans, avoiding NULL checks and leading wildcards, rewriting expressions, preventing implicit type conversion, respecting composite index leftmost rules, forcing indexes, handling range queries, and optimizing JOINs—to dramatically improve query performance.

Database PerformanceJOINSQL Optimization
0 likes · 11 min read
Essential MySQL SQL Optimization Tips to Speed Up Your Queries
Liangxu Linux
Liangxu Linux
Mar 28, 2022 · Databases

Master MySQL Performance: Indexes, Explain Plans, and Optimization Tips

This comprehensive guide explains MySQL's architecture, storage engines, and the critical role of indexes, walks through the SQL parsing process, details how to read and interpret EXPLAIN output, and provides practical optimization examples for single‑table and multi‑table queries.

Database Performanceexplainindexes
0 likes · 38 min read
Master MySQL Performance: Indexes, Explain Plans, and Optimization Tips
Qunar Tech Salon
Qunar Tech Salon
Mar 17, 2022 · Databases

Killing Slow Queries in MySQL: Problems, Drawbacks, and Practical Design Solutions

The article analyses why indiscriminately killing slow MySQL queries is risky, enumerates the drawbacks of common kill‑based approaches, and proposes more reliable designs such as registration, signature‑based killing, and source‑code modifications to safely mitigate query‑induced database avalanches.

Database PerformanceSQL signaturekill
0 likes · 16 min read
Killing Slow Queries in MySQL: Problems, Drawbacks, and Practical Design Solutions
DataFunTalk
DataFunTalk
Feb 27, 2022 · Databases

Vectorization in Apache Doris: Design, Implementation, Current Status, and Future Plans

This article explains how Apache Doris adopts CPU vectorization techniques—such as SIMD, columnar storage, and cache‑friendly designs—to boost query performance, detailing its current vectorized engine architecture, recent benchmarks, ongoing work on JOIN, storage, import, and future enhancements.

Apache DorisColumnar StorageDatabase Performance
0 likes · 22 min read
Vectorization in Apache Doris: Design, Implementation, Current Status, and Future Plans
Youzan Coder
Youzan Coder
Feb 17, 2022 · Databases

Master MySQL Slow Query Optimization: Practical Indexing Techniques

This article shares hands‑on experience with MySQL 5.7 slow‑query problems, explaining common causes, proper index design, pitfalls that invalidate indexes, efficient SQL writing, deep‑pagination avoidance, and how to use EXPLAIN to verify that queries leverage the right indexes.

Database PerformanceExplain PlanIndex Optimization
0 likes · 16 min read
Master MySQL Slow Query Optimization: Practical Indexing Techniques
Alimama Tech
Alimama Tech
Feb 16, 2022 · Databases

Optimizing Hologres Data Tables and Queries for Alibaba Advertising Inventory Management

By redesigning Hologres tables with column orientation, shard‑controlled Table Groups, distribution and clustering keys, adding bitmap indexes, refreshing statistics, caching external data, and tuning optimizer join order and resource scaling, Alibaba’s Mom advertising inventory system cut query latency by up to 35 % and memory use by 98 %, achieving a 5‑10× performance boost.

AdvertisingData WarehouseDatabase Performance
0 likes · 21 min read
Optimizing Hologres Data Tables and Queries for Alibaba Advertising Inventory Management
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions

This article explains MySQL master‑slave replication fundamentals, why it’s used, the replication workflow, causes of lag, and presents multiple practical solutions—including system tuning, partitioning, caching, multi‑threaded relay log replay, and read‑from‑master strategies—to improve performance and reliability.

Database PerformanceReplicationmysql
0 likes · 12 min read
Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions
Top Architect
Top Architect
Jan 22, 2022 · Databases

Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis

The article explains why large‑offset LIMIT queries on a MySQL table with millions of rows are slow, demonstrates how rewriting the query to use a subquery that first selects primary‑key IDs dramatically reduces execution time, and validates the improvement by measuring buffer‑pool page usage.

Database PerformanceSubquerybuffer pool
0 likes · 9 min read
Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis
JD Cloud Developers
JD Cloud Developers
Jan 21, 2022 · Databases

Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases

This article explains TiDB's SQL layer architecture, details how SQL requests are processed and optimized, demonstrates the use of EXPLAIN and EXPLAIN ANALYZE, and presents two real‑world case studies that illustrate common performance pitfalls and practical optimization techniques.

Database PerformanceSQL LayerSQL Optimization
0 likes · 8 min read
Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases
IT Xianyu
IT Xianyu
Jan 19, 2022 · Databases

Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization

This article explains how to inspect and clear Linux memory buffers, details the information shown by the free command, and provides a comprehensive overview of SQL join types, their performance impact, and optimization techniques such as indexing, join buffer tuning, and algorithm choices.

BuffCacheDatabase PerformanceJOIN optimization
0 likes · 7 min read
Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization
Architect's Tech Stack
Architect's Tech Stack
Dec 16, 2021 · Databases

Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and foreach Size Limits

This article explains why MyBatis batch inserts using a foreach loop can become extremely slow when inserting thousands of rows, analyzes the underlying cost of parsing large prepared statements, and presents practical solutions such as using ExecutorType.BATCH, limiting foreach batch size, and employing JDBC batch execution to achieve sub‑second performance.

Batch InsertDatabase PerformanceExecutorType.BATCH
0 likes · 8 min read
Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and foreach Size Limits
21CTO
21CTO
Dec 14, 2021 · Databases

PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?

This article examines workload analysis and query performance differences between PostgreSQL and MySQL, focusing on JSON handling, indexing strategies, concurrency control, benchmark results, and replication features, while offering configuration tips to improve each database’s speed and efficiency.

Database PerformanceJSONMVCC
0 likes · 10 min read
PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?
Top Architect
Top Architect
Dec 4, 2021 · Databases

Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits

This article explains why MyBatis foreach batch inserts can become extremely slow when inserting thousands of rows, analyzes the underlying SQL and PreparedStatement overhead, and demonstrates how using ExecutorType.BATCH together with a limited batch size (20‑50 rows per statement) dramatically improves insertion speed.

Batch InsertDatabase PerformanceExecutorType.BATCH
0 likes · 9 min read
Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits
360 Quality & Efficiency
360 Quality & Efficiency
Dec 3, 2021 · Databases

Understanding MySQL Slow Query Analysis with EXPLAIN

This article explains why SQL queries become slow in MySQL, describes the server architecture, details how to use the EXPLAIN statement to interpret execution plans, and outlines how to read and optimize key fields such as type, key, and extra for better performance.

Database PerformanceIndex Optimizationexplain
0 likes · 5 min read
Understanding MySQL Slow Query Analysis with EXPLAIN
StarRocks
StarRocks
Nov 9, 2021 · Databases

Unlocking Database Speed: Highlights from StarRocks Vectorization Meetup

The first StarRocks Hacker Meetup recapped essential techniques for building high‑performance databases, covering CPU vectorization basics, key optimization strategies, and a preview of the upcoming session on real‑time updates and storage engine redesign, all presented by community experts.

Database PerformanceReal-time UpdatesStarRocks
0 likes · 6 min read
Unlocking Database Speed: Highlights from StarRocks Vectorization Meetup
Ops Development Stories
Ops Development Stories
Nov 9, 2021 · Databases

Master MySQL Index Optimization: 10 Practical Tips to Avoid Index Pitfalls

This article demonstrates how to create and use a sample employees table, explains composite index structures, and provides ten concrete MySQL index best‑practice guidelines—covering full‑value matches, leftmost‑prefix rules, avoiding functions, range conditions, covering indexes, inequality, NULL checks, leading wildcards, type conversions, and OR usage—each illustrated with EXPLAIN output and code examples.

Database PerformanceIndex OptimizationSQL
0 likes · 10 min read
Master MySQL Index Optimization: 10 Practical Tips to Avoid Index Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2021 · Databases

Impact of Adjusting System Time on MySQL Runtime Behavior

The article investigates how changing the operating system clock while MySQL is running influences functions such as SLEEP, metadata lock (MDL) wait calculations, and other timing‑related mechanisms, demonstrating that forward or backward adjustments can cause premature exits or inaccurate wait measurements.

Database Performancelock_wait_timeoutmetadata lock
0 likes · 4 min read
Impact of Adjusting System Time on MySQL Runtime Behavior
Wukong Talks Architecture
Wukong Talks Architecture
Oct 25, 2021 · Databases

MySQL Index Optimization and Code Review Practices

This article explains MySQL index fundamentals, the B+Tree structure, various index types, the concept of covering indexes to avoid row look‑ups, the left‑most prefix rule, and presents three real‑world optimization cases that illustrate how to design effective composite indexes, reduce index size, and improve query performance while avoiding costly table scans and sorts.

Code reviewComposite IndexDatabase Performance
0 likes · 13 min read
MySQL Index Optimization and Code Review Practices
Programmer DD
Programmer DD
Oct 11, 2021 · Databases

Why Running MySQL in Docker Can Be Risky: 5 Critical Issues

This article examines why containerizing MySQL often leads to data‑security, performance, state‑management, and resource‑isolation problems, while also outlining scenarios where MySQL can safely run in Docker with proper strategies and examples.

ContainersDatabase PerformanceDocker
0 likes · 6 min read
Why Running MySQL in Docker Can Be Risky: 5 Critical Issues
dbaplus Community
dbaplus Community
Oct 10, 2021 · Databases

Transform MySQL Slow Queries from Passive Fixes to Proactive Risk Scoring

This article presents a comprehensive MySQL slow‑query risk‑scoring model that quantifies each slow query's impact using metrics such as query count, execution time, lock wait, bytes sent and rows examined, assigns weighted scores up to 100, and demonstrates how the model enables proactive, business‑aligned remediation.

Database PerformanceMetricsmysql
0 likes · 15 min read
Transform MySQL Slow Queries from Passive Fixes to Proactive Risk Scoring
dbaplus Community
dbaplus Community
Oct 7, 2021 · Databases

How to Measure and Eliminate Slow SQL in Large‑Scale MySQL Deployments

This article explains what MySQL slow queries are, why they cause system failures, proposes multi‑dimensional metrics to assess their severity, outlines concrete guidelines and change standards, and shares real‑world optimization cases and daily operational practices for eliminating slow SQL.

Database PerformanceMetricsOperations
0 likes · 13 min read
How to Measure and Eliminate Slow SQL in Large‑Scale MySQL Deployments
Java High-Performance Architecture
Java High-Performance Architecture
Oct 3, 2021 · Databases

Why Tame Slow SQL? Proven MySQL Optimization Strategies

The article explains why slow SQL queries drain I/O and CPU resources, outlines prioritization rules, details MySQL execution steps, identifies performance‑affecting factors, and provides practical solutions and best‑practice guidelines for diagnosing and optimizing slow MySQL queries in production environments.

Database PerformanceSQL Tuningindexing
0 likes · 19 min read
Why Tame Slow SQL? Proven MySQL Optimization Strategies
Qunar Tech Salon
Qunar Tech Salon
Sep 16, 2021 · Databases

Design and Implementation of a MySQL Slow‑Query Risk Scoring Model

This article presents a comprehensive approach to quantifying MySQL slow‑query risk by defining scoring items, establishing boundary values, applying various scoring functions, and integrating business‑level weighting, ultimately enabling proactive identification and remediation of high‑impact slow queries.

Database PerformanceGomysql
0 likes · 16 min read
Design and Implementation of a MySQL Slow‑Query Risk Scoring Model
Tencent Database Technology
Tencent Database Technology
Sep 8, 2021 · Databases

Tencent Cloud Enterprise MySQL Dynamic Thread‑Pool Feature Overview

The article explains Tencent Cloud's enterprise‑level MySQL dynamic thread‑pool capability, describing the one‑thread‑per‑connection and thread‑pool modes, the new thread_handling_switch_mode parameter with its four options, status‑monitoring commands, and added columns for process‑list visibility, enabling seamless mode switching without server restarts.

Database PerformanceDynamic SwitchingTencent Cloud
0 likes · 6 min read
Tencent Cloud Enterprise MySQL Dynamic Thread‑Pool Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 3, 2021 · Databases

Diagnosing MySQL Memory Spikes Using perf and mmap Monitoring

This tutorial demonstrates how to reproduce a MySQL memory‑spike bug, monitor the process with Linux perf to capture mmap system calls, and analyze the resulting perf.out to identify which SQL statements trigger large memory allocations, while also discussing the method’s limitations.

Database PerformanceLinuxmemory profiling
0 likes · 5 min read
Diagnosing MySQL Memory Spikes Using perf and mmap Monitoring
Top Architect
Top Architect
Aug 29, 2021 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article presents a comprehensive guide to improving MySQL query performance by addressing common issues such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, intermediate result push‑down, and demonstrates how using WITH can simplify complex statements.

Database PerformanceQuery TuningSQL Optimization
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
Alibaba Cloud Developer
Alibaba Cloud Developer
Jul 30, 2021 · Databases

How to Tackle MySQL Slow Queries: Metrics, Strategies, and Real Cases

This article explains what constitutes a MySQL slow query, why they cause failures, defines quantitative metrics such as micro‑average and macro‑average to assess severity, outlines target goals, presents concrete optimization examples, and shares operational practices for ongoing slow‑SQL governance.

Database PerformanceIndex OptimizationMetrics
0 likes · 13 min read
How to Tackle MySQL Slow Queries: Metrics, Strategies, and Real Cases
21CTO
21CTO
Jul 18, 2021 · Databases

Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help

This article examines common causes of slow MySQL queries, explains index mechanics and failures, then compares ElasticSearch’s fast tokenized search and HBase’s column‑oriented storage, offering practical guidance on when and how to use each technology.

Big DataDatabase PerformanceHBase
0 likes · 21 min read
Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help
Efficient Ops
Efficient Ops
Jul 17, 2021 · Databases

How AutoTiKV’s Machine Learning Optimizes Beaver Search Engine Performance

This article describes how the Beaver search engine’s many performance‑related configuration parameters can be automatically tuned using machine‑learning techniques from OtterTune and AutoTiKV, detailing the background research, Gaussian Process regression model, Bayesian optimization process, implementation steps, test results, and future improvements.

Bayesian OptimizationBeaverDatabase Performance
0 likes · 23 min read
How AutoTiKV’s Machine Learning Optimizes Beaver Search Engine Performance
Top Architect
Top Architect
Jul 17, 2021 · Databases

Understanding MySQL Query Optimization and Index Design

This article explains MySQL’s logical architecture, query processing steps, and the principles behind query optimization, covering topics such as client‑server protocol, query cache, parsing, cost‑based optimizer, execution engine, and practical index design strategies to improve performance.

Database PerformanceSQLindexes
0 likes · 35 min read
Understanding MySQL Query Optimization and Index Design
High Availability Architecture
High Availability Architecture
Jun 18, 2021 · Databases

Polar Index: Removing the Global Index Latch to Accelerate InnoDB B‑Tree SMO Operations

The article explains how PolarDB's Polar Index redesigns InnoDB B‑Tree structural modification (SMO) by splitting the operation into two phases, eliminating the global index latch, reducing lock granularity, and achieving up to 11× performance gains in high‑concurrency workloads such as TPCC.

B+TreeDatabase PerformanceIndex Latch
0 likes · 12 min read
Polar Index: Removing the Global Index Latch to Accelerate InnoDB B‑Tree SMO Operations
Top Architect
Top Architect
Jun 16, 2021 · Databases

Understanding MySQL Memory Management and When to Shard Tables

The article explains how MySQL uses different memory areas such as Thread Memory, Sharing, and InnoDB Buffer Pool, describes the impact of large user tables on query performance, and shows that when a table size exceeds the InnoDB buffer pool capacity, sharding becomes necessary.

Database PerformanceInnoDBLinux
0 likes · 17 min read
Understanding MySQL Memory Management and When to Shard Tables
Open Source Linux
Open Source Linux
Jun 10, 2021 · Databases

MySQL vs MariaDB: Real-World Performance Benchmark and Analysis

This article reviews the history of MySQL and MariaDB, describes a test environment, runs insertion, batch, and query benchmarks (with and without indexes), and concludes that MariaDB generally outperforms MySQL in speed and memory usage while highlighting trade‑offs of indexing.

BenchmarkDatabase PerformanceInnoDB
0 likes · 9 min read
MySQL vs MariaDB: Real-World Performance Benchmark and Analysis
Efficient Ops
Efficient Ops
Jun 9, 2021 · Databases

Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase

This article explains why MySQL queries become slow, explores index-related pitfalls and optimization techniques, and then compares ElasticSearch and HBase as complementary solutions for large‑scale data and search scenarios, offering practical tips and code examples.

Database PerformanceHBaseindexing
0 likes · 21 min read
Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Understanding PostgreSQL Prepared Statements and Plan Caching (Generic vs Custom)

This article explains how PostgreSQL's prepared statements cache execution plans, describing the default behavior of generating custom plans for the first five executions before switching to a generic plan, and shows how PostgreSQL 14 adds generic_plans and custom_plans columns to the pg_prepared_statements view for monitoring.

Custom PlanDatabase PerformanceGeneric Plan
0 likes · 2 min read
Understanding PostgreSQL Prepared Statements and Plan Caching (Generic vs Custom)
Alibaba Cloud Developer
Alibaba Cloud Developer
May 27, 2021 · Databases

How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases

OceanBase achieved a world‑record TPC‑H performance of 15.26 million QphH, illustrating its HTAP capabilities and detailing the technical evolution, challenges, and future direction of hybrid transactional/analytical processing in modern distributed databases.

Database PerformanceHTAPHybrid Transactional Analytical Processing
0 likes · 18 min read
How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 27, 2021 · Databases

How to Locate and Analyze Slow SQL Queries in MySQL

This article explains how to identify slow MySQL queries using the slow‑query log and SHOW PROCESSLIST, configure logging parameters, and analyze query performance with EXPLAIN, including detailed explanations of key output fields and practical code examples.

Database Performanceexplainmysql
0 likes · 13 min read
How to Locate and Analyze Slow SQL Queries in MySQL
IT Architects Alliance
IT Architects Alliance
May 26, 2021 · Databases

Understanding MySQL Slow Queries, Elasticsearch, and HBase: Causes and Practical Solutions

This article explains why MySQL queries become slow, how indexes work and fail, the impact of MDL locks, large‑table challenges, sharding and read‑write splitting strategies, then introduces Elasticsearch’s search capabilities and HBase’s column‑family storage, offering practical guidance for each technology.

Database PerformanceElasticsearchHBase
0 likes · 17 min read
Understanding MySQL Slow Queries, Elasticsearch, and HBase: Causes and Practical Solutions
Code Ape Tech Column
Code Ape Tech Column
May 21, 2021 · Databases

Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help

This article analyzes common causes of slow MySQL queries such as index misuse, MDL locks, and large‑table bottlenecks, then presents practical solutions like proper indexing, sharding, read/write splitting, and evaluates when to complement MySQL with ElasticSearch or HBase for better performance.

Database PerformanceElasticsearchHBase
0 likes · 19 min read
Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help
Code Ape Tech Column
Code Ape Tech Column
May 8, 2021 · Databases

Understanding MySQL Pagination Performance and Index Optimization

The article explores why MySQL pagination with large offsets is slow, explains index structures such as clustered and secondary indexes, describes logical query operators, and presents two practical optimization strategies to improve query performance.

Database PerformanceIndex OptimizationQuery Planning
0 likes · 6 min read
Understanding MySQL Pagination Performance and Index Optimization
Programmer DD
Programmer DD
May 7, 2021 · Databases

Boost MySQL Pagination Performance: Real-World Tests and Optimizations

This article examines why full-table scans become slow on large MySQL tables, demonstrates various pagination techniques—including simple LIMIT, sub‑query, ID‑range, and IN‑clause methods—provides benchmark results for different record counts and offsets, and offers practical tips to dramatically speed up paginated queries.

Database PerformanceSQLmysql
0 likes · 10 min read
Boost MySQL Pagination Performance: Real-World Tests and Optimizations
Liangxu Linux
Liangxu Linux
Apr 22, 2021 · Databases

Why Developers Use ‘WHERE 1=1’ in SQL and How to Apply It Effectively

The article explains that inserting ‘WHERE 1=1’ in dynamically built SQL statements prevents syntax errors when appending additional conditions, illustrates its use with Java string concatenation examples, discusses performance considerations, and shows how to copy tables or duplicate structures using this technique.

Database PerformanceDynamic SQLSQL
0 likes · 3 min read
Why Developers Use ‘WHERE 1=1’ in SQL and How to Apply It Effectively
Top Architect
Top Architect
Apr 22, 2021 · Databases

Redis Lazy Free and Multi‑Threaded I/O: Architecture, Mechanisms, and Limitations

This article explains how Redis, originally a single‑threaded in‑memory cache, introduced Lazy Free in version 4.0 and multi‑threaded I/O in version 6.0 to mitigate blocking deletions and improve I/O throughput, detailing the underlying event model, code implementations, performance trade‑offs, and comparisons with Tair's threading design.

Database PerformanceLazy FreeMemory Management
0 likes · 16 min read
Redis Lazy Free and Multi‑Threaded I/O: Architecture, Mechanisms, and Limitations
MaGe Linux Operations
MaGe Linux Operations
Apr 15, 2021 · Databases

Unlock MySQL Query Performance: Deep Dive into Architecture, Optimizer, and Index Strategies

This article demystifies MySQL’s query execution by exploring its logical architecture, client‑server protocol, query cache, parsing, optimization, and execution engine, then offers practical indexing and performance‑tuning techniques—including B‑Tree fundamentals, covering indexes, and pagination tricks—to help developers write faster, more efficient SQL.

B+TreeDatabase PerformanceSQL
0 likes · 35 min read
Unlock MySQL Query Performance: Deep Dive into Architecture, Optimizer, and Index Strategies
dbaplus Community
dbaplus Community
Apr 11, 2021 · Databases

Why Redis Added Multithreading in 6.0: Myths, Benefits, and Design Choices

Redis, traditionally single‑threaded for network I/O and key‑value operations, introduced multithreading in version 6.0 to improve network I/O handling; this article explains the original single‑thread design, when multithreading is appropriate, its drawbacks, the role of I/O multiplexing, and why Redis still keeps most work single‑threaded.

Database PerformanceI/O MultiplexingVersion 6.0
0 likes · 12 min read
Why Redis Added Multithreading in 6.0: Myths, Benefits, and Design Choices
Programmer DD
Programmer DD
Apr 6, 2021 · Databases

Why MySQL Pagination Is So Slow and How to Fix It

This article explores why MySQL queries with large LIMIT‑OFFSET pagination become painfully slow, explains the underlying B+‑tree index mechanics and MySQL's logical operator layers, and presents two practical solutions—key‑based pagination and index‑covering queries—to dramatically improve performance.

B+TreeDatabase PerformanceIndex Optimization
0 likes · 7 min read
Why MySQL Pagination Is So Slow and How to Fix It
Architects' Tech Alliance
Architects' Tech Alliance
Mar 12, 2021 · Databases

Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices

This article explains the characteristics of OLTP and OLAP workloads, compares their I/O patterns, and provides Oracle database performance best‑practice guidelines, including storage planning, SAN architecture, operating‑system queue‑depth settings, and SwingBench testing results for optimal configuration.

Database PerformanceI/O optimizationOLAP
0 likes · 11 min read
Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Mar 8, 2021 · Databases

Understanding Redis Lazy Free and Multi‑Threaded I/O: Architecture and Implementation

This article explains how Redis evolves from a single‑threaded event‑driven cache to using Lazy Free for asynchronous key deletion and multi‑threaded I/O for improved performance, detailing the underlying mechanisms, code implementations, limitations, and comparisons with Tair's threading model.

Database PerformanceLazy FreeMultithreaded I/O
0 likes · 16 min read
Understanding Redis Lazy Free and Multi‑Threaded I/O: Architecture and Implementation
Architecture Digest
Architecture Digest
Mar 4, 2021 · Databases

Performance Comparison Between MariaDB and MySQL

This article reviews the history of MySQL, introduces MariaDB as its open‑source fork, and presents a series of benchmark tests—including single‑row inserts, batch inserts, and various query scenarios—showing that MariaDB generally outperforms MySQL in speed while using more memory.

BenchmarkDatabase PerformanceMariaDB
0 likes · 8 min read
Performance Comparison Between MariaDB and MySQL
Code Ape Tech Column
Code Ape Tech Column
Feb 24, 2021 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on a HikariCP wiki post, explaining why smaller database connection pools often yield better performance, presenting benchmark videos and data, describing the underlying CPU, disk, and network constraints, and offering a simple formula to calculate an optimal pool size for typical server configurations.

Connection PoolDatabase PerformanceHikariCP
0 likes · 9 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jan 26, 2021 · Backend Development

Master MyBatis: Common Return Values, Exceptions, and SQL Optimization Tips

This article shares practical MyBatis tips, detailing what different return types yield when no records match, common exceptions you may encounter, transaction lock behavior with FOR UPDATE, and essential SQL optimization strategies such as using LIMIT, proper indexing, and avoiding inefficient patterns.

Database PerformanceJava PersistenceMyBatis
0 likes · 8 min read
Master MyBatis: Common Return Values, Exceptions, and SQL Optimization Tips
Code Ape Tech Column
Code Ape Tech Column
Jan 26, 2021 · Databases

Why Adding LIMIT to MySQL DELETE Is a Must‑Have Safety Habit

The article explains why appending LIMIT to MySQL DELETE statements improves performance, reduces lock contention, and safeguards data by limiting rows affected, provides syntax details, compares deletion strategies for removing large numbers of rows, and offers practical recommendations for safe and efficient data removal.

DELETEData SafetyDatabase Performance
0 likes · 8 min read
Why Adding LIMIT to MySQL DELETE Is a Must‑Have Safety Habit
Programmer DD
Programmer DD
Jan 9, 2021 · Backend Development

How Cache Strategies Prevent Database Bottlenecks in High‑Traffic Systems

This article explains why massive traffic spikes can cripple database performance, introduces cache layers and common caching patterns, and offers practical solutions to consistency, concurrency, penetration, and avalanche problems for large‑scale internet applications.

Backend ArchitectureDatabase Performancecache patterns
0 likes · 9 min read
How Cache Strategies Prevent Database Bottlenecks in High‑Traffic Systems
Liangxu Linux
Liangxu Linux
Jan 3, 2021 · Databases

How to Benchmark MySQL Performance with Sysbench: A Step‑by‑Step Guide

This tutorial explains MySQL benchmarking fundamentals and walks you through installing sysbench, configuring test parameters, preparing data, running the benchmark, analyzing results, and applying best‑practice recommendations to accurately assess database performance.

Database PerformanceLinuxSysbench
0 likes · 11 min read
How to Benchmark MySQL Performance with Sysbench: A Step‑by‑Step Guide
Laravel Tech Community
Laravel Tech Community
Dec 17, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes in MySQL does not always prevent slow queries, analyzes full‑index scans, index selectivity, back‑table lookups, virtual columns, and provides practical optimization techniques to reduce scanned rows and improve performance.

Database PerformanceSlow QueriesVirtual Columns
0 likes · 11 min read
Understanding Index Usage and Slow Queries in MySQL
Programmer DD
Programmer DD
Dec 4, 2020 · Databases

Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, pre‑filtering, and intermediate result handling, and provides rewritten SQL examples that dramatically reduce execution time.

Database PerformanceQuery TuningSQL Optimization
0 likes · 14 min read
Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them
ITPUB
ITPUB
Nov 20, 2020 · Databases

How Indexes Supercharge MySQL Queries: A Deep Dive into EXPLAIN

This article explains why indexes dramatically improve MySQL query speed on large tables, outlines common reasons for slow SQL, shows how to use EXPLAIN and SHOW PROFILE to diagnose problems, and provides step‑by‑step examples of creating and evaluating indexes for optimal performance.

Database Performanceexplainindex
0 likes · 15 min read
How Indexes Supercharge MySQL Queries: A Deep Dive into EXPLAIN
ITPUB
ITPUB
Nov 13, 2020 · Databases

Master MySQL Indexes: How Explain Optimizes Query Performance

This guide explains why MySQL queries become slow, how to diagnose issues with slow‑query logs, Explain and Show Profile, details the structure and types of indexes, interprets each column of the Explain output, and demonstrates practical optimization steps with real SQL examples.

Database PerformanceSQLindexes
0 likes · 14 min read
Master MySQL Indexes: How Explain Optimizes Query Performance
Architect
Architect
Oct 24, 2020 · Databases

Why Adding LIMIT to DELETE Statements Is a Good Practice in MySQL

The article explains that using LIMIT with DELETE in MySQL improves safety, reduces lock time, prevents long‑running transactions, and enhances performance, and it provides syntax, examples, and expert opinions to illustrate the benefits of this habit.

DELETEDatabase PerformanceLIMIT
0 likes · 7 min read
Why Adding LIMIT to DELETE Statements Is a Good Practice in MySQL
ITPUB
ITPUB
Sep 30, 2020 · Databases

Mastering MySQL Index Usage: When and How Queries Leverage Indexes

This guide explains the conditions under which MySQL can use indexes for range scans, LIKE patterns, BETWEEN clauses, and sorting, detailing key_len calculation, index key vs. filter vs. table filter, and practical examples to demystify index utilization.

Database PerformanceIndex OptimizationQuery Planning
0 likes · 10 min read
Mastering MySQL Index Usage: When and How Queries Leverage Indexes
Top Architect
Top Architect
Sep 22, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing stages, client‑server protocol, query cache, parsing, optimization, execution engine, and provides practical performance‑tuning advice such as index design, data‑type choices, covering indexes, limit pagination, and handling UNION and JOIN operations.

Database PerformanceSQLindexes
0 likes · 35 min read
Understanding MySQL Query Execution and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 21, 2020 · Databases

Understanding Semi‑join Materialization in MySQL Subquery Optimization

This article explains how MySQL transforms eligible subqueries into semi‑joins, describes the four semi‑join strategies, and details the Semi‑join Materialization approach—including Materialization‑scan and Materialization‑lookup—while showing how to identify the chosen strategy via EXPLAIN output.

Database PerformanceMaterializationSemi-Join
0 likes · 9 min read
Understanding Semi‑join Materialization in MySQL Subquery Optimization
Code Ape Tech Column
Code Ape Tech Column
Sep 20, 2020 · Databases

20 Principles for MySQL Index Optimization

This article presents twenty practical rules for optimizing MySQL indexes—including when to use or avoid indexes, how to write queries that can leverage them, the importance of index selectivity, prefix indexes, covering indexes, and common pitfalls—to help developers write faster, more efficient SQL statements.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 16 min read
20 Principles for MySQL Index Optimization
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 17, 2020 · Databases

Understanding MySQL Join Types and Optimization Techniques

This article explains MySQL's various join algorithms—including Simple Nested Loop, Index Nested Loop, Blocked Nested Loop, and unsupported Hash and Merge joins—detailing their mechanisms, performance trade‑offs, and optimization strategies such as MRR, BKA, join buffers, and driver‑table selection.

BKADatabase PerformanceJOIN optimization
0 likes · 11 min read
Understanding MySQL Join Types and Optimization Techniques
Code Ape Tech Column
Code Ape Tech Column
Sep 1, 2020 · Databases

Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices

This article presents a thorough overview of MySQL performance tuning, covering step‑by‑step SQL optimization techniques, common pitfalls, index and table‑structure improvements, cache parameter adjustments, and practical guidelines to reduce I/O and CPU bottlenecks while maintaining data integrity.

Database PerformanceQuery TuningSQL Optimization
0 likes · 28 min read
Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices
Code Ape Tech Column
Code Ape Tech Column
Aug 29, 2020 · Databases

20 Essential MySQL Index Optimization Rules Every Developer Should Know

This article outlines twenty practical principles for optimizing MySQL indexes, covering topics such as LIKE wildcards, UNION/IN/OR usage, negative conditions, composite index prefix rules, range queries, function avoidance, covering indexes, prefix indexes, pagination strategies, and common misconceptions, all illustrated with SQL examples and performance tips.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 16 min read
20 Essential MySQL Index Optimization Rules Every Developer Should Know
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 21, 2020 · Databases

Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects

This article examines how MySQL Group Replication's message cache fills under load, the impact of the group_replication_message_cache_size and group_replication_member_expel_timeout parameters, and provides experimental observations and practical recommendations for balancing reliability, memory usage, and data consistency.

Database PerformanceGroup ReplicationMessage Cache
0 likes · 5 min read
Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects
Tencent Database Technology
Tencent Database Technology
Jul 27, 2020 · Databases

Demystifying the TPC‑C Benchmark: Model, Schema, and New‑Order Transaction Walkthrough

This article explains the TPC‑C benchmark, covering its purpose, data model, database schema, the five transaction types, and a detailed step‑by‑step walkthrough of the New‑Order operation with accompanying SQL illustrations, while also summarizing workload characteristics and providing reference links.

BenchmarkDatabase PerformanceDatabase design
0 likes · 7 min read
Demystifying the TPC‑C Benchmark: Model, Schema, and New‑Order Transaction Walkthrough
macrozheng
macrozheng
Jul 14, 2020 · Databases

Why SELECT * Slows Down MySQL: Deep Dive into Indexes and Optimization

This article explains why using SELECT * in MySQL queries degrades performance, covering increased parsing cost, unnecessary data transfer, loss of covering index optimization, and how proper column selection and index design can dramatically improve query speed.

Database PerformanceSQL Optimizationcovering index
0 likes · 10 min read
Why SELECT * Slows Down MySQL: Deep Dive into Indexes and Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 23, 2020 · Databases

Understanding Half-Consistent Reads in InnoDB and Their Impact on Transactions

This article explains the concept of half‑consistent reads in MySQL InnoDB, describes the conditions under which they occur, presents two test cases with detailed lock‑waiting behavior, analyzes why certain sessions are blocked or not, and summarizes the optimization benefits for RC isolation level.

Database PerformanceHalf-Consistent ReadInnoDB
0 likes · 20 min read
Understanding Half-Consistent Reads in InnoDB and Their Impact on Transactions
Java Captain
Java Captain
Jun 21, 2020 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance

Although many developers hear the advice to avoid using SELECT * in SQL, this article delves into the underlying reasons—such as increased parsing cost, unnecessary data transfer, extra I/O, and loss of covering-index optimization—while also explaining index concepts and best practices for MySQL performance.

Database PerformanceIndex OptimizationSQL
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance