An Efficient Protection of Partial Page Update and Buffer Scheme in a Database System Using Non-Volatile Memory

Abstract

In this paper, we present an e cient approach that exploits persistence, fast data access and byte-addressable properties of non-volatile memory (NVM) to protect partial page update and improve transaction performance on ash SSD- based databases. Our scheme is to unify the protention scheme for partial page update (e.g., doublewrite in InnoDB and full-page write in PostgreSQL) and page bu er scheme for read/write operations with several optimizations using NVM to reduce SSD I/Os and related lock contention. In addition, we place redo log bu er on NVM to remove further I/O overhead for better performance. We implemented our scheme in MySQL InnoDB on an NVDIMM server and improved transaction performance 4X and endurance 3X on OLTP workload compared to the existing scheme.