Tagged articles

MySQL 8.0

9 articles · Page 1 of 1

Sep 16, 2026 · Databases

When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem

Adding three secondary indexes to a MySQL 8.0 orders table caused write P99 latency to jump from 15ms to 2.3s and TPS to drop from 4800 to 1100 during peak hours; the article details a reproducible forensic process using A/B testing, invisible indexes, and sysbench to prove the culprit index had zero read benefit and safely remove it.

A/B testingInnoDBMySQL 8.0

0 likes · 23 min read

When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem

ITPUB

Sep 7, 2026 · Databases

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

This article explains InnoDB's checkpoint mechanism, contrasting synchronous and fuzzy checkpoints, detailing the pre-MySQL 8.0 fuzzy checkpoint implementation using flush lists and page cleaners, and describing two principles for detecting abnormal shutdowns plus four post-restart crash scenarios with their recovery requirements.

CheckpointCrash RecoveryInnoDB

0 likes · 11 min read

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

Aikesheng Open Source Community

May 12, 2025 · Databases

Understanding MySQL Error MY-013129 and How to Handle It

This article explains the MySQL MY-013129 error, its lack of a fixed message, the code paths that generate it in MySQL 8.0, why it is logged as an ERROR, and practical recommendations for filtering or handling the log entries.

Log FilteringMY-013129MySQL

0 likes · 7 min read

Understanding MySQL Error MY-013129 and How to Handle It

ITPUB

Jul 8, 2023 · Databases

Bypass MySQL "Too Many Connections" with Admin Port and MySQL 8.0.14 Features

This article explains why MySQL reports error 1040 "Too many connections", shows how Percona Server can reserve an admin port to keep DBA access, and details MySQL 8.0.14's built‑in admin connection feature with configuration steps, commands, and a performance experiment.

Admin ConnectionMySQLMySQL 8.0

0 likes · 7 min read

Bypass MySQL "Too Many Connections" with Admin Port and MySQL 8.0.14 Features

Tencent Database Technology

Jan 19, 2023 · Databases

Atomic DDL Implementation in MySQL 8.0: Metadata Management and DDL Log Mechanisms

This article provides a comprehensive technical analysis of MySQL 8.0's atomic DDL implementation, detailing the transition from fragmented FRM-based metadata to a unified InnoDB Data Dictionary, and explaining how the DDL Log mechanism ensures crash-safe physical file operations during schema modifications.

Atomic DDLDDL LogInnoDB Engine

0 likes · 17 min read

Atomic DDL Implementation in MySQL 8.0: Metadata Management and DDL Log Mechanisms

Aikesheng Open Source Community

Dec 16, 2021 · Databases

MySQL 8.0 New Password Policies: Dual‑Password Strategy and Random Password Generation

This article explains MySQL 8.0's dual‑password mechanism for smooth password rotation and its built‑in random password generation feature, providing step‑by‑step commands, usage scenarios, and important cautions for database administrators.

Dual PasswordMySQLMySQL 8.0

0 likes · 8 min read

MySQL 8.0 New Password Policies: Dual‑Password Strategy and Random Password Generation

Programmer DD

Jul 27, 2021 · Databases

How Facebook Overcame the Challenges of Migrating to MySQL 8.0

Facebook’s engineering team detailed a multi‑year, complex migration from MySQL 5.6 to 8.0, highlighting custom‑feature porting, replication compatibility, query changes, performance regressions, and documentation gaps, and explaining how they finally achieved a successful upgrade.

Custom FeaturesFacebookMySQL 8.0

0 likes · 5 min read

How Facebook Overcame the Challenges of Migrating to MySQL 8.0

Aikesheng Open Source Community

Apr 1, 2021 · Databases

Understanding MySQL 8.0 validate_password Component and Its Impact on Password Policy

The article explains why some MySQL 8.0.18 production environments enforce a password policy despite lacking the validate_password plugin, by examining configuration files, server parameters, and the role of the validate_password component introduced in MySQL 8.0.

MySQLMySQL 8.0components

0 likes · 3 min read

Understanding MySQL 8.0 validate_password Component and Its Impact on Password Policy

Aikesheng Open Source Community

Sep 3, 2020 · Databases

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

The first episode of the “MySQL Chōng Chōng Chōng” livestream discusses why now is an excellent time to upgrade to MySQL 8.0, covering fast add‑column, Atomic DDL, Hash Join, Group Replication, authentication changes, and includes thanks to sponsors and a preview of the next show.

Atomic DDLFast Add ColumnGroup Replication

0 likes · 9 min read

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”