Method and system for writing database into SSD

Abstract

The invention discloses a method and system for writing a database into an SSD. The method includes the following steps that (1) if write-in of a dirty page can not be completed in an I / O, namely, write operations have no atomicity, the database notifies the SSD that the dirty page will be written in, the SSD allocates storage pages, simultaneously allocates tentative address mapping tables and records mapping relations; (2) when an exception occurs, FTL address mapping tables are updated according to the states of the tentative address mapping tables, and the write operations to the SSD are completed.

Description

technical field [0001] The invention belongs to the field of computer solid state disk (SSD) reading and writing, and in particular relates to a method and system for writing a database into an SSD. Background technique [0002] When a record (Row) in the database is updated, generally its page (Page) in the buffer pool (BP, Buffer Pool) is updated first, and this update is recorded in the log (Log file). The Page is marked as Dirty. At the appropriate time (not enough BP, idle system, etc.), these dirty pages will be written to disk. During the Flush process of a Dirty Page (for example, 16K), the operating system may divide the write operation into multiple write operations, and a failure (power failure, system crash, etc.) occurs during the execution of these multiple write operations. ), and finally only 8K of the 16K data is written to the disk. This phenomenon is called partial write failure (partial page writes, torn pages, fractured writes, etc.). Once partial pag...

AI Technical Summary

Problems solved by technology

[0013] What the present invention is to solve is the problem of partial write failure of data in the process of database writing, thereby proposing a method and system for writing database into SSD

Images