Performance improvement plan for MySQL insert buffer
Hwanggyo Lee, Sang-Won Lee · 2016
Using non-clustered secondary index in MySQL database can cause additional and random disk accesses, degrades the performance of storage device. MySQL's storage engine eases that with Insert Buffer, which is used to avoid additional disk accesses. We verified the improvement effect of using Insert buffer in MySQL by Sysbench benchmark. Furthermore, we suggest an idea for improving Insert buffer's performance, and show simple implementation and its experimental result.