mysql> pager grep sequence PAGER set to 'grep sequence' mysql> show engine innodb status\G select sleep(60); show engine innodb status\G Log sequence number 84 1028230 1 row in set (0.06 sec) 1 row in set (1 min 0.00 sec) Log sequence number 84 2028230 1 row in set (0.05 sec)
The log sequence number is the total number of bytes written in the transaction log. Therefore the delta should indicate the growth rate per second:
mysql> select (2028230 - 1028230) / 1024 / 1024 as MB_per_min; +------------+ | MB_per_min | +------------+ | 0.95367432 | +------------+
In an hour, the growth will therefore be 57MB, rounded to 64MB. Since we have two logfiles by default, they can be 32MB each. Sounds small, but in reality that is the optimum size for this particular server. Baron mentions a pretty busy server which only requires two logfiles each being 64MB!
No comments:
Post a Comment