走进官方手册系列 --- 关于LSN的研究（更新中）

最新推荐文章于 2025-08-12 10:33:48 发布

亮总说数

最新推荐文章于 2025-08-12 10:33:48 发布

阅读量803

点赞数

分类专栏：走进官方手册文章标签： mysql

走进官方手册专栏收录该内容

3 篇文章

订阅专栏

本文介绍了MySQL中InnoDB存储引擎使用的日志序列号（LSN）概念及其重要性。LSN是一种用于标识时间点的递增数值，与重做日志记录中的操作相对应，无论这些操作是否处于事务边界内。它被InnoDB内部用于崩溃恢复及缓冲池管理，并且随着日志文件大小限制从4GB增加到512GB，在MySQL 5.6.3版本中，LSN也从4字节扩展到了8字节。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

https://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_lsn

https://www.devarticles.com/c/a/MySQL/How-Logs-Work-On-MySQL-With-InnoDB-Tables/

http://happytest.blog.51cto.com/324097/62848

http://blog.youkuaiyun.com/yunhua_lee/article/details/6567869

LSN
Acronym for “log sequence number”. This arbitrary, ever-increasing value represents a point in time corresponding to operations recorded in the redo log. (This point in time is regardless of transaction boundaries; it can fall in the middle of one or more transactions.) It is used internally by InnoDB during crash recovery and for managing the buffer pool.

Prior to MySQL 5.6.3, the LSN was a 4-byte unsigned integer. The LSN became an 8-byte unsigned integer in MySQL 5.6.3 when the redo log file size limit increased from 4GB to 512GB, as additional bytes were required to store extra size information. Applications built on MySQL 5.6.3 or later that use LSN values should use 64-bit rather than 32-bit variables to store and compare LSN values.

In the MySQL Enterprise Backup product, you can specify an LSN to represent the point in time from which to take an incremental backup. The relevant LSN is displayed by the output of the mysqlbackup command. Once you have the LSN corresponding to the time of a full backup, you can specify that value to take a subsequent incremental backup, whose output contains another LSN for the next incremental backup.

See Also buffer pool, crash recovery, incremental backup, MySQL Enterprise Backup, redo log, transaction.

何登成博士画的一张log block的结构图