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