Last Updated: November 21, 2025
Focus Areas
| Focus |
|---|
Right-size purge threads
|
Segment buffer pool instances
|
Commands & Queries
SHOW ENGINE INNODB STATUS
Check purge info
SET GLOBAL innodb_purge_threads=4
Tune threads
SET GLOBAL innodb_buffer_pool_instances=8
Shard buffer pools
Summary
Cleaner purge settings keep writes smooth under load.
💡 Pro Tip:
Monitor `SHOW ENGINE INNODB STATUS` regularly to tune purge lag.