Multiple-Column Indexes For Optimization

Covering Index For Optimization

ORDER BY Optimization

INSERT Optimization

Auto Increment Lock Mode Optimization

Index Dive Optimizaiton

Prefix Index Optimization

InnoDB Deadlock Detect Optimization

NoOffset Optimization

SELECT … FOR UPDATE SKIP LOCKED Optimization

InnoDB Buffer Pool Optimization

InnoDB Buffer Pool Flushing Optimization

Redo log/InnoDB log file size Optimization