[MDEV-30927] Hint to size InnoDB REDO Log buffer Created: 2023-03-25  Updated: 2023-03-25

Status: Open
Project: MariaDB Server
Component/s: Documentation, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Oli Sennhauser Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Documentation states:



 Comments   
Comment by Oli Sennhauser [ 2023-03-25 ]

In general I miss recommendations about how to size certain MariaDB/InnoDB parameters or what are signs that a specific parameter is not appropriately sized. For example:

Documentation states for innodb_log_buffer_size:

"Increasing this (innodb redo log buffer) means larger transactions can run without needing to perform disk I/O before committing."
Source: https://mariadb.com/kb/en/innodb-system-variables/#innodb_log_buffer_size

Documentation also states for innodb_log_waits:

"Number of times InnoDB was forced to wait for log writes to be flushed due to the log buffer being too small."

Source: https://mariadb.com/kb/en/innodb-status-variables/#innodb_log_waits

So as a conclusion I would like to see a comment under innodb_log_buffer_size similar to: "And indication that InnoDB log buffer size is (sometimes) too small is an increased innodb_log_waits status variables counter"...

Generated at Thu Feb 08 10:19:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.