Bug #78105 The effect of low innodb_undo_logs value is not clear
| Submitted: | 17 Aug 2015 13:05 | Modified: | 7 Jul 2016 19:51 |
|---|---|---|---|
| Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | doc, innodb_available_undo_logs, innodb_undo_logs | ||
[17 Aug 2015 13:05]
Laurynas Biveinis
[7 Jul 2016 19:51]
Daniel Price
Posted by developer: When innodb_undo_logs is set to 32 or less, InnoDB assigns one undo log to the system tablespace and 32 to the temporary tablespace (ibtmp1). More specifically, as provided by the Developer of this feature: * If value = 1, then 1 redo (or normal) rollback segment is created and 32 non-redo rollback segments are created. * If value = 1 - 32, then 1 redo (or normal) rollback segment is created and 32 non-redo rollback segments are created. * If value > 32, then "value minus 32" redo rollback segments are created and 32 non-redo rollback segments are created. The following documentation has been updated: http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespace.html http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_undo_logs http://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Innodb_availab... Changes should appear online soon. Thank you for the bug report.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.037 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.