Tencent Database Technology

Dec 17, 2018 · Databases

Investigation of MySQL Slave SQL Thread IO Spikes Caused by Concurrent InnoDB Tablespace Extensions

This article analyzes intermittent IO write spikes in a MySQL slave instance, tracing them to concurrent InnoDB tablespace extensions triggered by large BLOB inserts across thousands of tables, and proposes mitigation strategies.