innodb log file size 配置估算以及修改

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

root@localhost:(none) 06:22:17>pager grep seq
PAGER set to 'grep seq'

root@localhost:(none) 06:30:33>show engine innodb status\G select sleep(60); show engine innodb status\G
Log sequence number 29532909727
1 row in set (0.00 sec)
1 row in set (1 min 0.00 sec)
Log sequence number 29641344616
1 row in set (0.01 sec)

root@localhost:(none) 06:32:03>nopager
PAGER set to stdout

root@localhost:(none) 06:32:17>select (29641344616-29532909727) 60/1024/1024
-> ;
+----------------------------------------+
| (29641344616-29532909727) 60/1024/1024 |
+----------------------------------------+
| 6204.69411850 |
+----------------------------------------+
1 row in set (0.00 sec)