BestHub
Sign in
Tagged articles

InnoDB

928 articles · Page 9 of 10
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention

The guide explains MySQL/InnoDB deadlocks—how circular lock waits arise, the wait‑for‑graph detection that rolls back the transaction with fewer undo logs, the various lock modes and their behavior in UPDATE/INSERT/DELETE, and practical strategies such as proper indexing, consistent access order, and configuration tweaks to detect, handle, and prevent deadlocks.

Database LocksInnoDBInnoDB Lock Types
0 likes · 13 min read
MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 25, 2019 · Databases

Highlights from the 2019 MySQL Technical Exchange Conference in Shenzhen

The 2019 MySQL Technical Exchange Conference in Shenzhen, co‑hosted by Shanghai Aikesheng and Oracle, featured six expert talks covering secure MySQL platform design, large‑scale architecture optimization, backup and recovery strategies, open‑source middleware, automated operations, and InnoDB row‑lock mechanics, followed by community Q&A and a look ahead to open‑source initiatives.

InnoDBMySQLbackup and recovery
0 likes · 5 min read
Highlights from the 2019 MySQL Technical Exchange Conference in Shenzhen
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 30, 2018 · Databases

Analyzing InnoDB Semaphore Crashes and a DBA Diagnostic Tool

The article explains why InnoDB semaphore waits exceeding 600 seconds trigger server crashes, details the lock structures and functions involved, shows how buffer pool pressure and metadata statistics cause contention, and introduces a small DBA utility that parses MySQL error logs to reveal the relationships between threads, locks, and transactions.

DBAInnoDBMySQL
0 likes · 8 min read
Analyzing InnoDB Semaphore Crashes and a DBA Diagnostic Tool
Tencent Database Technology
Tencent Database Technology
Dec 3, 2018 · Databases

Investigation of Duplicate Key Errors After MySQL 5.6→5.7 Upgrade and Auto‑Increment Bugs

The article analyzes why MySQL tables upgraded from 5.6 to 5.7 began generating duplicate‑key errors during inserts, examines related InnoDB auto‑increment mechanisms, reproduces the issue, discusses known bugs (including replace‑into replication problems), and proposes both operational and kernel‑level solutions.

Bug AnalysisDuplicate KeyInnoDB
0 likes · 13 min read
Investigation of Duplicate Key Errors After MySQL 5.6→5.7 Upgrade and Auto‑Increment Bugs
Tencent Database Technology
Tencent Database Technology
Nov 29, 2018 · Backend Development

Investigation of One-Second Timestamp Discrepancy in MySQL Master‑Slave Replication with Server‑Side Prepared Statements

This article investigates why MySQL master‑slave replication can exhibit a one‑second difference in datetime fields when using server‑side prepared statements, analyzing binlog generation, InnoDB rounding, and providing code examples, root‑cause explanation, and mitigation strategies.

InnoDBMySQLPrepared Statements
0 likes · 15 min read
Investigation of One-Second Timestamp Discrepancy in MySQL Master‑Slave Replication with Server‑Side Prepared Statements
Programmer DD
Programmer DD
Nov 17, 2018 · Databases

How InnoDB Indexes Work: From Data Pages to B+ Trees

This article explains how InnoDB stores data pages, builds page directories, and uses B+‑tree indexes—including clustered, secondary, and composite indexes—to enable fast record lookup, while also covering MyISAM indexing differences and the SQL statements for creating and dropping indexes.

B+ TreeInnoDBMySQL
0 likes · 27 min read
How InnoDB Indexes Work: From Data Pages to B+ Trees
Tencent Cloud Developer
Tencent Cloud Developer
Oct 22, 2018 · Databases

TXSQL Internals@2018: Tencent MySQL Architecture and Optimization

The article details Tencent’s TXSQL (Tencent MySQL) architecture and optimizations—including asynchronous table deletion, DDL NO_WAIT/WAIT, MDL visibility, lock splitting, parallel replication, query push‑down, read‑view enhancements, low‑overhead auditing and KMS‑integrated encryption—highlighting its role as the core engine powering CDB for diverse industries such as gaming, finance, e‑commerce and internal services like WeChat and QQ.

CDBCloud DatabaseInnoDB
0 likes · 10 min read
TXSQL Internals@2018: Tencent MySQL Architecture and Optimization
Java Backend Technology
Java Backend Technology
Oct 15, 2018 · Databases

Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls

This article explains MySQL's index structures, how indexes accelerate queries but slow down writes, the differences between B‑tree and hash indexes, clustered versus non‑clustered indexes, the left‑most prefix rule, and provides a comprehensive overview of MySQL locking mechanisms and best practices.

InnoDBLockMySQL
0 likes · 18 min read
Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls
Tencent Cloud Developer
Tencent Cloud Developer
Sep 17, 2018 · Databases

MySQL Schema Design and SQL Development Standards Practice

Tencent Cloud Academy will livestream a MySQL schema design and development standards session on September 17 at 20:00, featuring experts Ye Jinrong and Wu Bingxi, covering best practices such as default InnoDB engine, utf8mb4 charset, row size limits, partitioning, appropriate data types, index guidelines, and operational recommendations.

Development StandardsInnoDBMySQL
0 likes · 9 min read
MySQL Schema Design and SQL Development Standards Practice
Efficient Ops
Efficient Ops
Aug 30, 2018 · Databases

What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts

This article summarizes the major functional and performance enhancements introduced in MySQL 8.0 InnoDB, including a unified data dictionary, atomic DDL, fast column addition, encryption, improved Memcached plugin, parallel redo log writes, and future roadmap items.

InnoDBMySQLPerformance
0 likes · 13 min read
What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts
Efficient Ops
Efficient Ops
Aug 22, 2018 · Databases

Unlocking MySQL: Deep Dive into Metadata and InnoDB Lock Mechanisms

This article presents a comprehensive walkthrough of MySQL's two‑layer architecture, metadata (MDL) locks, InnoDB lock types—including gap and record locks—and practical debugging techniques, helping readers understand lock acquisition, release points, and source‑code entry points for effective database operation and development.

Database InternalsInnoDBLock Mechanisms
0 likes · 19 min read
Unlocking MySQL: Deep Dive into Metadata and InnoDB Lock Mechanisms
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 5, 2018 · Databases

Understanding InnoDB Transaction Isolation Levels and Their Impact on Locks and Performance

This article explains the importance of transaction isolation in ACID, describes the four InnoDB isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—covers their locking behavior, effects on replication, and performance trade‑offs, and offers guidance on choosing the appropriate level.

InnoDBLocksMySQL
0 likes · 7 min read
Understanding InnoDB Transaction Isolation Levels and Their Impact on Locks and Performance
Beike Product & Technology
Beike Product & Technology
Jun 1, 2018 · Databases

InnoDB Transaction and Index Principles

This article explains InnoDB's transaction and index principles, covering ACID properties, transaction logs, MVCC, locking mechanisms, and B+ tree index structures to help backend developers understand how InnoDB ensures data consistency and high concurrency.

ACIDB+ TreeIndex Optimization
0 likes · 11 min read
InnoDB Transaction and Index Principles
21CTO
21CTO
May 24, 2018 · Databases

Boost MySQL Performance: 80/20 Tips to Gain Up to 80% Speed

This guide shows how simple MySQL configuration changes—switching to InnoDB, allocating most RAM to the buffer pool, and enabling multiple buffer pool instances—can deliver up to an 80% performance boost for typical web‑site workloads.

InnoDBMySQLdatabase optimization
0 likes · 5 min read
Boost MySQL Performance: 80/20 Tips to Gain Up to 80% Speed
Tencent Database Technology
Tencent Database Technology
May 9, 2018 · Databases

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Xtrabackup is an open-source hot backup tool for InnoDB and XtraDB databases, offering non-blocking backups with features like fast backup speeds, reliable physical backups, and efficient disk space usage. The recovery process involves complex log parsing and page flushing mechanisms, which can be optimized to improve performance, especially for large datasets.

Backup ToolsDatabase ManagementInnoDB
0 likes · 16 min read
Optimizing Xtrabackup Recovery Process for InnoDB Databases
Hujiang Technology
Hujiang Technology
May 8, 2018 · Databases

Understanding Consistent Reads and MVCC in MySQL InnoDB

This article explains how MySQL InnoDB implements consistent reads using multi‑version concurrency control (MVCC), detailing isolation levels, undo‑log mechanics, hidden columns, rollback segments, transaction commit behavior, and the impact on SELECT, INSERT, UPDATE, and DELETE operations.

Consistent ReadInnoDBMVCC
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 26, 2018 · Databases

How Alibaba Cloud’s Contributions Shaped MySQL: 9 Key Features

At the 2018 Percona Live conference in California, Alibaba Cloud received the MySQL Community Corporate Contributor Award for the first time, recognizing its extensive contributions—including Multiple Source Replication, FlashBack, Sequence, column compression, dynamic column addition, persistent auto‑increment, SemiSync optimization, InnoDB patches, and cross‑engine backup—to the MySQL and MariaDB ecosystems.

AliSQLAlibaba CloudDatabase Contributions
0 likes · 5 min read
How Alibaba Cloud’s Contributions Shaped MySQL: 9 Key Features
ITPUB
ITPUB
Apr 6, 2018 · Databases

Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions

This article provides a comprehensive, step‑by‑step overview of MySQL's InnoDB storage engine, covering database vs instance definitions, internal processes, tablespace layout, file formats, record layouts, B‑tree indexes, lock types, and transaction isolation levels for developers seeking a solid foundation.

InnoDBLocksMySQL
0 likes · 26 min read
Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions
Ctrip Technology
Ctrip Technology
Mar 14, 2018 · Databases

Understanding MySQL Metadata Locks and InnoDB Lock Mechanisms

This article explains MySQL's architecture, details the various metadata lock types, their acquisition and release processes, lock levels, and relationships, and then examines InnoDB's transaction isolation levels, lock types, lock levels, gap locks, and relevant source‑code structures.

Database LocksInnoDBLock Levels
0 likes · 15 min read
Understanding MySQL Metadata Locks and InnoDB Lock Mechanisms
ITPUB
ITPUB
Feb 19, 2018 · Databases

Recovering a Dropped MySQL Database Without Backups

This guide walks through stopping services, backing up the MySQL data directory, compiling the undrop‑for‑InnoDB tool, parsing ibdata1 to rebuild system tables, extracting CREATE TABLE statements, and loading recovered data back into MySQL, while highlighting common pitfalls such as command‑line flags and UTF‑8 emoji issues.

InnoDBLinuxMySQL
0 likes · 7 min read
Recovering a Dropped MySQL Database Without Backups
ITPUB
ITPUB
Feb 8, 2018 · Databases

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

This article explains MySQL's row‑level, table‑level, and page‑level locks, maps them to storage engines, details MyISAM and InnoDB lock types, describes the four internal lock queues, and provides practical optimization and monitoring techniques to improve concurrency and performance.

InnoDBMyISAMMySQL
0 likes · 10 min read
Understanding MySQL Locking Mechanisms: Types, Queues, and Optimization Tips
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 BuildFast Index BuildFill Factor
0 likes · 8 min read
In-Depth Exploration of InnoDB Bulk Index Build
Architecture Digest
Architecture Digest
Jan 21, 2018 · Databases

Common MySQL Concurrency Issues: Table Locks, Metadata Locks, Deadlocks, and Lock Waits

This article examines typical MySQL concurrency problems—including table lock‑induced slow queries, metadata lock blocking during online schema changes, deadlock scenarios, and lock‑wait timeouts—provides step‑by‑step reproductions, analysis of lock behavior, and practical mitigation strategies such as using InnoDB, online DDL tools, and monitoring techniques.

InnoDBLocksMySQL
0 likes · 15 min read
Common MySQL Concurrency Issues: Table Locks, Metadata Locks, Deadlocks, and Lock Waits
ITPUB
ITPUB
Dec 27, 2017 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains the four MySQL transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a sample table and running step‑by‑step command‑line sessions that demonstrate dirty reads, non‑repeatable reads, phantom reads, and the practical limits of InnoDB's MVCC implementation.

InnoDBMySQLSQL
0 likes · 9 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
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.

Index OptimizationInnoDBMySQL
0 likes · 19 min read
Diagnosing and Resolving MySQL InnoDB Deadlocks and Lock‑Wait Timeouts in Data‑Warehouse Workloads
dbaplus Community
dbaplus Community
Dec 19, 2017 · Databases

7 Essential MySQL Performance Tuning Techniques You Must Apply

This article presents seven practical MySQL performance‑tuning techniques—including mastering EXPLAIN, building effective indexes, overriding default settings, optimizing memory usage, adopting SSD storage, scaling horizontally, and improving visibility—while explaining key configuration variables and monitoring tools to keep your database fast and reliable.

EXPLAINInnoDBMySQL
0 likes · 16 min read
7 Essential MySQL Performance Tuning Techniques You Must Apply
ITPUB
ITPUB
Dec 19, 2017 · Databases

Why a Simple DELETE Triggers a MySQL Deadlock – Step‑by‑Step Log Analysis

The article walks through a puzzling MySQL deadlock caused by two concurrent transactions on a table with a unique index, explains how to read the InnoDB status output, identifies the lock types and order, and shows a detailed step‑by‑step reconstruction of the deadlock scenario.

InnoDBMySQLdeadlock
0 likes · 11 min read
Why a Simple DELETE Triggers a MySQL Deadlock – Step‑by‑Step Log Analysis
Qunar Tech Salon
Qunar Tech Salon
Dec 15, 2017 · Databases

InnoDB Memcached Plugin: Architecture, Performance Comparison, Configuration, and High Availability

This article introduces MySQL InnoDB Memcached Plugin, explains its architecture and storage strategies, compares its performance and capacity with traditional MySQL and Redis, provides step‑by‑step installation and configuration commands, and describes a high‑availability deployment using binlog replication and sentinel clusters.

Database CachingInnoDBMySQL
0 likes · 12 min read
InnoDB Memcached Plugin: Architecture, Performance Comparison, Configuration, and High Availability
dbaplus Community
dbaplus Community
Oct 31, 2017 · Databases

What’s New in MySQL 8.0? Key Features, Performance Boosts, and Best Practices

This article summarizes the most compelling MySQL 8.0 enhancements—including a unified Data Dictionary, revamped Information Schema, role‑based privilege management, persistent configuration, auto‑increment fixes, InnoDB histogram and invisible index support, mutex refinements, row‑cache improvements, temporary‑table changes, character‑set updates, default parameter tweaks, and atomic DDL operations—providing practical guidance for DBAs and developers.

8.0InnoDBMySQL
0 likes · 10 min read
What’s New in MySQL 8.0? Key Features, Performance Boosts, and Best Practices
21CTO
21CTO
Oct 31, 2017 · Databases

Mastering InnoDB: Table & Index Design Strategies for High‑Performance MySQL

This article explains InnoDB's record storage mechanics, compares auto‑increment and business primary keys, details primary, secondary, and composite index structures, and shares practical table‑design guidelines and real‑world case studies from ZhaiZhai's MySQL usage.

Composite IndexInnoDBMySQL
0 likes · 12 min read
Mastering InnoDB: Table & Index Design Strategies for High‑Performance MySQL
Architecture Digest
Architecture Digest
Oct 31, 2017 · Databases

Designing MySQL InnoDB Tables and Indexes for Business Scenarios

This article explains InnoDB storage mechanics, compares auto‑increment and business primary keys, details primary, secondary, and composite index structures, and presents practical table‑design principles and real‑world case studies from ZhaiZhai's services to guide developers in building efficient MySQL schemas.

InnoDBMySQLTable Design
0 likes · 12 min read
Designing MySQL InnoDB Tables and Indexes for Business Scenarios
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.

InnoDBMyISAMMySQL
0 likes · 10 min read
Understanding MySQL Locking Mechanisms: Types, Queues, and Optimization Tips
ITPUB
ITPUB
Sep 18, 2017 · Databases

Why MySQL 5.7 Partition Tables Slow Down: Uncovering an InnoDB Lock Regression

The article investigates a performance regression in MySQL 5.7.18 where partitioned tables cause excessive InnoDB row locking, leading to lock timeouts and slower updates, explains the root cause through source‑code analysis, reproduces the issue, validates the findings, and confirms it as a MySQL bug.

InnoDBMySQLPartition Tables
0 likes · 10 min read
Why MySQL 5.7 Partition Tables Slow Down: Uncovering an InnoDB Lock Regression
dbaplus Community
dbaplus Community
Sep 7, 2017 · Databases

Why MySQL 5.7 Partition Tables Slow Down Updates: Uncovering an InnoDB Lock Regression

This article explains how upgrading to MySQL 5.7.18 caused severe performance drops on partitioned tables due to a regression that locks too many rows during single‑row updates, details the reproduction steps, shows the InnoDB lock inspection, pinpoints the faulty code path, and confirms the bug with further tests.

Database InternalsInnoDBLock Regression
0 likes · 9 min read
Why MySQL 5.7 Partition Tables Slow Down Updates: Uncovering an InnoDB Lock Regression
Ctrip Technology
Ctrip Technology
Sep 4, 2017 · Databases

Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables

This article investigates the performance degradation and lock timeout issues observed in MySQL 5.7.18 partition tables, reproduces the problem with test cases, analyzes InnoDB lock behavior through source code debugging, validates the root cause related to partition scan locking, and confirms it as a regression bug in MySQL 5.7.

InnoDBMySQLPartition Tables
0 likes · 8 min read
Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables
MaGe Linux Operations
MaGe Linux Operations
Sep 3, 2017 · Databases

Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup

This article compiles a comprehensive set of MySQL interview questions covering replication mechanisms, differences between MyISAM and InnoDB, character type nuances, transaction logging, binlog formats, performance tuning, backup strategies, monitoring, consistency checks, and handling large datasets, providing concise answers for each topic.

InnoDBMySQLReplication
0 likes · 18 min read
Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup
dbaplus Community
dbaplus Community
Jul 25, 2017 · Databases

How to Build a MySQL Connection & SQL Analyzer for Fast Issue Diagnosis

This article explains how to create a lightweight MySQL tool that extracts connection details from information_schema.processlist, groups them by user, host, database, command and state, fingerprints SQL statements, and correlates them with InnoDB transaction data to quickly pinpoint performance problems.

Connection AnalysisDatabase MonitoringIncident Diagnosis
0 likes · 12 min read
How to Build a MySQL Connection & SQL Analyzer for Fast Issue Diagnosis
ITPUB
ITPUB
Jun 30, 2017 · Databases

Understanding MySQL 5.7 Shared Temporary Tablespace and innodb_temp_data_file_path

This article explains the new shared temporary tablespace introduced in MySQL 5.7, how to configure its size and location with innodb_temp_data_file_path, compares it with tmpdir, demonstrates the impact on compressed and uncompressed InnoDB temporary tables, and highlights related parameters and potential pitfalls.

Database ConfigurationInnoDBMySQL
0 likes · 10 min read
Understanding MySQL 5.7 Shared Temporary Tablespace and innodb_temp_data_file_path
ITPUB
ITPUB
Jun 23, 2017 · Databases

Inside MySQL InnoDB Buffer Pool: Architecture, Data Structures, and Optimization

This article provides an in‑depth technical walkthrough of MySQL InnoDB's Buffer Pool, covering its core data structures, instance layout, LRU and Flush list management, memory allocation strategies, read‑ahead/write‑ahead mechanisms, double‑write buffering, and the specialized threads that keep the pool efficient.

Buffer PoolDatabase InternalsInnoDB
0 likes · 39 min read
Inside MySQL InnoDB Buffer Pool: Architecture, Data Structures, and Optimization
dbaplus Community
dbaplus Community
Jun 11, 2017 · Databases

Boost MySQL 5.7 Restarts with InnoDB Buffer Pool Pre‑Load

This article explains how MySQL 5.7 automatically saves and restores InnoDB buffer‑pool pages, how to tune the innodb_buffer_pool_dump_pct setting, monitor load progress, and handle multi‑node deployments or crashes to achieve faster, more predictable startup performance.

Buffer PoolConfigurationInnoDB
0 likes · 6 min read
Boost MySQL 5.7 Restarts with InnoDB Buffer Pool Pre‑Load
ITPUB
ITPUB
Jun 1, 2017 · Databases

Understanding MySQL InnoDB Deadlocks: Concepts, Examples, and Log Analysis

This article explains MySQL InnoDB deadlocks, describes how the engine detects and resolves them by rolling back a transaction with error 1213, and walks through real‑world examples and log analyses to illustrate the causes and troubleshooting steps.

Error 1213InnoDBMySQL
0 likes · 5 min read
Understanding MySQL InnoDB Deadlocks: Concepts, Examples, and Log Analysis
dbaplus Community
dbaplus Community
May 10, 2017 · Databases

Why InnoDB Needs a Primary Key and How B‑Tree Indexes Work

This article explains the data structures and algorithms behind MySQL indexing, covering B‑Tree fundamentals, insertion and deletion steps with visual examples, the differences between B‑Tree and B+Tree, InnoDB's clustered and secondary index implementations, and why monotonically increasing primary keys improve performance.

B+ TreeB-TreeInnoDB
0 likes · 15 min read
Why InnoDB Needs a Primary Key and How B‑Tree Indexes Work
dbaplus Community
dbaplus Community
Apr 25, 2017 · Databases

9 Proven MySQL Data Recovery Techniques Every DBA Should Know

This guide outlines nine practical MySQL recovery methods—including full backup with binlog, business‑logic rollback, flashback tools, innodb_force_recovery, tablespace discard/import, manual ibd editing, extundelete, and Percona's recovery utility—to help DBAs restore data after accidental deletions, corruption, or hardware failures.

BinlogInnoDBMySQL
0 likes · 12 min read
9 Proven MySQL Data Recovery Techniques Every DBA Should Know
21CTO
21CTO
Apr 15, 2017 · Databases

How Tencent’s TXSQL Supercharges MySQL Performance and Stability in the Cloud

This article details the design, performance enhancements, feature extensions, stability improvements, and benchmark results of TXSQL—a heavily customized MySQL branch used by Tencent Cloud’s CDB service—to illustrate how it achieves higher throughput, stronger consistency, and better reliability for large‑scale cloud databases.

Cloud DatabaseInnoDBMySQL
0 likes · 22 min read
How Tencent’s TXSQL Supercharges MySQL Performance and Stability in the Cloud
dbaplus Community
dbaplus Community
Apr 12, 2017 · Databases

Why InnoDB Double Write Matters: MySQL vs Oracle Recovery Mechanisms

This article explains InnoDB’s double‑write buffer in MySQL, compares its design and recovery handling with Oracle’s redo and control‑file mechanisms, discusses partial‑write issues, checkpoint strategies, performance impacts on SSDs, and provides practical commands and configuration tips for DBAs.

CheckpointInnoDBMySQL
0 likes · 21 min read
Why InnoDB Double Write Matters: MySQL vs Oracle Recovery Mechanisms
ITPUB
ITPUB
Mar 11, 2017 · Databases

How Does MySQL InnoDB Lock Rows? Deep Dive into MVCC, 2PL, and Deadlocks

This article explains MySQL InnoDB's locking mechanisms—including MVCC snapshot vs. current reads, two‑phase locking, isolation levels, lock types, GAP locks, and deadlock scenarios—by analyzing simple and complex SQL examples and showing how different index and isolation configurations affect lock acquisition.

InnoDBMVCCMySQL
0 likes · 25 min read
How Does MySQL InnoDB Lock Rows? Deep Dive into MVCC, 2PL, and Deadlocks
Qunar Tech Salon
Qunar Tech Salon
Mar 9, 2017 · Databases

MySQL DBA Interview Guidance and Insights

This article offers comprehensive advice on MySQL DBA interview preparation, covering the book’s positioning, essential technical topics such as replication and InnoDB internals, desired personal qualities, interview strategies, and practical tips for both interviewers and candidates.

DBAInnoDBMySQL
0 likes · 8 min read
MySQL DBA Interview Guidance and Insights
Tencent Cloud Developer
Tencent Cloud Developer
Mar 9, 2017 · Databases

Benchmarking TokuDB vs InnoDB: Insertion Throughput and Compression Ratio

The benchmark shows that while InnoDB delivers roughly 30 % higher insert throughput than TokuDB, the TokuDB engine achieves 10‑16× storage compression with comparable import times, minimal impact from log‑sync settings, and zlib emerging as the preferred compression algorithm for balanced performance and CPU usage.

BenchmarkCompressionInnoDB
0 likes · 18 min read
Benchmarking TokuDB vs InnoDB: Insertion Throughput and Compression Ratio
ITPUB
ITPUB
Feb 22, 2017 · Databases

Unraveling a Mysterious MySQL Deadlock: Step‑by‑Step Log Analysis

This article walks through a puzzling MySQL InnoDB deadlock case, showing the table schema, the conflicting transactions, how to read the SHOW ENGINE INNODB STATUS output, and the reasoning that reveals why the deadlock occurs and how to diagnose similar issues.

InnoDBMySQLSQL
0 likes · 12 min read
Unraveling a Mysterious MySQL Deadlock: Step‑by‑Step Log Analysis
Java High-Performance Architecture
Java High-Performance Architecture
Feb 7, 2017 · Databases

New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts

The latest MySQL release introduces a transactional data dictionary, role‑based account permission management, multiple InnoDB enhancements—including stable auto‑increment counters, memcached multi‑key support, dynamic deadlock detection, shared temporary tables, and NOWAIT/SKIP LOCKED options—plus advanced JSON operators, aggregation functions, pretty‑print utility, and optimizer features such as hidden and descending indexes.

InnoDBJSONMySQL
0 likes · 4 min read
New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts
dbaplus Community
dbaplus Community
Jan 4, 2017 · Databases

Unveiling InnoDB’s Transaction Struct: 63 Variables Explained

This article dissects the InnoDB transaction structure defined in storage/innobase/include/trx0trx.h, detailing each of the 63 variables—including their types, purpose, and interaction with MySQL’s transaction coordinator—so readers can grasp how InnoDB ensures data consistency and manages transaction state.

InnoDBMySQLdatabase
0 likes · 21 min read
Unveiling InnoDB’s Transaction Struct: 63 Variables Explained
ITPUB
ITPUB
Nov 15, 2016 · Databases

Master MySQL Performance: Essential Configuration Parameters Explained

This guide details the most important MySQL server configuration settings—including connection limits, file handling, cache sizes, MyISAM and InnoDB options—explaining their purpose, recommended values, and how they impact performance and stability.

ConfigurationInnoDBMyISAM
0 likes · 22 min read
Master MySQL Performance: Essential Configuration Parameters Explained
ITPUB
ITPUB
Oct 25, 2016 · Databases

Optimizing MySQL: Key InnoDB Settings and How to Tune Them

This guide explains essential MySQL InnoDB parameters—such as buffer pool size, instances, connection limits, log buffer, statistics collection, lock timeout, thread concurrency, and I/O threads—and provides practical CPU‑based settings to help you optimize database performance.

Database ConfigurationInnoDBMySQL
0 likes · 4 min read
Optimizing MySQL: Key InnoDB Settings and How to Tune Them
ITPUB
ITPUB
Oct 19, 2016 · Databases

Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes

This article demonstrates how InnoDB returns rows in primary‑key order during full‑table scans, while queries that use a secondary index follow the leaf‑node order of that index, and it compares performance implications of index‑only scans versus clustered‑index scans.

InnoDBMySQLdatabase
0 likes · 12 min read
Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes
ITPUB
ITPUB
Oct 18, 2016 · Databases

How to Verify B+Tree Index Order in InnoDB Using bcview and Custom Tools

This article demonstrates a step‑by‑step method to confirm that InnoDB secondary index leaf pages store rows sorted first by the secondary key and then by the primary key, using bcview, mysqlblock, and a small C utility to read raw .ibd pages.

B+ TreeInnoDBbcview
0 likes · 12 min read
How to Verify B+Tree Index Order in InnoDB Using bcview and Custom Tools
ITPUB
ITPUB
Oct 17, 2016 · Databases

Why Some MySQL Inserts Are Blocked: Decoding Next‑Key Lock Ranges

This article examines MySQL InnoDB's next‑key lock behavior by creating a test table, running concurrent transactions, and analyzing how the lock range is determined across primary and secondary index columns, revealing why certain insert statements are blocked while others succeed.

Gap LockInnoDBMySQL
0 likes · 9 min read
Why Some MySQL Inserts Are Blocked: Decoding Next‑Key Lock Ranges
ITPUB
ITPUB
Oct 13, 2016 · Databases

MySQL Nontransactional Statements Explained: Effects on binlog Cache Parameters

The article clarifies that nontransactional statements are SQL commands operating on non‑transactional tables such as MyISAM, explains how MySQL parameters max_binlog_stmt_cache_size and max_binlog_cache_size control memory for these statements, and demonstrates the difference with transactional InnoDB tables through concrete command‑line examples.

BinlogInnoDBMyISAM
0 likes · 4 min read
MySQL Nontransactional Statements Explained: Effects on binlog Cache Parameters
ITPUB
ITPUB
Oct 9, 2016 · Databases

Master MySQL Data Types and Indexes to Boost Performance

This guide explains MySQL's numeric, temporal, and string data types, their storage implications, and how to choose appropriate types, while detailing index types, creation rules, and optimization tips such as prefix lengths and B+Tree versus HASH strategies for faster queries.

Data TypesInnoDBMySQL
0 likes · 11 min read
Master MySQL Data Types and Indexes to Boost Performance
dbaplus Community
dbaplus Community
Sep 12, 2016 · Databases

What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights

This article walks through the major MySQL 5.7 enhancements—including InnoDB buffer‑dump improvements, multi‑threaded page cleaning, dynamic buffer‑pool resizing, global tablespaces, default DYNAMIC row format, native partitioning, truncate‑undo logs, native JSON support, sys schema, optimizer hints, trigger upgrades, syslog integration, and virtual columns—providing practical steps, examples, and usage tips for DBAs.

Database FeaturesInnoDBJSON
0 likes · 12 min read
What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights
ITPUB
ITPUB
Aug 27, 2016 · Databases

Boost MySQL Performance: Proven Tips from Google, Amazon, and More

This article explains how major companies keep MySQL fast at massive scale and provides practical techniques—including schema design, InnoDB advantages, table compression, bulk loading order, and hardware choices—to optimize MySQL performance for billions‑row tables.

HardwareInnoDBMySQL
0 likes · 8 min read
Boost MySQL Performance: Proven Tips from Google, Amazon, and More
MaGe Linux Operations
MaGe Linux Operations
Aug 22, 2016 · Databases

Master MySQL Transaction Isolation Levels and Locking Mechanisms

An in‑depth guide explains MySQL’s four transaction isolation levels, how to modify them globally or per session, the role of autocommit, shared and exclusive lock mechanisms, and provides step‑by‑step InnoDB examples with screenshots illustrating each level’s behavior.

Database ConcurrencyInnoDBMySQL
0 likes · 8 min read
Master MySQL Transaction Isolation Levels and Locking Mechanisms
ITPUB
ITPUB
Jul 19, 2016 · Databases

How to Optimize MySQL InnoDB on SSDs: Practical Tuning Steps and Insights

This article walks through diagnosing severe I/O spikes in a MySQL project, explains SSD characteristics, and provides step‑by‑step InnoDB parameter tweaks, I/O scheduler changes, and monitoring results that lead to a stable, balanced database performance on SSD storage.

InnoDBMySQLSSD
0 likes · 14 min read
How to Optimize MySQL InnoDB on SSDs: Practical Tuning Steps and Insights
dbaplus Community
dbaplus Community
Jul 8, 2016 · Databases

Master MySQL Scheduled Events and Table Partitioning: A Step‑by‑Step Guide

This article explains how to enable MySQL scheduled events, shows the full CREATE EVENT syntax with practical timing examples, covers advanced operations like multi‑statement events and disabling, and then dives into table partitioning techniques (RANGE, HASH, KEY, LIST) with detailed commands and troubleshooting for large InnoDB tables.

InnoDBMySQLScheduled Events
0 likes · 8 min read
Master MySQL Scheduled Events and Table Partitioning: A Step‑by‑Step Guide
Architect
Architect
Jun 22, 2016 · Databases

Introduction to InnoDB Row Locks, Splitting, Inheritance, and Migration

This article explains InnoDB row lock types, including shared and exclusive locks and GAP variants, describes how locks split, inherit, and migrate during B‑tree operations, provides code examples and SQL demonstrations, and discusses related bugs and lock compatibility.

Database InternalsInnoDBLock Splitting
0 likes · 8 min read
Introduction to InnoDB Row Locks, Splitting, Inheritance, and Migration
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBJSON
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
ITPUB
ITPUB
Apr 29, 2016 · Databases

How to Clean Up MySQL Table Fragmentation with OPTIMIZE and ALTER

This guide explains why MySQL tables become fragmented, how to detect fragmentation using information_schema queries, and how to defragment tables safely with OPTIMIZE, ALTER TABLE, or MySQL startup options while noting engine‑specific behavior and best‑practice cautions.

ALTER TABLEInnoDBMyISAM
0 likes · 5 min read
How to Clean Up MySQL Table Fragmentation with OPTIMIZE and ALTER
ITPUB
ITPUB
Apr 26, 2016 · Databases

Why Deleting a Single Row by Unique Index Can Still Cause MySQL Deadlocks

This article analyzes a puzzling MySQL deadlock scenario where concurrent DELETE statements on a uniquely indexed row lead to a deadlock, explaining the lock modes, InnoDB's deadlock‑prevention strategy, and the conditions that make such deadlocks possible.

InnoDBMySQLRepeatable Read
0 likes · 13 min read
Why Deleting a Single Row by Unique Index Can Still Cause MySQL Deadlocks
21CTO
21CTO
Apr 16, 2016 · Databases

How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis

This article provides an in‑depth analysis of MySQL/InnoDB locking mechanisms, covering MVCC snapshot vs current reads, cluster indexes, two‑phase locking, isolation levels, lock behavior for simple and complex SQL statements, and practical deadlock diagnosis techniques.

Database ConcurrencyInnoDBIsolation Level
0 likes · 26 min read
How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis
ITPUB
ITPUB
Apr 14, 2016 · Databases

Master MySQL Transaction Isolation Levels and Lock Mechanisms

This guide explains MySQL's four transaction isolation levels, how to change them globally or per session, the impact of autocommit, the different lock types, and provides step‑by‑step InnoDB examples that illustrate the behavior of READ‑UNCOMMITTED, READ‑COMMITTED, REPEATABLE‑READ, and SERIALIZABLE.

Database ConcurrencyInnoDBMySQL
0 likes · 8 min read
Master MySQL Transaction Isolation Levels and Lock Mechanisms
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Apr 13, 2016 · Databases

MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms

This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.

GTIDGroup CommitInnoDB
0 likes · 24 min read
MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms
ITPUB
ITPUB
Apr 11, 2016 · Databases

Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It

A MySQL replica was consuming an entire CPU core due to single‑process replication, and analysis of binlog and InnoDB status revealed heavy row locks on a table without a primary key, which was resolved by adding an auto‑increment ID, dropping CPU usage to 3% and eliminating replication lag.

BinlogCPUInnoDB
0 likes · 5 min read
Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It