Re: log sequence number

[Aftab Khan]

you can find log growth rate, try this

mysql> pager grep sequence;
PAGER set to 'grep sequence'

mysql> show innodb status\G select sleep(60); show innodb status\G
Log sequence number 225 829924781
1 row in set, 1 warning (0.57 sec)

1 row in set (1 min 0.02 sec)

Log sequence number 225 830007918
1 row in set, 1 warning (0.58 sec)

mysql> select ( 830007918-829782115)/1024/1024 AS "MByte/min";
1 row in set (0.00 sec)

mysql> pager
Default pager wasn't set, using stdout.

mysql> select ( 830007918-829782115)/1024/1024 AS "MByte/min";
+------------+
| MByte/min |
+------------+
| 0.21534252 |
+------------+
1 row in set (0.00 sec)