BestHub
Sign in
Tag

InnoDB

1 views collected around this technical thread.

Sohu Tech Products
Sohu Tech Products
Jun 11, 2025 · Databases

Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes

This article explains MySQL InnoDB's dual memory and on‑disk architecture, detailing the various tablespace types (system, file‑per‑table, general, undo, temporary), their internal structures (segments, extents, pages), configuration tips, and how tables, row formats, primary keys, auto‑increment lock modes, and B+Tree indexes are organized and managed.

Database ArchitectureIndexesInnoDB
0 likes · 18 min read
Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 11, 2025 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—through step‑by‑step examples, demonstrating their effects on dirty reads, non‑repeatable reads, phantom reads, and performance considerations, helping developers choose the appropriate level.

Database ConcurrencyInnoDBMySQL
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
Sanyou's Java Diary
Sanyou's Java Diary
Jun 9, 2025 · Databases

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

This article explores the inner workings of InnoDB's architecture—including the Buffer Pool, Change Buffer, Adaptive Hash Index, and Log Buffer—detailing their designs, configuration parameters, performance impacts, and best‑practice recommendations for high‑throughput MySQL deployments.

Adaptive Hash IndexBuffer PoolChange Buffer
0 likes · 15 min read
Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance
Cognitive Technology Team
Cognitive Technology Team
Jun 7, 2025 · Databases

Mastering MySQL Locks: Types, Mechanisms, and Best Practices

This article explains MySQL’s locking mechanisms, categorizing locks by performance, operation type, data granularity, and finer‑grained levels such as gap and next‑key locks, and offers guidance on selecting the appropriate lock strategy for reliable concurrent database operations.

InnoDBMySQLTransaction Isolation
0 likes · 9 min read
Mastering MySQL Locks: Types, Mechanisms, and Best Practices
Lobster Programming
Lobster Programming
Jun 3, 2025 · Databases

Master MySQL Locks: From Row to Intention Locks Explained with Real Examples

This article explains MySQL InnoDB locking mechanisms—including row, record, gap, next‑key, and intention locks—illustrates each type with SQL statements and performance_schema data, and shows how they interact during concurrent transactions.

InnoDBLocksMySQL
0 likes · 8 min read
Master MySQL Locks: From Row to Intention Locks Explained with Real Examples
IT Services Circle
IT Services Circle
May 23, 2025 · Databases

MySQL Index Limits: Maximum Number of Indexes, Columns per Index, and Design Guidelines

This article explains MySQL's index limits for InnoDB and MyISAM engines, detailing the maximum number of indexes per table, the maximum columns per index, and provides practical recommendations on how many indexes a table should have to balance performance and maintenance.

Database DesignIndexesInnoDB
0 likes · 6 min read
MySQL Index Limits: Maximum Number of Indexes, Columns per Index, and Design Guidelines
Code Ape Tech Column
Code Ape Tech Column
Apr 23, 2025 · Databases

Impact of Full Table Scans on MySQL Server Memory and InnoDB Buffer Pool

A full‑table scan of a 200 GB InnoDB table on a MySQL server with 100 GB RAM does not exhaust server memory because MySQL streams rows to the client, uses a fixed net_buffer, and InnoDB’s optimized LRU algorithm limits buffer‑pool pressure, ensuring stable performance.

Buffer PoolFull Table ScanInnoDB
0 likes · 10 min read
Impact of Full Table Scans on MySQL Server Memory and InnoDB Buffer Pool
Zhuanzhuan Tech
Zhuanzhuan Tech
Apr 23, 2025 · Databases

Quick 3‑Step Guide to Locate and Analyze MySQL InnoDB Deadlocks

This article explains how to find the MySQL deadlock log, parse its contents to determine the time, order, and affected rows, identify the lock types and root cause, and provides extended examples of special locking scenarios, all illustrated with real‑world SQL and code snippets.

DeadlockInnoDBMySQL
0 likes · 15 min read
Quick 3‑Step Guide to Locate and Analyze MySQL InnoDB Deadlocks
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2025 · Databases

Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution

This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.

Database TroubleshootingInnoDBMySQL
0 likes · 9 min read
Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution
macrozheng
macrozheng
Apr 11, 2025 · Databases

Why MySQL count() Slows Down on Large Tables and How to Speed It Up

This article explains how MySQL's count() works across storage engines, why InnoDB scans rows and can time out on massive tables, and presents practical alternatives such as using EXPLAIN rows, a dedicated count table, batch processing, or binlog‑to‑Hive for efficient row‑count estimation.

InnoDBMyISAMMySQL
0 likes · 14 min read
Why MySQL count() Slows Down on Large Tables and How to Speed It Up
Lobster Programming
Lobster Programming
Mar 31, 2025 · Databases

How Does MySQL Store Data? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL stores its data on disk, how the InnoDB engine organizes files, pages, extents, segments, and rows, and details the Compact, Dynamic, and Compressed row formats, including null‑value handling and overflow mechanisms.

InnoDBMySQLStorage Engine
0 likes · 16 min read
How Does MySQL Store Data? Inside InnoDB Files, Pages, and Row Formats
Cognitive Technology Team
Cognitive Technology Team
Mar 26, 2025 · Databases

InnoDB Index Types, Physical Structure, Sorted Index Build, and Full‑Text Indexing

This article explains InnoDB clustered and secondary indexes, their physical B‑tree storage, page‑size and fill‑factor settings, the three‑phase sorted index build process, and the design, tables, cache, document‑ID handling, transaction semantics, and monitoring of InnoDB full‑text indexes.

Database DesignFull-Text SearchIndexes
0 likes · 17 min read
InnoDB Index Types, Physical Structure, Sorted Index Build, and Full‑Text Indexing
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 24, 2025 · Databases

Analysis of MySQL Bug #115352: InnoDB Assertion Failure When Killing a Partition‑Table ALTER

This article walks through the investigation of MySQL bug #115352, describing how an assertion failure in InnoDB’s dictionary cache caused a server crash during a killed ALTER TABLE on a partitioned table, the debugging steps taken, and the eventual fix applied in MySQL 8.0.40.

CorefileData DictionaryInnoDB
0 likes · 9 min read
Analysis of MySQL Bug #115352: InnoDB Assertion Failure When Killing a Partition‑Table ALTER
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 5, 2025 · Databases

Overview of MySQL Transaction, Lock, and Undo Modules – Article Index

This article provides a comprehensive index of a MySQL internals series covering the transaction, lock, and undo modules, detailing each sub‑topic such as transaction initialization, two‑phase commit, various lock types, deadlock handling, and undo log management across numerous linked articles.

Database InternalsInnoDBLock
0 likes · 7 min read
Overview of MySQL Transaction, Lock, and Undo Modules – Article Index
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2025 · Databases

MySQL InnoDB Transaction Commit: Undo Segment State Changes and Cleanup Process

The article explains how InnoDB handles transaction commit by modifying Insert and Update Undo segment states, generating a transaction commit number, adding rollback segments to the purge queue, and finally cleaning or caching Undo segments based on their usage and state.

Database InternalsInnoDBMySQL
0 likes · 11 min read
MySQL InnoDB Transaction Commit: Undo Segment State Changes and Cleanup Process
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2025 · Databases

Parsing Delete Undo Log in MySQL 8.0.32 InnoDB

This article explains how to read and parse the Undo log generated by a DELETE operation in MySQL 8.0.32 InnoDB, covering preparation, log extraction, detailed field parsing, locating the primary index record, and the step‑by‑step rollback of secondary and primary index records.

Database InternalsInnoDBMySQL
0 likes · 10 min read
Parsing Delete Undo Log in MySQL 8.0.32 InnoDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 12, 2025 · Databases

Understanding the Delete Undo Log Format in MySQL 8.0 InnoDB

This article explains how MySQL 8.0 InnoDB generates and stores Delete Undo logs, detailing the log structure, field meanings, type_flag and info_bits decoding, address composition via DB_ROLL_PTR, and provides concrete SQL examples and shell calculations to illustrate the process.

Database InternalsDelete OperationInnoDB
0 likes · 11 min read
Understanding the Delete Undo Log Format in MySQL 8.0 InnoDB
IT Services Circle
IT Services Circle
Feb 2, 2025 · Databases

Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM

This article experimentally compares the performance of various MySQL COUNT queries on an InnoDB table with one million rows, explains the underlying execution plans using EXPLAIN, analyzes primary‑key versus secondary‑index behavior, and contrasts InnoDB’s fast count implementation.

EXPLAINIndexesInnoDB
0 likes · 9 min read
Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 22, 2025 · Databases

Parsing and Rolling Back Update Undo Logs in MySQL 8.0.32 (InnoDB)

This article explains how MySQL 8.0.32's InnoDB engine generates, reads, and parses Undo logs for an UPDATE operation, and details the step‑by‑step process of locating the primary record, constructing a rollback record, and restoring both secondary and primary index entries.

Database InternalsInnoDBMySQL
0 likes · 14 min read
Parsing and Rolling Back Update Undo Logs in MySQL 8.0.32 (InnoDB)