BestHub
Sign in
Tagged articles

InnoDB

928 articles · Page 7 of 10
Full-Stack Internet Architecture
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.

InnoDBMyISAMMySQL
0 likes · 13 min read
Understanding MySQL Architecture: Layers, Components, and Storage Engines
Beike Product & Technology
Beike Product & Technology
Jan 6, 2021 · Databases

Analyzing MySQL Deadlock Cases and Prevention Strategies

This article investigates a MySQL InnoDB deadlock observed during a holiday period, explains how gap locks and next‑key locks on a composite index cause mutual waiting, reproduces the issue with large test data, and offers practical guidelines to avoid similar deadlocks in production environments.

Gap LockInnoDBMySQL
0 likes · 12 min read
Analyzing MySQL Deadlock Cases and Prevention Strategies
Code Ape Tech Column
Code Ape Tech Column
Dec 31, 2020 · Databases

Understanding MySQL Transactions: Isolation Levels, MVCC, and Best Practices

This article explains MySQL transaction fundamentals, covering ACID concepts, isolation levels, MVCC implementation, transaction start methods, and practical examples that illustrate how InnoDB ensures atomicity, consistency, isolation, and durability while avoiding common pitfalls such as dirty reads and long‑running transactions.

InnoDBIsolation LevelMVCC
0 likes · 23 min read
Understanding MySQL Transactions: Isolation Levels, MVCC, and Best Practices
Top Architect
Top Architect
Dec 24, 2020 · Databases

Understanding MySQL Indexes: B+Tree Structure, Implementation, and Optimization

This article explains why MySQL uses B+‑tree indexes, describes the principles of B‑tree and B+‑tree structures, compares MyISAM and InnoDB index implementations, and provides practical optimization tips such as using auto‑increment primary keys, the left‑most prefix rule, and proper configuration settings.

B+ TreeInnoDBMyISAM
0 likes · 22 min read
Understanding MySQL Indexes: B+Tree Structure, Implementation, and Optimization
Architect
Architect
Dec 19, 2020 · Databases

Understanding MySQL Indexes: B+ Tree Principles and Optimization

This article explains why MySQL uses B+ trees for indexing, describes the underlying principles of various index types, compares MyISAM and InnoDB implementations, and provides practical optimization guidelines such as using auto‑increment primary keys, left‑most prefix rules, and configuration tuning.

B+TreeInnoDBMyISAM
0 likes · 22 min read
Understanding MySQL Indexes: B+ Tree Principles and Optimization
Programmer DD
Programmer DD
Dec 19, 2020 · Databases

Master MySQL Locks: Isolation Levels, Types, and Deadlock Solutions

This article explains MySQL locking mechanisms, covering lock concepts, isolation level interactions, lock granularity (row, table, page), lock types (shared, exclusive, record, gap, next-key), InnoDB row‑lock implementation, deadlock causes and remedies, and the differences between optimistic and pessimistic locking.

Database ConcurrencyInnoDBLocks
0 likes · 10 min read
Master MySQL Locks: Isolation Levels, Types, and Deadlock Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 17, 2020 · Operations

Root Cause Analysis of MySQL "Opening tables" Stalls Caused by Poor Disk Write Performance and InnoDB Redo Log Flush

The article investigates why a MySQL instance experiences frequent "Opening tables" states, analyzing stack traces, identifying a data dictionary lock held by the dict_stats_thread, and concluding that slow disk writes trigger InnoDB's synchronous dirty‑page flush, blocking many operations.

InnoDBMySQLOpening tables
0 likes · 14 min read
Root Cause Analysis of MySQL "Opening tables" Stalls Caused by Poor Disk Write Performance and InnoDB Redo Log Flush
Senior Brother's Insights
Senior Brother's Insights
Dec 8, 2020 · Databases

How MySQL Locks DELETE and SELECT: MVCC, Isolation Levels & Lock Types

This article explains how MySQL's InnoDB engine applies row‑level locks for DELETE and SELECT statements under various index configurations and isolation levels, covering MVCC, snapshot vs current reads, two‑phase locking, gap and next‑key locks, and the impact of primary, unique, non‑unique, and missing indexes.

InnoDBMVCCMySQL
0 likes · 15 min read
How MySQL Locks DELETE and SELECT: MVCC, Isolation Levels & Lock Types
ITPUB
ITPUB
Dec 4, 2020 · Databases

Mastering MySQL Binlog, Undo Log, Redo Log, and ChangeBuffer

This comprehensive guide explains MySQL's binary log, undo log, redo log, and ChangeBuffer, covering their concepts, purposes, recording formats, flush timing, recovery processes, and how they interact during transactions and crash‑safe recovery.

BinlogChangeBufferDatabaseRecovery
0 likes · 21 min read
Mastering MySQL Binlog, Undo Log, Redo Log, and ChangeBuffer
ITPUB
ITPUB
Nov 23, 2020 · Databases

Eliminating InnoDB Adaptive Hash Index Lock Contention for Faster Queries

The article examines the hidden lock‑contention issue in InnoDB’s Adaptive Hash Index (AHI) observed during high‑concurrency sysbench runs, explains why multiple threads block on the AHI hash table’s exclusive lock, and presents a lightweight fallback optimization that checks the lock before building AHI, reducing lock wait time and stabilizing QPS performance.

Adaptive Hash IndexDatabase InternalsInnoDB
0 likes · 9 min read
Eliminating InnoDB Adaptive Hash Index Lock Contention for Faster Queries
Laravel Tech Community
Laravel Tech Community
Nov 15, 2020 · Databases

MySQL Lock Types and Deadlock Causes with Practical Examples

This article explains MySQL's three lock levels—table, row, and page—describes next‑key, gap, and record locks, analyzes why deadlocks occur, and provides multiple real‑world examples and prevention strategies, including code snippets for reproducible scenarios.

InnoDBLocksMySQL
0 likes · 12 min read
MySQL Lock Types and Deadlock Causes with Practical Examples
ITPUB
ITPUB
Nov 12, 2020 · Databases

How Vivo Scaled to Billions of Records: Sharding and InnoDB Compression Strategies

This article details how Vivo's cloud service tackled explosive data growth by applying horizontal and vertical sharding, routing‑table based dynamic expansion, and MySQL InnoDB compression, providing step‑by‑step guidance, performance results, and practical recommendations for large‑scale database deployments.

Database ScalingInnoDBMySQL
0 likes · 16 min read
How Vivo Scaled to Billions of Records: Sharding and InnoDB Compression Strategies
Architecture Digest
Architecture Digest
Nov 10, 2020 · Databases

MySQL Lock Types, Deadlock Causes, and Prevention Strategies

This article explains MySQL's lock levels, describes various lock algorithms, presents multiple deadlock scenarios with SQL examples, analyzes the root causes, and outlines InnoDB's deadlock prevention mechanisms and detection methods for developers dealing with concurrency issues.

InnoDBLock TypesMySQL
0 likes · 15 min read
MySQL Lock Types, Deadlock Causes, and Prevention Strategies
ITPUB
ITPUB
Nov 5, 2020 · Databases

Why Does MySQL 5.7 Throw Duplicate‑Key Errors After an Auto‑Increment Upgrade?

After upgrading a critical MySQL 5.6 table to 5.7, the system began reporting duplicate‑key errors on master, replica and read‑only instances due to unexpected changes in the AUTO_INCREMENT value, prompting a deep kernel investigation, bug analysis, on‑site reproduction, and practical mitigation steps.

BinlogDuplicate KeyInnoDB
0 likes · 12 min read
Why Does MySQL 5.7 Throw Duplicate‑Key Errors After an Auto‑Increment Upgrade?
ITPUB
ITPUB
Nov 5, 2020 · Databases

Inside MySQL InnoDB: My Interview Journey and Development Insights

The author recounts his 2012 MySQL interview experience, describes the global InnoDB team structure, outlines the bug‑fix and feature‑development workflow, lists key contributions such as spatial indexes and transparent encryption, and reflects on leaving Oracle for Tencent Cloud.

Database DevelopmentInnoDBMySQL
0 likes · 9 min read
Inside MySQL InnoDB: My Interview Journey and Development Insights
vivo Internet Technology
vivo Internet Technology
Nov 4, 2020 · Databases

Scaling Vivo Cloud Service Data Storage: Sharding, Partitioning, and InnoDB Compression Strategies

Vivo Cloud Service scaled from millions to tens of millions of users by applying four sharding strategies—horizontal table partitioning, horizontal database splitting, vertical partitioning, and dynamic routing—while enabling InnoDB compression, which halved storage size, kept CPU impact modest, and preserved ample free capacity for future growth.

InnoDBMySQLcloud services
0 likes · 13 min read
Scaling Vivo Cloud Service Data Storage: Sharding, Partitioning, and InnoDB Compression Strategies
ITPUB
ITPUB
Nov 3, 2020 · Databases

My MySQL InnoDB Journey: From Interview to Six Years of Core Development

The author recounts his 2012 MySQL interview experience, describes the flat, globally distributed InnoDB team structure, details the typical bug‑fix workflow, lists major InnoDB features he contributed to, and reflects on the lessons learned before moving to Tencent Cloud's database division.

Database DevelopmentInnoDBInterview Experience
0 likes · 11 min read
My MySQL InnoDB Journey: From Interview to Six Years of Core Development
Open Source Tech Hub
Open Source Tech Hub
Oct 31, 2020 · Databases

Why MySQL Indexes Matter: From B‑Tree to Covering Indexes Explained

This article explains how MySQL indexes work, comparing binary search trees, red‑black trees, hash tables, B‑trees, B+‑trees, and the differences between MyISAM and InnoDB implementations, and it details primary, secondary, covering, and composite index usage with practical examples.

B+ TreeComposite IndexCovering Index
0 likes · 10 min read
Why MySQL Indexes Matter: From B‑Tree to Covering Indexes Explained
Architecture Digest
Architecture Digest
Oct 30, 2020 · Databases

Understanding Multiversion Concurrency Control (MVCC) in InnoDB

This article explains the concept of Multiversion Concurrency Control (MVCC), how it solves read‑write blocking, deadlocks and consistency issues, and details InnoDB’s implementation—including transaction IDs, hidden columns, undo logs, and the behavior of snapshot and current reads under various isolation levels.

InnoDBMVCCMySQL
0 likes · 9 min read
Understanding Multiversion Concurrency Control (MVCC) in InnoDB
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 26, 2020 · Databases

Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer

This article provides a comprehensive overview of MySQL’s logging mechanisms—including Binlog, Undo log, Redo log, and Change Buffer—explaining their concepts, roles in replication and crash‑recovery, recording formats, flush timing, two‑phase commit, checkpoint handling, and how they interact during data modifications.

BinlogChange BufferDatabase Internals
0 likes · 22 min read
Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer
Laravel Tech Community
Laravel Tech Community
Oct 25, 2020 · Databases

MySQL Lock Types and Deadlock Causes with Practical Examples

This article explains MySQL lock types—table, row, and page locks—their algorithms, common causes of deadlocks, and provides multiple practical examples with SQL statements and diagrams, followed by InnoDB lock‑prevention strategies and detailed analysis of concurrent delete scenarios.

InnoDBLocksMySQL
0 likes · 13 min read
MySQL Lock Types and Deadlock Causes with Practical Examples
ITPUB
ITPUB
Oct 19, 2020 · Databases

Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design

This article explains why MySQL's default InnoDB storage engine uses B+ trees instead of B trees or hash indexes, covering storage engine basics, query performance, I/O considerations, and the structural advantages that make B+ trees ideal for OLTP workloads.

B+ TreeDatabase IndexingInnoDB
0 likes · 16 min read
Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design
Xueersi Online School Tech Team
Xueersi Online School Tech Team
Oct 16, 2020 · Databases

Deep Dive into MySQL InnoDB Record Lookup and Deletion Process

This article explains how MySQL InnoDB locates and deletes a specific row by describing the buffer‑pool lookup, B‑tree page traversal, page‑directory binary search, linear record scan, the compact physical record format, and the handling of signed integers and next‑record offsets, with GDB debugging examples.

Compact Row FormatDatabase InternalsDeletion
0 likes · 25 min read
Deep Dive into MySQL InnoDB Record Lookup and Deletion Process
vivo Internet Technology
vivo Internet Technology
Oct 14, 2020 · Databases

MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup

The MySQL Clone Plugin, added in 8.0.17, enables fast local or remote cloning of InnoDB data by installing the plugin, issuing CLONE commands, monitoring progress via performance_schema tables, and using the resulting GTID or binlog coordinates to build replicas, while observing limitations such as DDL restrictions and single‑instance operation, and offering advantages over XtraBackup through an extra page‑copy stage and simplified GTID handling.

Clone PluginInnoDBMySQL
0 likes · 22 min read
MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup
Programmer DD
Programmer DD
Oct 14, 2020 · Databases

Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide

This article explains MySQL’s essential logging mechanisms—binlog, redo log, and undo log—covering their purposes, formats, configuration parameters, flushing strategies, and roles in replication, recovery, and transaction atomicity, while comparing their differences and illustrating concepts with diagrams.

BinlogDatabase LoggingInnoDB
0 likes · 11 min read
Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide
Programmer DD
Programmer DD
Oct 13, 2020 · Databases

How Many Rows Can an InnoDB B+ Tree Store? A Deep Dive

This article explains how InnoDB’s page size, row size, and B+‑tree structure determine that a single B+ tree can hold roughly twenty‑million rows, shows how to calculate tree height from the root page, and demonstrates the concepts with SQL queries and practical examples.

B+ TreeDatabase StorageInnoDB
0 likes · 11 min read
How Many Rows Can an InnoDB B+ Tree Store? A Deep Dive
MaGe Linux Operations
MaGe Linux Operations
Oct 9, 2020 · Databases

How MySQL Implements Transaction Isolation: Locks, MVCC, and Gap Locks Explained

This article explores the underlying mechanisms MySQL uses to enforce transaction isolation levels, detailing how InnoDB leverages locking, multi-version concurrency control, gap locks, and explicit versus implicit locks to prevent dirty reads, non‑repeatable reads, and phantom reads across the four standard isolation levels.

Database ConcurrencyInnoDBMVCC
0 likes · 11 min read
How MySQL Implements Transaction Isolation: Locks, MVCC, and Gap Locks Explained
ITPUB
ITPUB
Oct 9, 2020 · Databases

Understanding MySQL Lock Types and How to Resolve Common Deadlocks

This article explains MySQL's table, row, and page lock levels, the mechanics of next‑key locks, common deadlock scenarios with practical examples, and offers concrete SQL techniques and InnoDB strategies to prevent and troubleshoot deadlocks.

InnoDBLockMySQL
0 likes · 14 min read
Understanding MySQL Lock Types and How to Resolve Common Deadlocks
Selected Java Interview Questions
Selected Java Interview Questions
Sep 27, 2020 · Databases

Understanding How MySQL InnoDB Solves Phantom Reads

This article explains the four transaction isolation levels, defines phantom reads, and details how MySQL's InnoDB engine uses MVCC snapshot reads and next‑key locking (including the next‑key principle and lock composition) to prevent phantom reads under the REPEATABLE READ isolation level.

InnoDBIsolation LevelMVCC
0 likes · 2 min read
Understanding How MySQL InnoDB Solves Phantom Reads
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 26, 2020 · Databases

Why Indexes Still Lead to Slow Queries: A MySQL Deep Dive

This article explains why using an index does not guarantee fast MySQL queries, examines how execution time, index selectivity, full index scans, and costly back‑to‑table lookups affect slow‑query logs, and presents practical optimization techniques such as virtual columns and index condition push‑down.

InnoDBMySQLindex
0 likes · 13 min read
Why Indexes Still Lead to Slow Queries: A MySQL Deep Dive
Selected Java Interview Questions
Selected Java Interview Questions
Sep 16, 2020 · Databases

In‑Depth Analysis of MySQL/InnoDB Locking Mechanisms

This article provides a comprehensive examination of MySQL/InnoDB locking, covering MVCC, snapshot vs. current reads, cluster indexes, two‑phase locking, isolation levels, detailed lock‑behaviour for various index and isolation combinations, complex query lock analysis, and deadlock detection techniques.

InnoDBMVCCMySQL
0 likes · 23 min read
In‑Depth Analysis of MySQL/InnoDB Locking Mechanisms
Architecture Digest
Architecture Digest
Sep 13, 2020 · Databases

MySQL 8.0 Version History and New Features

An overview of MySQL 8.0’s release timeline, including major GA versions, and a detailed summary of its new capabilities such as transactional data dictionary, atomic DDL, enhanced security, role support, InnoDB improvements, JSON enhancements, optimizer extensions, backup lock, connection management, and other performance and management features.

8.0InnoDBMySQL
0 likes · 10 min read
MySQL 8.0 Version History and New Features
Tencent Database Technology
Tencent Database Technology
Sep 7, 2020 · Databases

InnoDB Index Physical Space Usage Statistics and Page Scan Optimization

The article explains how CDB introduced an InnoDB index physical space usage statistic to help users decide when to run OPTIMIZE TABLE, describes the background of page fragmentation, compares incremental and full‑scan methods, and details a sequential I/O optimization that dramatically reduces measurement time.

InnoDBindex space usageoptimize table
0 likes · 8 min read
InnoDB Index Physical Space Usage Statistics and Page Scan Optimization
Architecture Digest
Architecture Digest
Aug 31, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log

This article explains the purpose, structure, and usage scenarios of MySQL's binlog, redo log, and undo log, detailing how they support replication, crash recovery, and transaction atomicity while balancing performance and data safety.

Database LoggingInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Binlog, Redo Log, and Undo Log
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 19, 2020 · Databases

Understanding MySQL Compressed Tables: Concepts, Benefits, Limitations, and Practical Usage

This article explains the concept of MySQL compressed tables, highlights strong compression products, discusses why and when to use them, outlines their advantages and drawbacks, details supported compression algorithms, and provides step‑by‑step examples for both MyISAM and InnoDB engines along with their impact on B‑tree pages and the InnoDB buffer pool.

Compressed TablesInnoDBMyISAM
0 likes · 13 min read
Understanding MySQL Compressed Tables: Concepts, Benefits, Limitations, and Practical Usage
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 5, 2020 · Databases

Understanding MySQL Tablespaces: System, Single, and General

This article explains the three types of MySQL InnoDB tablespaces—system, single, and general—detailing their structures, configuration options, advantages, disadvantages, and practical procedures for creation, migration, optimization, and removal, with concrete command‑line examples.

Database StorageInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Tablespaces: System, Single, and General
JavaEdge
JavaEdge
Jul 25, 2020 · Databases

Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer

This article explains the differences between normal and unique indexes in MySQL, examines how they affect query and update performance, details InnoDB's change‑buffer mechanism, and provides practical guidance on when to prefer ordinary indexes for better write efficiency.

Change BufferInnoDBMySQL
0 likes · 13 min read
Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer
ITPUB
ITPUB
Jul 18, 2020 · Databases

Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It

After upgrading a MySQL 5.6 master to 5.7, inserts on several InnoDB tables began failing with duplicate‑key errors because the auto_increment value became inconsistent, and the article walks through kernel‑level investigation, reproduction steps, bug analysis, and practical fixes.

BinlogBug AnalysisDuplicate Key
0 likes · 11 min read
Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It
JavaEdge
JavaEdge
Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

InnoDBIsolation LevelMySQL
0 likes · 8 min read
Understanding MySQL Transaction Isolation Levels and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 14, 2020 · Databases

Key Features of MySQL 8.0.21 Release

MySQL 8.0.21 introduces numerous enhancements such as dynamic redo log control, optional tablespace path validation, refined lock system, JSON_VALUE function, atomic CREATE TABLE…AS SELECT, optimizer improvements, reduced group replication cache, multi‑address X Plugin support, and various security and deprecation updates.

GroupReplicationInnoDBJSON
0 likes · 12 min read
Key Features of MySQL 8.0.21 Release
21CTO
21CTO
Jul 10, 2020 · Databases

Why MySQL 5.7 Upgrade Triggers Duplicate Key Errors on Auto‑Increment?

After upgrading a critical MySQL client from 5.6 to 5.7, duplicate‑key errors appeared during inserts on master, replica and read‑only instances, prompting a deep dive into InnoDB auto‑increment mechanics, related kernel bugs, on‑site analysis, and both application‑side and engine‑side remediation strategies.

Bug AnalysisDuplicate KeyInnoDB
0 likes · 12 min read
Why MySQL 5.7 Upgrade Triggers Duplicate Key Errors on Auto‑Increment?
dbaplus Community
dbaplus Community
Jul 8, 2020 · Databases

Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures

This article walks through the evolution of MySQL index implementations—from hash tables and binary search trees to AVL, red‑black, B‑trees and finally B+ trees—explaining their performance trade‑offs, disk‑I/O considerations, and how InnoDB and MyISAM store data and indexes differently.

B+ TreeDataStructureInnoDB
0 likes · 21 min read
Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures
Top Architect
Top Architect
Jun 27, 2020 · Databases

MySQL Lock Mechanisms: Row‑Level, Table‑Level, Page‑Level Locks and Optimistic vs Pessimistic Concurrency Control

This article explains MySQL's locking mechanisms, detailing row‑level, table‑level, and page‑level locks, their characteristics and usage, and compares optimistic and pessimistic concurrency control, including implementation methods, storage‑engine specifics, deadlock causes, and strategies to avoid them.

InnoDBLocksMySQL
0 likes · 13 min read
MySQL Lock Mechanisms: Row‑Level, Table‑Level, Page‑Level Locks and Optimistic vs Pessimistic Concurrency Control
Architecture Digest
Architecture Digest
Jun 19, 2020 · Databases

How Many Rows Can an InnoDB B+ Tree Store?

This article explains the storage units of InnoDB, how B+‑tree indexes are organized on pages, calculates the maximum number of rows a B+ tree can hold based on page size and pointer count, and shows how to determine the tree height from the tablespace file.

B+ TreeDatabase IndexingInnoDB
0 likes · 9 min read
How Many Rows Can an InnoDB B+ Tree Store?
MaGe Linux Operations
MaGe Linux Operations
Jun 12, 2020 · Databases

Master MySQL Performance Metrics: TPS, QPS, InnoDB Stats & Monitoring Tips

This article explains how to retrieve and interpret key MySQL performance metrics—including TPS, QPS, thread status, InnoDB I/O, buffer pool health, MyISAM statistics, temporary tables, response time, and replication lag—using mysqladmin, SHOW GLOBAL STATUS, and Percona tools, with practical calculation formulas and command examples.

InnoDBMySQLPerformance Monitoring
0 likes · 8 min read
Master MySQL Performance Metrics: TPS, QPS, InnoDB Stats & Monitoring Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 12, 2020 · Databases

Evaluating Whether pt-table-checksum Affects Business Performance

This article presents a hands‑on experiment that measures the performance impact of using pt‑table‑checksum on a MySQL master‑slave setup, explains the tool’s design choices such as reduced lock‑wait time and RR isolation, and concludes that its effect on production traffic is minimal when configured properly.

Database ReplicationInnoDBMySQL
0 likes · 4 min read
Evaluating Whether pt-table-checksum Affects Business Performance
macrozheng
macrozheng
Jun 12, 2020 · Databases

Why Does MySQL Show Negative Balances? Unraveling MVCC and Isolation Levels

This article analyzes a production incident where concurrent MySQL transactions caused an over‑deduction of account balance, explains the underlying MVCC mechanism, consistency view rules, and how different isolation levels (RR vs RC) affect data visibility and lead to negative balances.

InnoDBMVCCMySQL
0 likes · 12 min read
Why Does MySQL Show Negative Balances? Unraveling MVCC and Isolation Levels
Sohu Tech Products
Sohu Tech Products
May 6, 2020 · Databases

Why MySQL AUTO_INCREMENT Primary Keys Are Not Monotonic or Continuous

The article explains why MySQL's AUTO_INCREMENT primary keys can become non‑monotonic and non‑continuous due to early‑version in‑memory counters, restart behavior, concurrency lock modes, and how MySQL 8.0 persists the counter to mitigate these issues while discussing design trade‑offs and best practices.

InnoDBMySQLauto-increment
0 likes · 11 min read
Why MySQL AUTO_INCREMENT Primary Keys Are Not Monotonic or Continuous
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 TroubleshootingIndex OptimizationInnoDB
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2020 · Databases

New Features in MySQL 8.0.20 Release

MySQL 8.0.20 introduces a range of enhancements including new SHOW_ROUTINE privilege, hash join improvements, index‑level optimizer hints, performance schema refinements, SQL syntax changes, InnoDB doublewrite buffer relocation, binary log transaction compression, X Plugin and protocol upgrades, and additional replication options.

BinaryLogInnoDBMySQL
0 likes · 5 min read
New Features in MySQL 8.0.20 Release
Programmer DD
Programmer DD
Apr 26, 2020 · Databases

Understanding MySQL Table and Row Locks: Mechanisms, Modes, and Types

This article explains the differences between MySQL table locks and row locks, how they are implemented by the server and storage engines, the lock modes and types (including intention, auto‑increment, gap, next‑key, and insert‑intention locks), and provides practical SQL examples with diagrams.

Gap LockInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Table and Row Locks: Mechanisms, Modes, and Types
Architecture Digest
Architecture Digest
Apr 24, 2020 · Databases

Detailed Explanation of MySQL InnoDB Lock Mechanisms

This article provides a comprehensive overview of MySQL InnoDB locking, covering shared/exclusive locks, intention locks, record locks, gap locks, next‑key locks, insert‑intention locks, and auto‑increment locks, with examples, compatibility tables, and practical SQL snippets to illustrate each mechanism.

Database ConcurrencyInnoDBLocks
0 likes · 12 min read
Detailed Explanation of MySQL InnoDB Lock Mechanisms
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 21, 2020 · Databases

Diagnosing and Resolving MySQL InnoDB Row Lock Wait Timeout Errors

This article explains the causes of MySQL InnoDB row lock wait timeout errors, distinguishes row and metadata lock waits, and provides practical methods—including manual replication, monitoring scripts, general_log analysis, and Performance Schema queries—to locate, diagnose, and resolve such locking issues.

InnoDBMySQLlock_wait_timeout
0 likes · 18 min read
Diagnosing and Resolving MySQL InnoDB Row Lock Wait Timeout Errors
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2020 · Databases

Understanding and Managing Undo Tablespaces in MySQL 8.0

This article explains the concept of MySQL Undo Log, traces its evolution from version 5.5 to 8.0, and provides step‑by‑step instructions with examples for creating, viewing, configuring, deleting, and moving undo tablespaces, highlighting the new parameters and defaults introduced in MySQL 8.0.

InnoDBMySQLSQL
0 likes · 9 min read
Understanding and Managing Undo Tablespaces in MySQL 8.0