时间：2021-07-01 10:21:17 帮助过：2人阅读
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.如果undo log存储在系统表空间，innodb_undo_logs值必须大于32
否则独立存储的话必须大于3。
参考：
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
版权声明：本文为博主原创文章，未经博主允许不得转载。
mysql5.6和mysql5.7分配undo回滚段的区别
标签：