loggsekvensnummer
Loggsekvensnummer, often abbreviated as LSN, is a concept primarily used in database systems, particularly in transactional databases that employ log-based replication or recovery mechanisms. An LSN is a unique, monotonically increasing identifier assigned to each record in a transaction log. The transaction log, also known as a write-ahead log (WAL), records all changes made to the database. Each log record represents an atomic unit of work, such as an insert, update, or delete operation.
The LSN serves as a precise marker for the position within the transaction log. This allows database
The monotonically increasing nature of LSNs is fundamental. It guarantees that a higher LSN always represents