What is the difference between allocating undo rollback segments between mysql5.6 and mysql5.7? mysql5.6mysql5.7
1. mysql5.7 is divided into two types: Temporary tablespace rollback segments and common rollback segments.
2. mysql5.6 is not distinguished.
AsMySQL 5.7.2, 32 undo logs are reserved for use by temporary tables and are hosted in the temporary table tablespace (ibtmp1
). To allocate additional undo logs for data-modifying transactions that generate undo records,innodb_undo_logs
Must be set to a value greater than 32 if undo logs are stored in the system tablespace only. If you have configured separate undo tablespaces,innodb_undo_logs
Must be set to a value greater than 33 to allocate additional undo logs for data-modifying transactions. Each undo log can host up to a maximum of 1024 transactions.
If the undo log is stored in the system tablespace, The innodb_undo_logs value must be greater than 32
Otherwise, the value of independent storage must be greater than 3.
Refer:
Http://www.tuicool.com/articles/IzQNRrz
Http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_undo_logs
Http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_undo_logs
Http://bbs.aliyun.com/read/244045.html? Spm = 5176.7189909.0.0.AB00as
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.