Re: log sequence number

[vijinarayanan viswanathan]

Thanks for the response,

i have tried this earlier , i got like Log sequence number 84 3836410803.

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 3836410803

Log sequence number 84 3838334638

but my doubt is log sequence number bytes shown here is more than 512MB (512MB is the size of innodb log file, two innodb log file in that group, aslo bin log is enabled 1G size), if Log sequence number was from not the innodb log and bin log, then what the value (bytes) stands for. I guess you can understand what my trying to ask.