Optimizing InnoDB Disk I/O tablespace files (due to doublewrite buffering prior to MySQL 8.0.20 and change buffering), doublewrite files introduced in MySQL 8.0.20, and log files such as binary log files and redo log files. Review settings for the following configuration options when using non-rotational storage: The  crc32  option uses a faster checksum algorithm and is recommended for fast storage systems. Optimizes I/O for rotational storage devices. Disable it for non-rotational storage or a mix of rotational and non-rotational storage. It is disabled by default. Permits placing a limit on page flushing during idle periods, which can help extend the life of non- rotational storage devices. Introduced in MySQL 8.0.18. The default setting of 200 is generally sufficient for a lower-end non-rotational storage device. For higher-end, bus-attached devices, consider a higher setting such as 1000. The default value of 2000 is intended for workloads that use non-rotational storage. For a high-end, bus-attached non-rotational storage device, consider a higher setting such as 2500. If redo logs are on non-rotational storage, consider disabling this option to reduce logging. See Disable logging of compressed pages. If redo logs are on non-rotational storage, configure this option to maximize caching and write combining. Consider using a page size that matches the internal sector size of the disk. Early-generation SSD devices often have a 4KB sector size. Some newer devices have a 16KB sector size. The default InnoDB  page size is 16KB. Keeping the page size close to the storage device block size minimizes the amount of unchanged data that is rewritten to disk. If binary logs are on non-rotational storage and all tables have primary keys, consider setting this option to  minimal  to reduce logging. Ensure that TRIM support is enabled for your operating system. It is typically enabled by default. • innodb_checksum_algorithm • innodb_flush_neighbors • innodb_idle_flush_pct • innodb_io_capacity • innodb_io_capacity_max • innodb_log_compressed_pages • innodb_log_file_size • innodb_page_size • binlog_row_image 1754