Bug #111038 Extend documentation about innodb_flush_sync wrt to innodb_io_capacity_max
Submitted: 16 May 0:40 Modified: 16 May 9:19
Reporter: Wiebe Cazemier Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[16 May 0:40] Wiebe Cazemier
Description:
The documentation for 'innodb_flush_sync' or 'innodb_io_capacity_max' don't mention each other, so it's not clear whether 'innodb_flush_sync' also ignores 'innodb_io_capacity_max'.

The source code does seem to mention it in "https://github.com/mysql/mysql-server/blob/e57893fef5b2739c59b8f354d199251514571f61/storag...".

"This should force page cleaners to perform the sync-flush in which case the innodb_max_io_capacity is not respected."

Although it's a big ambiguous, because 'innodb_max_io_capacity' is worded differently, and not sure if it's talking about 'innodb_io_capacity_max'.

How to repeat:
Read:

https://dev.mysql.com/doc/refman/8.0/en/innodb-configuring-io-capacity.html

Suggested fix:
The option 'innodb_flush_sync' should mention whether 'innodb_io_capacity_max' is also ignored.

The 'innodb_io_capacity_max' option should also mention the reverse.
[16 May 9:19] MySQL Verification Team
Hello Wiebe Cazemier,

Thank you for the report and feedback.

regards,
Umesh