公开(公告)号：US20240362063A1

公开(公告)日：2024-10-31

申请号：US18309576

申请日：2023-04-28

Applicant: Google LLC

Inventor： Yingjie He ,  Yi Ding

IPC: G06F9/48 ,  G06F9/46

CPC classification number: G06F9/4881 ,  G06F9/463

Abstract: A method for performing logging of modifications of a database includes, for each backend process of a plurality of backend processes simultaneously, writing a respective log entry to a write-ahead log buffer, submitting a respective commit request requesting the respective log entry be committed to a write-ahead log, and sleeping the respective backend process. The method also includes writing, using a dedicated writing process and direct asynchronous input/output, one or more of the respective log entries in the write-ahead log buffer to the write-ahead log. The dedicated writing process is different from each respective backend process of the plurality of backend processes. The method also includes updating a log sequence number pointer based on the respective log sequence numbers of the one or more of the respective log entries and waking, based on the log sequence number pointer, one or more of the respective backend processes.