innodb_doublewrite
INFO
Rule IDs: io_010
Overview
- Purpose
- Configuration or diagnostic item referenced in tuning reviews. It may be vendor-specific, renamed between versions, or not present in the bundled MySQL 8.4 summary table under this exact name.
- Dynamic (MySQL 8.4 reference)
- Not found in the bundled MySQL 8.4 variable summary extract under
innodb_doublewrite. Do not assume it is dynamic orSET GLOBAL-able — open the manual for your exact product and version. - Default value
- See vendor documentation.
- Version and product notes
- Compare MySQL, MariaDB, and Percona Server manuals; names changed across releases (for example replication terminology).
- Documentation
- https://dev.mysql.com/doc/refman/8.4/en/server-system-variable-reference.html
- Other vendors
What is checked
Rules that reference this variable, with their severity and what each rule detects:
- INFO
io_010: Keep innodb_doublewrite=ON unless using a filesystem with atomic writes (ZFS) or battery-backed RAID with write-back cache.
Tuning guidance
- Recommended actions:
- Keep innodb_doublewrite=ON unless using a filesystem with atomic writes (ZFS) or battery-backed RAID with write-back cache.
- Trade-offs: Higher I/O capacity values push more writes to disk, reducing lag and crash recovery time, but can saturate storage on spinning disks. Match settings to your storage hardware (SSD vs HDD).
Example
Look up this name (and synonyms) in vendor documentation before changing anything in production.