Aikesheng Open Source Community
Jul 1, 2020 · Databases
How to Configure fs.aio-max-nr for MySQL InnoDB to Prevent AIO Slot Errors
The article explains why MySQL may fail to start when the number of required AIO event slots exceeds the system's fs.aio-max-nr setting, demonstrates how to observe the slots with strace, and provides formulas and recommendations for configuring fs.aio-max-nr in single‑ and multi‑instance deployments.
InnoDBMySQLPerformance
0 likes · 4 min read