what's meaning of last_lsn?

liyx,

This pages has related information:

http://www.mysqlperformanceblog.com/2012/02/17/the-relations hip-between-innodb-log-checkpointing-and-dirty-buffer-pool-p ages/
http://www.percona.com/files/percona-live/justin-innodb-inte rnals.pdf

In short, LSN (log sequence number) are offsets from the redo logs - so simply put, last_lsn is the offset where the last transaction written to the redo logs was written. to_lsn on the other hand, should be paired to a from_lsn, mostly useful on incremental backups, etc.

Announcement