BestHub
Sign in
Tagged articles

Database Performance

429 articles · Page 4 of 5
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 PerformanceIndexingMySQL
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 PerformanceMySQLQuery 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.

Database PerformanceNew-OrderOLTP
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.

Covering IndexDatabase PerformanceSELECT
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 PerformanceMySQLSELECT
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance
Architecture Digest
Architecture Digest
Jun 21, 2020 · Databases

Optimizing Large-Scale MySQL Join Queries Using EXPLAIN

This article explains how to analyze and tune MySQL join queries with EXPLAIN, addressing issues like using temporary tables and filesort, and provides practical techniques—including STRAIGHT_JOIN and index strategies—to achieve sub‑second response times on tables with millions of rows.

Database PerformanceEXPLAINIndexing
0 likes · 6 min read
Optimizing Large-Scale MySQL Join Queries Using EXPLAIN
Programmer DD
Programmer DD
Jun 18, 2020 · Databases

How to Optimize MySQL Joins for Million‑Row Tables in Under 2 Seconds

This article explains how to use EXPLAIN to analyze MySQL join queries, identifies causes of temporary tables and filesorts, and provides practical techniques—including driver‑table selection, STRAIGHT_JOIN usage, and index strategies—to optimize two‑ and multi‑table joins so that million‑row results return within two seconds.

Database PerformanceEXPLAINJOIN
0 likes · 8 min read
How to Optimize MySQL Joins for Million‑Row Tables in Under 2 Seconds
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 16, 2020 · Databases

Understanding and Optimizing MySQL Multi-Range Read (MRR)

This article explains MySQL's Multi-Range Read (MRR) optimization, demonstrates its performance impact through experiments, shows how to enable or disable MRR via optimizer_switch, and provides guidance on tuning related parameters such as mrr_cost_based and read_rnd_buffer_size for optimal query execution.

Database PerformanceMRRMySQL
0 likes · 7 min read
Understanding and Optimizing MySQL Multi-Range Read (MRR)
Laravel Tech Community
Laravel Tech Community
Jun 11, 2020 · Databases

MySQL Performance Optimization Techniques: Bulk Inserts, INSERT, GROUP BY, ORDER BY, OR, Nested Queries, and SQL Hints

This article presents a comprehensive guide to MySQL performance tuning, covering bulk‑insert optimizations, efficient INSERT statements, GROUP BY and ORDER BY improvements, OR‑condition handling, nested query replacement, and the use of SQL hints such as USE INDEX, IGNORE INDEX, and FORCE INDEX, with practical code examples and benchmark results.

Bulk InsertDatabase PerformanceMySQL
0 likes · 13 min read
MySQL Performance Optimization Techniques: Bulk Inserts, INSERT, GROUP BY, ORDER BY, OR, Nested Queries, and SQL Hints
Youzan Coder
Youzan Coder
Apr 29, 2020 · Databases

MySQL Slow Query Analysis: Root Causes and Optimization Strategies

The article examines why MySQL queries become slow, detailing system‑level issues such as network latency, I/O bottlenecks, and CPU settings, alongside database‑level problems like missing indexes, type conversion, poor execution plans, lock contention, skewed data, and inefficient SQL patterns, and offers optimization strategies.

Database PerformanceDatabase TroubleshootingInnoDB
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 29, 2020 · Databases

Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations

This article examines MySQL column attributes—especially NULL vs NOT NULL handling, the impact of NULL on concatenation, COUNT and indexing, as well as AUTO_INCREMENT behaviors, lock modes, step/offset settings, and overflow scenarios—to help developers write more efficient and reliable SQL.

Database PerformanceMySQLNULL
0 likes · 10 min read
Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations
Java Captain
Java Captain
Apr 18, 2020 · Databases

Understanding Linux Memory Usage, Buffer Cache, and SQL Join Optimization

This article explains how to inspect and clear Linux memory buffers, interprets the fields shown by the free command, and then dives into SQL join types, performance‑impacting factors such as join_buffer_size, and practical optimization techniques like indexing and denormalization.

Buffer CacheDatabase PerformanceLinux
0 likes · 7 min read
Understanding Linux Memory Usage, Buffer Cache, and SQL Join Optimization
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 29, 2020 · 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, covering key output fields, common values, and practical code examples for effective SQL optimization.

Database PerformanceEXPLAINMySQL
0 likes · 14 min read
How to Locate and Analyze Slow SQL Queries in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 26, 2020 · Databases

Understanding MySQL Replication Delay and System Lock Mechanisms

This article explains how MySQL computes replication delay using show_slave_status, analyzes the relationship between binlog write timestamps and event generation, enumerates common causes of lag, and provides a detailed examination of the system‑lock state in the slave SQL thread with code examples.

Database PerformanceInnoDBMySQL
0 likes · 11 min read
Understanding MySQL Replication Delay and System Lock Mechanisms
Architecture Digest
Architecture Digest
Mar 23, 2020 · Databases

Understanding Linux Buffer Cache and SQL Join Performance

This article explains how Linux memory statistics (free, top) report buffer/cache usage, how to clear it with sync and drop_caches, and then dives into SQL join concepts, types, optimization techniques, and MySQL join algorithms such as nested loop and block nested loop, highlighting their impact on performance.

Buffer CacheDatabase PerformanceLinux
0 likes · 7 min read
Understanding Linux Buffer Cache and SQL Join Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 17, 2020 · Databases

Understanding MySQL Index Optimization and Execution Flow

This article explains MySQL index design principles, demonstrates the execution steps of a range query on a sample table, and discusses common index optimizations such as covering indexes, the left‑most prefix rule, index condition push‑down, implicit type conversion, as well as why the optimizer may choose a wrong index and how to correct it.

Database PerformanceMySQLQuery Execution
0 likes · 9 min read
Understanding MySQL Index Optimization and Execution Flow
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 13, 2020 · Databases

How HotRing Boosts In-Memory KV Store Performance by 2.58×

The article introduces HotRing, a hotspot‑aware in‑memory key‑value store from Alibaba's Tair team, explains the extreme traffic challenges of Alibaba's Double‑11 peak, details the design of ordered‑ring hashing, dynamic hotspot detection, lock‑free concurrency and rehashing, and shows how these innovations achieve up to 2.58× higher throughput than existing KV systems.

Database PerformanceHotRingLock-Free
0 likes · 16 min read
How HotRing Boosts In-Memory KV Store Performance by 2.58×
Qunar Tech Salon
Qunar Tech Salon
Feb 12, 2020 · Databases

Understanding MySQL REDO Log: Purpose, Types, and Flush Timing

This article explains the essential role of MySQL REDO logs in ensuring data durability and performance, describes what would happen without logging, details various REDO log record formats, and outlines the multiple moments when InnoDB flushes logs to disk.

Database PerformanceInnoDBLog Flushing
0 likes · 18 min read
Understanding MySQL REDO Log: Purpose, Types, and Flush Timing
Programmer DD
Programmer DD
Jan 3, 2020 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery handling, and mixed sorting, and demonstrates eight practical rewrite strategies—including index‑friendly pagination, JOIN replacements, condition pushdown, and WITH clauses—to dramatically reduce query execution times from seconds to milliseconds.

Database PerformanceMySQLQuery Tuning
0 likes · 8 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
macrozheng
macrozheng
Dec 31, 2019 · Databases

10 Common MySQL Index Pitfalls and How to Fix Them

This article analyzes ten typical situations that cause MySQL indexes to become ineffective—such as OR conditions, missing quotes, leading wildcards in LIKE, composite‑index ordering, built‑in functions, arithmetic operations, inequality operators, NULL checks, charset mismatches, and optimizer choices—and provides concrete examples, visual explanations, and practical solutions to restore index usage.

Database PerformanceMySQLSQL
0 likes · 11 min read
10 Common MySQL Index Pitfalls and How to Fix Them
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 14, 2019 · Databases

MySQL Logical Architecture, Query Process, and Performance Optimization

This article explains MySQL's three‑layer logical architecture, the end‑to‑end query execution flow—including client/server protocol, query cache, parsing, cost‑based optimization, execution engine, and result delivery—followed by practical performance‑tuning advice on schema design, data types, index creation, and specific query optimizations such as COUNT(), JOINs, LIMIT pagination, and UNION handling.

Database PerformanceIndexingMySQL
0 likes · 34 min read
MySQL Logical Architecture, Query Process, and Performance Optimization
DataFunTalk
DataFunTalk
Dec 12, 2019 · Databases

ScyllaDB Row‑Level Repair: Design, Implementation, and Performance Evaluation

ScyllaDB, a high‑performance C++ implementation of Apache Cassandra, introduces row‑level repair to replace the traditional partition‑level repair, reducing data transfer and I/O by operating on individual rows; the presentation details its architecture, multi‑stage process, experimental results, and the resulting six‑fold speedup.

CassandraDatabase PerformanceNoSQL
0 likes · 15 min read
ScyllaDB Row‑Level Repair: Design, Implementation, and Performance Evaluation
MaGe Linux Operations
MaGe Linux Operations
Dec 1, 2019 · Databases

Unlock MySQL Performance: Deep Dive into Query Optimization & Index Design

This article explains MySQL's logical architecture, query execution steps, client‑server protocol, query cache behavior, cost‑based optimizer mechanics, and practical index design strategies—including B+Tree fundamentals, covering indexes, and common pitfalls—to help developers achieve measurable performance improvements.

Database PerformanceMySQLQuery Optimization
0 likes · 32 min read
Unlock MySQL Performance: Deep Dive into Query Optimization & Index Design
ITPUB
ITPUB
Sep 19, 2019 · Databases

Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE

MySQL 8.0 introduces Hash Join for dramatically faster large‑dataset queries, supports in‑memory and spill‑to‑disk processing, can replace Block Nested‑Loop joins, and adds EXPLAIN ANALYZE with detailed runtime statistics and tree‑style output, highlighting the platform’s rapid evolution.

Database PerformanceEXPLAIN ANALYZEHash Join
0 likes · 3 min read
Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE
JD Retail Technology
JD Retail Technology
Aug 13, 2019 · Databases

Performance Comparison of YugabyteDB and CockroachDB

An objective performance comparison between YugabyteDB (v1.3.0.0) and CockroachDB (v19.1.3) was conducted using the official test scenarios, covering write, read, mixed, secondary index, and transactional workloads on a three‑node Docker environment, with analysis of results and conclusions on their relative strengths.

CockroachDBDatabase PerformanceYugabyteDB
0 likes · 4 min read
Performance Comparison of YugabyteDB and CockroachDB
High Availability Architecture
High Availability Architecture
Aug 6, 2019 · Databases

Deep Dive into Redis 6 Multithreaded I/O: Architecture, Code Walkthrough, and Performance Benchmark

This article analyzes Redis 6's newly introduced multithreaded I/O feature, explains its design and code implementation, presents benchmark configurations and results that show near‑doubling of GET/SET throughput, and discusses practical considerations and limitations of the approach.

Database PerformanceMultithreaded I/ORedis
0 likes · 10 min read
Deep Dive into Redis 6 Multithreaded I/O: Architecture, Code Walkthrough, and Performance Benchmark
Java Backend Technology
Java Backend Technology
Jul 23, 2019 · Databases

Why Alibaba Bans Joins Over Three Tables: Real‑World MySQL & Oracle Benchmarks

This article investigates Alibaba's rule against joining more than three tables by designing MySQL and Oracle experiments that generate massive student‑teacher‑course data, run multi‑table join queries, compare indexed versus non‑indexed scenarios, and reveal the performance limits that drive the guideline.

Data GenerationDatabase PerformanceMySQL
0 likes · 12 min read
Why Alibaba Bans Joins Over Three Tables: Real‑World MySQL & Oracle Benchmarks
Qunar Tech Salon
Qunar Tech Salon
Jul 9, 2019 · Databases

SQL Fundamentals and Query Optimization Techniques for PostgreSQL

This article introduces SQL fundamentals, explains DDL/DML/DCL categories, and provides practical PostgreSQL query optimization techniques—including index selection, condition rewriting, sub‑query removal, expression and partial indexes, DDL decomposition, CTE usage, and key configuration parameters—to help developers and DBAs improve performance and maintainability.

Database PerformancePostgreSQLQuery Optimization
0 likes · 12 min read
SQL Fundamentals and Query Optimization Techniques for PostgreSQL
Programmer DD
Programmer DD
Jun 21, 2019 · Databases

Master MySQL EXPLAIN: Decode Execution Plans Like a Pro

This article walks you through using MySQL's EXPLAIN command to analyze query execution plans, explains each column in the output, shows how to interpret IDs, select types, tables, access types, possible and actual indexes, key lengths, row estimates, and extra information, and provides practical code examples for better performance tuning.

Database PerformanceEXPLAINMySQL
0 likes · 14 min read
Master MySQL EXPLAIN: Decode Execution Plans Like a Pro
ITPUB
ITPUB
Apr 23, 2019 · Databases

Understanding MySQL Locking Mechanisms: From Row Locks to Gap Locks

This article explains MySQL's three lock types, the storage engines that use them, detailed MyISAM and InnoDB lock behaviors, gap‑lock pitfalls, optimization tips, and how to monitor lock contention with built‑in status variables.

Database PerformanceInnoDBMyISAM
0 likes · 10 min read
Understanding MySQL Locking Mechanisms: From Row Locks to Gap Locks
58 Tech
58 Tech
Apr 11, 2019 · Databases

Analyzing Slow Query Issues Caused by PHP PDO Prepare Behavior

This article investigates why slow‑query logs show numerous slow queries without visible SQL statements, reproduces the problem using MySQL client, Perl and PHP simulations, compares local (emulated) and server‑side PDO prepare modes, and provides practical recommendations for configuring prepared statements to avoid hidden performance bottlenecks.

Database PerformanceMySQLPDO
0 likes · 7 min read
Analyzing Slow Query Issues Caused by PHP PDO Prepare Behavior
UCloud Tech
UCloud Tech
Mar 28, 2019 · Databases

Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases

This article examines the common causes of MySQL master‑slave replication delay, explains how to monitor the issue with SHOW SLAVE STATUS, and provides practical solutions for six typical scenarios ranging from heavy write traffic to hardware mismatches.

Database PerformanceMaster‑SlaveMySQL
0 likes · 13 min read
Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases
Tencent Cloud Developer
Tencent Cloud Developer
Mar 7, 2019 · Databases

How to Address High CPU Load on a Single MySQL Core

To resolve a MySQL single‑core CPU bottleneck, examine and tune slow queries and indexes, eliminate heavy lock contention, break large transactions into smaller ones, and employ tools like perf top to pinpoint performance hotspots, as recommended by Tencent Cloud Database expert Liu Di.

CPU OptimizationDatabase PerformanceMySQL
0 likes · 3 min read
How to Address High CPU Load on a Single MySQL Core
dbaplus Community
dbaplus Community
Jan 29, 2019 · Databases

Multi‑Industry SQL Audit: Strategies, Processes, and Lessons Learned

The article shares practical lessons from dozens of multi‑industry SQL audit projects, outlining the audit scope, four core scenarios—production optimization, peak‑load reduction, pre‑production interception, and development compliance—along with detailed processes, common pain points, and strategies for effective implementation.

Database PerformanceDevelopment complianceOracle
0 likes · 12 min read
Multi‑Industry SQL Audit: Strategies, Processes, and Lessons Learned
360 Tech Engineering
360 Tech Engineering
Jan 7, 2019 · Databases

SQL Query Analysis and Access Path Strategies

This article explains how relational optimizers validate, analyze, and transform SQL statements into executable code, detailing the four-step optimization process, query‑analysis factors, cost‑based access‑path selection, table scans, index lookups, and the role of data prefetching in improving performance.

Access PathDatabase PerformanceIndex Scan
0 likes · 12 min read
SQL Query Analysis and Access Path Strategies
MaGe Linux Operations
MaGe Linux Operations
Dec 17, 2018 · Databases

How We Turned a Sluggish ERP Database into a High‑Performance System

This article walks through a real‑world ERP database performance case, detailing the symptoms, metric analysis, root‑cause investigation across hardware, environment, and code, and a three‑phase optimization strategy that dramatically reduced latency and improved system stability.

Database PerformanceERPHardware Tuning
0 likes · 11 min read
How We Turned a Sluggish ERP Database into a High‑Performance System
Efficient Ops
Efficient Ops
Nov 28, 2018 · Databases

Master MySQL Indexes: When and How They’re Used for Queries

This article explains how MySQL decides whether an index can be used for range queries, LIKE patterns, and sorting, detailing key_len calculation, index key vs. filter vs. table filter concepts, and practical examples with BETWEEN and ORDER BY.

Database PerformanceMySQLQuery Planning
0 likes · 11 min read
Master MySQL Indexes: When and How They’re Used for Queries
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 26, 2018 · Databases

How Alibaba’s DBFS Achieved Storage‑Compute Separation for Massive 11.11 Sales

This article details Alibaba's journey from the 2017 pilot of storage‑compute separation to the 2018 large‑scale deployment of the DBFS user‑space file system, highlighting innovations such as zero‑copy I/O, RDMA integration, adaptive page cache, asynchronous I/O, atomic writes, online resize, and hardware‑software co‑design that enabled elastic, high‑performance database operations during the Double‑11 shopping festival.

DBFSDatabase PerformanceRDMA
0 likes · 15 min read
How Alibaba’s DBFS Achieved Storage‑Compute Separation for Massive 11.11 Sales
Efficient Ops
Efficient Ops
May 7, 2018 · Databases

Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips

This article demystifies MySQL query optimization by explaining the server's logical architecture, the end‑to‑end query processing flow, the role of the client/server protocol, query cache, parsing, optimizer, execution engine, and result delivery, and then offers concrete performance‑tuning recommendations on schema design, data types, indexing strategies, and specific query patterns such as COUNT(), JOIN, LIMIT pagination, and UNION.

Database PerformanceIndexingMySQL
0 likes · 35 min read
Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips
Java Captain
Java Captain
Apr 6, 2018 · Databases

Understanding MySQL Indexes and Using EXPLAIN for Query Optimization

This article explains how MySQL indexes work, why queries can become slow, how to interpret the EXPLAIN output—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, and extra columns—and provides practical examples and optimization cases to improve query performance while balancing the cost of maintaining indexes.

Database PerformanceIndexMySQL
0 likes · 13 min read
Understanding MySQL Indexes and Using EXPLAIN for Query Optimization
Architects' Tech Alliance
Architects' Tech Alliance
Apr 1, 2018 · Databases

Understanding Oracle AWR Reports and Key Performance Metrics

The article explains how to generate and interpret Oracle Automatic Workload Repository (AWR) reports, detailing key sections such as DB Time, Cache Sizes, Load Profile, parsing behavior, instance efficiency percentages, shared pool statistics, and top wait events to diagnose database performance issues.

AWRDatabase PerformanceInstance Efficiency
0 likes · 16 min read
Understanding Oracle AWR Reports and Key Performance Metrics
ITPUB
ITPUB
Mar 26, 2018 · Databases

30 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents thirty practical SQL tuning guidelines—ranging from avoiding certain WHERE‑clause operators and functions to proper index usage and set‑based alternatives—that help prevent full table scans and improve overall database performance.

Database PerformanceQuery OptimizationSQL
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
Tencent Cloud Developer
Tencent Cloud Developer
Mar 21, 2018 · Databases

Understanding MySQL Thread Pool: Architecture, Configuration, and Common Issues

The article explains MySQL’s thread‑pool technology—its motivation, architecture of listener, worker, timer threads and priority queues, key configuration variables, how to enable it, and common pitfalls such as memory leaks, monitoring timeouts, and group‑level saturation, offering practical guidance for DBAs.

ConfigurationDatabase PerformanceMySQL
0 likes · 17 min read
Understanding MySQL Thread Pool: Architecture, Configuration, and Common Issues
ITPUB
ITPUB
Mar 13, 2018 · Databases

Optimizing Large-Scale Oracle Queries with Temporary Tables

This article examines a high‑volume Oracle query scenario, explains why using multiple IN clauses on millions of rows leads to costly full‑table scans, and presents three alternative strategies—including a single‑SQL join, UNION ALL view, and temporary‑table approaches—along with practical examples and performance considerations.

Database PerformanceOracleQuery Optimization
0 likes · 10 min read
Optimizing Large-Scale Oracle Queries with Temporary Tables
Tencent Database Technology
Tencent Database Technology
Feb 2, 2018 · Databases

In-Depth Exploration of InnoDB Bulk Index Build

This article provides a comprehensive technical overview of InnoDB's bulk index build feature introduced in MySQL 5.7, detailing its design, fast index build phases, bottom‑up construction, dirty‑page flushing, compressed‑table handling, fill‑factor configuration, and potential future optimizations.

Bulk Index BuildDatabase PerformanceFast Index Build
0 likes · 8 min read
In-Depth Exploration of InnoDB Bulk Index Build
Java Backend Technology
Java Backend Technology
Jan 17, 2018 · Databases

Why Graph Databases Outperform Relational DBs for Social Network Queries

The article explains the limitations of relational databases for large‑scale, highly connected data, introduces NoSQL and graph database models, demonstrates how graph queries efficiently retrieve multi‑degree social connections, and showcases Neo4j’s performance advantages over traditional RDBMS.

Database PerformanceGraph DatabaseNeo4j
0 likes · 14 min read
Why Graph Databases Outperform Relational DBs for Social Network Queries
Qunar Tech Salon
Qunar Tech Salon
Dec 20, 2017 · Databases

Diagnosing and Resolving MySQL InnoDB Deadlocks and Lock‑Wait Timeouts in Data‑Warehouse Workloads

This article explains how to quickly locate and fix online MySQL problems such as partial update failures, InnoDB deadlocks, and lock‑wait timeouts by analyzing server logs, understanding InnoDB row‑lock behavior, optimizing indexes, adjusting transaction settings, and using a custom log‑collection script.

Database PerformanceDeadlockInnoDB
0 likes · 19 min read
Diagnosing and Resolving MySQL InnoDB Deadlocks and Lock‑Wait Timeouts in Data‑Warehouse Workloads
Tencent Database Technology
Tencent Database Technology
Dec 7, 2017 · Databases

Implementation and Optimizations of Percona 5.7 Thread Pool

This article explains how Percona Server 5.7 implements a thread‑pool model for MySQL, detailing the activation parameters, internal architecture, functional threads, timer mechanisms, and several performance optimizations such as priority scheduling and special handling for long‑running commands.

Database PerformanceMySQLPercona
0 likes · 13 min read
Implementation and Optimizations of Percona 5.7 Thread Pool
ITPUB
ITPUB
Oct 17, 2017 · Databases

Understanding MySQL Locking Mechanisms: Types, Queues, and Optimization Tips

This article explains MySQL's lock types across storage engines, details MyISAM and InnoDB locking behaviors, describes the four lock queues, outlines gap‑lock characteristics, and provides practical optimization and monitoring techniques to reduce lock contention.

Database PerformanceInnoDBMyISAM
0 likes · 10 min read
Understanding MySQL Locking Mechanisms: Types, Queues, and Optimization Tips
Programmer DD
Programmer DD
Sep 19, 2017 · Databases

Why MySQL Ignored My Index and How to Speed Up Periodic Deletions

The article investigates why a seemingly indexed MySQL DELETE query still performs a full‑table scan, analyzes execution plans and statistics, demonstrates forcing the index, and finally rewrites the query to limit the date range, achieving a much faster operation.

Database PerformanceMySQLSQL
0 likes · 7 min read
Why MySQL Ignored My Index and How to Speed Up Periodic Deletions
21CTO
21CTO
Jul 26, 2017 · Operations

Deploy Percona PMM with Docker for Real‑Time MySQL Monitoring

This guide walks you through installing Ubuntu, Docker, and the Percona Monitoring and Management (PMM) server, configuring a PMM client, and connecting it to MySQL to enable real‑time performance metrics and slow‑query analysis.

Database PerformanceDockerMySQL
0 likes · 7 min read
Deploy Percona PMM with Docker for Real‑Time MySQL Monitoring
ITPUB
ITPUB
Jul 18, 2017 · Databases

Mastering MySQL B-Tree Indexes: How They Work and How to Optimize Queries

This article explains the inner workings of MySQL B‑Tree indexes, how the optimizer chooses the cheapest execution plan, demonstrates practical examples of index matching, cost calculation, and EXPLAIN analysis, and provides step‑by‑step troubleshooting techniques for real‑world performance issues.

B-Tree IndexDatabase PerformanceEXPLAIN
0 likes · 16 min read
Mastering MySQL B-Tree Indexes: How They Work and How to Optimize Queries
dbaplus Community
dbaplus Community
Jun 11, 2017 · Databases

Mastering Oracle SQL Optimization: Practical Techniques and Real-World Cases

This article compiles a DBAplus online session that presents a systematic SQL‑optimization methodology, rewrite tricks, common pitfalls, and a series of concrete Oracle examples—including CASE WHEN, ROWNUM pagination, hint usage, column selection, function‑call reduction, trigger avoidance, and ROWID access—plus a detailed Q&A that clarifies practical tuning questions.

Database PerformanceIndexingOracle
0 likes · 19 min read
Mastering Oracle SQL Optimization: Practical Techniques and Real-World Cases
ITPUB
ITPUB
Jun 2, 2017 · Databases

Essential Principles for Building Effective Oracle Indexes (B‑Tree & Bitmap)

This guide outlines practical principles for creating Oracle indexes, compares B‑Tree and bitmap index types, explains their creation syntax, highlights performance characteristics, and lists common situations where indexes may be ignored or unsuitable.

B+TreeBitMapDatabase Performance
0 likes · 8 min read
Essential Principles for Building Effective Oracle Indexes (B‑Tree & Bitmap)
Qunar Tech Salon
Qunar Tech Salon
May 24, 2017 · Databases

Common Scenarios Where SQL Fails to Use Indexes and How to Resolve Them

This article explains eight typical situations in which Oracle SQL statements cannot use indexes, illustrates each case with concrete examples and step‑by‑step rewrites, and offers practical solutions—including predicate adjustments, function indexes, and query‑transformation fixes—to improve database performance.

Database PerformanceOracleSQL
0 likes · 12 min read
Common Scenarios Where SQL Fails to Use Indexes and How to Resolve Them
dbaplus Community
dbaplus Community
May 22, 2017 · Databases

Why Your SQL Queries Skip Indexes and How to Make Them Use Indexes

This article explains eight common reasons why Oracle SQL statements fail to use indexes, provides concrete rewrite techniques, shows how optimizer bugs can block index usage, and outlines practical steps for enforcing SQL development standards through automated audit tools.

Database PerformanceOracleSQL
0 likes · 13 min read
Why Your SQL Queries Skip Indexes and How to Make Them Use Indexes
MaGe Linux Operations
MaGe Linux Operations
May 13, 2017 · Databases

How to Evaluate and Optimize Database Performance: Key Metrics & Strategies

This article explains what constitutes a database performance problem, outlines essential metrics such as response time, throughput, baseline and bottleneck identification, and presents practical tuning methods—including workload reduction, resource configuration, and optimization balance—to help engineers systematically improve database efficiency.

Database PerformancePerformance TuningSQL optimization
0 likes · 8 min read
How to Evaluate and Optimize Database Performance: Key Metrics & Strategies
dbaplus Community
dbaplus Community
Jan 10, 2017 · Databases

How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)

When a critical Oracle query suddenly slowed down on regional databases while the central server remained fast, I diagnosed the issue, discovered execution‑plan differences caused by missing predicate push‑down, attempted a plan‑binding solution, faced unexpected failures, and ultimately rewrote the SQL using a WITH clause to meet a tight deadline.

Database PerformanceOraclePredicate Pushdown
0 likes · 11 min read
How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)
dbaplus Community
dbaplus Community
Dec 29, 2016 · Databases

How a Veteran DBA Built the DPM Database Performance Analysis Platform

This article recaps a DBAplus community session where a seasoned DBA shares common operational scenarios, diagnostic techniques, lock‑handling strategies, and step‑by‑step SQL optimization methods, while unveiling the DPM platform that automates inspection, data collection, and performance analysis for Oracle databases.

DBADPMDatabase Performance
0 likes · 22 min read
How a Veteran DBA Built the DPM Database Performance Analysis Platform
Architects Research Society
Architects Research Society
Nov 23, 2016 · Databases

ScyllaDB Architecture and Performance Optimizations: Design Insights

ScyllaDB, a Cassandra‑compatible NoSQL database, achieves over tenfold performance improvements through a thread‑per‑core design, asynchronous I/O, custom caching, self‑tuning schedulers, a user‑space TCP/IP stack, and LLVM‑JIT query execution, making it a compelling study for high‑performance database engineering.

Cache DesignDatabase PerformanceNoSQL
0 likes · 5 min read
ScyllaDB Architecture and Performance Optimizations: Design Insights
dbaplus Community
dbaplus Community
Nov 14, 2016 · Databases

Why Oracle Log File Sync Bottlenecks Appear and How to Eliminate Them

During high‑concurrency flash‑sale events, Oracle’s log file sync became a performance bottleneck; the article analyzes storage, OS, and Oracle Disk Manager factors, presents AWR metrics, demonstrates tuning steps—including disabling adaptive log file sync and enabling ODM—and shows measurable latency reductions.

Database PerformanceLog File SyncODM
0 likes · 18 min read
Why Oracle Log File Sync Bottlenecks Appear and How to Eliminate Them
ITPUB
ITPUB
Nov 14, 2016 · Databases

Optimizing Large‑Scale Oracle Queries with Temporary Tables: Strategies and Trade‑offs

This article examines a high‑volume Oracle query scenario, critiques the current multi‑IN approach, and presents three alternative solutions—including a single‑SQL join, a UNION ALL view, and the use of global temporary tables—detailing their performance implications and practical trade‑offs.

Database PerformanceIndex ScanOracle
0 likes · 10 min read
Optimizing Large‑Scale Oracle Queries with Temporary Tables: Strategies and Trade‑offs
ITPUB
ITPUB
Nov 7, 2016 · Databases

Understanding Oracle’s Top 30 Wait Events: Causes, Parameters, and Tuning Tips

This article enumerates Oracle's most common wait events, explains the underlying reasons each event occurs, lists the associated parameters, provides sample queries for inspection, and offers practical guidance on diagnosing and mitigating performance issues caused by these waits.

Database PerformanceOracleSQL
0 likes · 26 min read
Understanding Oracle’s Top 30 Wait Events: Causes, Parameters, and Tuning Tips
dbaplus Community
dbaplus Community
Oct 18, 2016 · Databases

Mastering Oracle AWR: How to Decode and Optimize Database Performance

This comprehensive guide explains Oracle's Automatic Workload Repository (AWR), how snapshots are collected and retained, and provides step‑by‑step instructions for interpreting the most common AWR report sections, from cache sizes and load profiles to SQL statistics and RAC metrics, helping DBAs pinpoint bottlenecks and improve performance.

AWRDatabase PerformanceOracle
0 likes · 32 min read
Mastering Oracle AWR: How to Decode and Optimize Database Performance
ITPUB
ITPUB
Sep 30, 2016 · Databases

Master Oracle Memory Tuning: Key SGA & PGA Parameters Explained

This guide walks through Oracle's memory architecture, explains SGA and PGA components, details essential memory parameters with recommended values, and provides step‑by‑step SQL checks to diagnose and tune performance on both 32‑bit and 64‑bit systems.

Database PerformanceMemory TuningOracle
0 likes · 14 min read
Master Oracle Memory Tuning: Key SGA & PGA Parameters Explained
dbaplus Community
dbaplus Community
Sep 26, 2016 · Databases

Oracle 12c Memory Innovations: Smart Flash Cache, PGA Limits & In‑Memory Column Store

This article explains Oracle 12c's key memory‑related enhancements—including the extended database cache (Smart Flash Cache), PGA aggregate limit, In‑Memory column store with compression, SIMD processing, temperature‑based replacement, and big‑table cache—detailing their parameters, operation, and monitoring methods for improved database performance.

12cDatabase PerformanceIn-Memory
0 likes · 13 min read
Oracle 12c Memory Innovations: Smart Flash Cache, PGA Limits & In‑Memory Column Store
dbaplus Community
dbaplus Community
Sep 26, 2016 · Databases

Boost MySQL Query Performance with a Python‑Based Optimization Assistant

This article explains how DBA‑focused MySQL query optimization can be accelerated using a Python tool that automates EXPLAIN analysis, statistics collection, optimizer switches, and profiling, while providing step‑by‑step guidance, configuration details, and sample command usage.

Database PerformanceEXPLAINMySQL
0 likes · 18 min read
Boost MySQL Query Performance with a Python‑Based Optimization Assistant
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 7, 2016 · Databases

MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls

This article shares practical MongoDB indexing guidelines—including compound index rules, naming limits, cardinality considerations, TTL and geospatial indexes, lock behavior, and real‑world case studies—to help DBAs and developers design efficient, safe indexes for production workloads.

Database PerformanceGeospatial IndexIndexing
0 likes · 8 min read
MongoDB Indexing Best Practices: Real‑World Tips & Common Pitfalls
dbaplus Community
dbaplus Community
Aug 28, 2016 · Databases

Scaling Databases: From Baseline Metrics to Multi‑Layer Optimization

This guide walks DBAs through evaluating current database resources, establishing performance baselines, building business pressure models, conducting realistic stress tests, and applying a seven‑layer optimization roadmap—from statement tweaks to hardware upgrades and business‑level adjustments—to ensure the system can handle ten‑fold or hundred‑fold growth.

Database PerformanceHardwareOptimization
0 likes · 16 min read
Scaling Databases: From Baseline Metrics to Multi‑Layer Optimization
ITPUB
ITPUB
Aug 12, 2016 · Databases

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.

Database PerformanceOracleSQL Tuning
0 likes · 13 min read
Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters
Efficient Ops
Efficient Ops
Aug 1, 2016 · Databases

Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive

This article critically examines Uber’s claim that MySQL outperforms PostgreSQL by dissecting the alleged PostgreSQL limitations, presenting detailed performance tests, and clarifying the true costs of write amplification, replication, and upgrade processes for both databases.

Database PerformanceMVCCMySQL
0 likes · 20 min read
Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive