BestHub
Sign in
Tagged articles

InnoDB

905 articles · Page 7 of 10
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.

Concurrency ControlDatabaseInnoDB
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.

Database InternalsInnoDBMySQL
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.

DatabaseDeadlockInnoDB
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+TreeInnoDBMySQL
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.

Database LoggingInnoDBMySQL
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.

DatabaseDeadlockInnoDB
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.

IndexInnoDBMySQL
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.

DatabaseDeadlockInnoDB
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.

InnoDBMySQLUnique Index
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.

Bug AnalysisDuplicate KeyInnoDB
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.

DatabaseInnoDBIsolation Level
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.

DatabaseGroupReplicationInnoDB
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+TreeDataStructureDatabase
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
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
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+TreeInnoDBMySQL
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.

DatabaseInnoDBMVCC
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 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 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.

BinaryLogDatabaseInnoDB
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.

InnoDBMySQLPerformance Schema
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
Programmer DD
Programmer DD
Apr 14, 2020 · Databases

Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies

This article explains InnoDB's logical storage hierarchy of tablespaces, segments, extents, and pages, then details MySQL's partitioning concepts, types, creation syntax, and performance considerations, providing practical examples and guidance for effective database design.

Database ArchitectureInnoDBMySQL
0 likes · 8 min read
Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies
Programmer DD
Programmer DD
Apr 9, 2020 · Databases

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

This article explains how InnoDB organizes data with B+ trees, calculates the maximum number of rows a single tree can hold (around 20 million), and shows how page size, pointer count, and tree height affect MySQL index performance.

B+TreeInnoDBMySQL
0 likes · 11 min read
How Many Rows Can a Single InnoDB B+ Tree Store? A Deep Dive
MaGe Linux Operations
MaGe Linux Operations
Apr 7, 2020 · Databases

Understanding MySQL Locks: Types, Engines, and Deadlock Prevention

This article explains why MySQL requires locking, compares table and row lock types, details MyISAM and InnoDB lock mechanisms—including optimistic vs. pessimistic locks, lock algorithms, and deadlock handling—while providing practical SQL examples and prevention strategies.

Database LocksDeadlockInnoDB
0 likes · 16 min read
Understanding MySQL Locks: Types, Engines, and Deadlock Prevention
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 12, 2020 · Databases

Understanding MySQL Indexes: Types, Implementation, and Best Practices

This article explains what MySQL indexes are, the different categories such as ordinary, unique, composite, clustered and non‑clustered, how B‑Tree, B+Tree and hash indexes are implemented in InnoDB and MyISAM, and why auto‑increment primary keys are recommended for optimal performance.

B-TreeHash IndexIndex
0 likes · 7 min read
Understanding MySQL Indexes: Types, Implementation, and Best Practices
Efficient Ops
Efficient Ops
Mar 5, 2020 · Databases

Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics

This article provides a comprehensive overview of MySQL InnoDB's internal architecture, covering its memory and disk structures, buffer pool, change buffer, adaptive hash index, log buffer, various tablespace types, page layout, undo and redo logs, double‑write buffer, transaction isolation levels, and how the engine satisfies ACID properties.

ACIDDatabaseInnoDB
0 likes · 32 min read
Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 2, 2020 · Databases

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router

This tutorial explains how to create and operate a MySQL InnoDB ReplicaSet—deploying sandbox instances, configuring a replica set with primary and secondary roles, adding nodes, performing manual primary switches and failure recovery, and using MySQL Router to provide an automatic read/write endpoint, while highlighting current limitations.

DatabaseReplicationGTIDInnoDB
0 likes · 8 min read
Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router
Java Backend Technology
Java Backend Technology
Feb 26, 2020 · Databases

How Does MySQL Lock Rows for DELETE? A Deep Dive into MVCC and Isolation Levels

This article explains how MySQL's InnoDB engine applies locks for DELETE and SELECT statements, covering MVCC, snapshot and current reads, clustered indexes, left‑most prefix rules, two‑phase locking, isolation levels, gap and next‑key locks, and analyzes nine different index‑and‑isolation scenarios with detailed conclusions.

InnoDBIsolation LevelsMVCC
0 likes · 16 min read
How Does MySQL Lock Rows for DELETE? A Deep Dive into MVCC and Isolation Levels
Qunar Tech Salon
Qunar Tech Salon
Feb 14, 2020 · Databases

Understanding InnoDB Rollback and UNDO Log Architecture in MySQL

This article explains the internal structure of InnoDB rollback segments, UNDO log storage formats, and the recovery process in MySQL, detailing how transaction IDs, segment headers, page headers, and log records are organized and used to safely roll back or purge data.

Database InternalsInnoDBMySQL
0 likes · 22 min read
Understanding InnoDB Rollback and UNDO Log Architecture in MySQL
Architecture Digest
Architecture Digest
Feb 13, 2020 · Databases

Understanding InnoDB Logical Storage Structure and MySQL Partitioning

This article explains the InnoDB logical storage architecture—including segments, extents, and pages—then introduces MySQL table partitioning concepts, details the main partition types (RANGE, LIST, HASH, KEY) with SQL examples, and discusses their performance implications for OLTP and OLAP workloads.

InnoDBMySQLSQL
0 likes · 8 min read
Understanding InnoDB Logical Storage Structure and MySQL Partitioning
Qunar Tech Salon
Qunar Tech Salon
Feb 13, 2020 · Databases

Understanding InnoDB REDO Log Recovery Process

This article explains how InnoDB uses REDO logs to recover a crashed MySQL database, detailing the steps of locating checkpoints, scanning log segments, parsing mini‑transactions, storing records in hash tables, and applying them to restore data consistency.

Database RecoveryHash TableInnoDB
0 likes · 23 min read
Understanding InnoDB REDO Log Recovery Process
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