MySQL Replication: How Slave Row Search Algorithms Influence Data Lookup

This article explains how MySQL's slave_rows_search_algorithms setting and the presence of primary or unique indexes affect the way a replica locates rows for DELETE operations, compares index‑scan, table‑scan, and hash‑scan methods, and provides practical guidance to reduce replication lag.

BinlogHash ScanIndex Scan

0 likes · 11 min read

MySQL Replication: How Slave Row Search Algorithms Influence Data Lookup

21CTO

Apr 1, 2016 · Databases

How MySQL 5.7 Optimizes Metadata Locks and Hash Scan for Faster Replication

This article details the evolution of MySQL's Metadata Lock subsystem, the implementation of lock‑free hash tables and fast‑path locking in MySQL 5.7, the hash_scan algorithm used in replication, as well as performance enhancements in TokuDB 7.5.0 and MariaDB's small‑LIMIT filesort optimization.

Database InternalsHash Scanmetadata lock

0 likes · 18 min read

How MySQL 5.7 Optimizes Metadata Locks and Hash Scan for Faster Replication

21CTO

Sep 25, 2015 · Databases

How MySQL 5.7 Optimizes Metadata Locks and Boosts Replication Performance

This article explains the evolution of MySQL's metadata lock (MDL) subsystem, the introduction of lock‑free hash tables and fast‑path locking in 5.7, the hash_scan replication optimization, TokuDB 7.5.0 enhancements, and MariaDB's small‑LIMIT filesort improvement, providing deep insight into modern database performance tuning.

Hash ScanMariaDBTokuDB

0 likes · 17 min read

How MySQL 5.7 Optimizes Metadata Locks and Boosts Replication Performance