BestHub
search
Sign in
Tag

HASH_SCAN

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 11, 2019 · Databases

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.

Database PerformanceHASH_SCANReplication
0 likes · 11 min read
MySQL Replication: How Slave Row Search Algorithms Influence Data Lookup
Aikesheng Open Source Community
Aikesheng Open Source Community
May 31, 2019 · Databases

Understanding the HASH_SCAN Bug in MySQL Slave Rows Search Algorithms and Its Workarounds

This article explains the MySQL 5.6 slave_rows_search_algorithms parameter, reproduces the HASH_SCAN bug that causes "Can't find record" errors during row‑based replication, analyzes why it occurs, and provides practical solutions such as adjusting keys, changing the algorithm setting, or upgrading MySQL.

HASH_SCANPerformanceReplication
0 likes · 8 min read
Understanding the HASH_SCAN Bug in MySQL Slave Rows Search Algorithms and Its Workarounds