Row Lookup

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.