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"...
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"...