设为首页 加入收藏

TOP

mysql5.6和mysql5.7分配undo回滚段的区别
2015-11-21 01:35:04 来源: 作者: 【 】 浏览:0
Tags:mysql5.6 mysql5.7分配 undo 段的 区别

1、mysql5.7中分为2类:临时表空间回滚段和普通回滚段。

2、mysql5.6中没有区分。

As of MySQL 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.

如果undo log存储在系统表空间,innodb_undo_logs值必须大于32

否则独立存储的话必须大于3。

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mysql备份与还原 下一篇Mysql&IFNULL,NULLIF,ISNULL

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: