numa
INFO
Rule IDs: os_006
Overview
- Purpose
- NUMA topology / interleave hints from host diagnostics relevant to memory locality.
- Dynamic (MySQL 8.4 reference)
- Hardware and OS — MySQL exposes related InnoDB variables separately (for example
innodb_numa_interleave). - Default value
- N/A
- Version and product notes
- N/A
- Documentation
- Primary reference depends on product (MySQL, MariaDB, Percona, or OS documentation).
What is checked
Rules that reference this variable, with their severity and what each rule detects:
- INFO
os_006: Enable innodb_numa_interleave=ON or start mysqld with numactl --interleave=all.
Tuning guidance
- Recommended actions:
- Enable innodb_numa_interleave=ON or start mysqld with numactl --interleave=all.
- Trade-offs: OS tuning (swap, THP, NUMA, I/O scheduler) operates outside MySQL but directly affects database performance. Changes require root access and may need a reboot.
Example
-- In my.cnf: innodb_numa_interleave = ON -- Or start mysqld with: numactl --interleave=all