logginginflash-baseddatabasesystems

logginginflash-baseddatabasesystems内容摘要：

• Future work – Recovery processing – Experiments of PTLog 17 SSD • SSD = Flash memory + FTL（ Flash Translation Layer） 18 To be used in…… • Accessing data in secondary storage is the main source of bottlenecks in database processing. • Database table, index, log, temporary table and rollback segment could be created on physically separate storage devices .(SSD+ HDD) • Log records are always appended to the end of log. 19 TPCB benchmark performance B. Moon, C. Park, S. W. Lee. A Case for Flash Memory SSD in Enterprise Database Applications. SIGMOD 2020. 21 We used TPCB to stresstest the log storage part of the mercial database server. Due to the group mit mechanism, the average size of a single log write was slightly different between the two storage media. TPCB benchmark performance B. Moon, C. Park, S. W. Lee. A Case for Flash Memory SSD in Enterprise Database Applications. SIGMOD 2020. 22 In the case of SSD, the bottleneck in transaction throughput is the processing speed of CPU , while it was not in the case of disk. Outline • Characteristics of flash memory • Log records in different kinds of Flash devices – In Flash chips IPL – In SSD – In USB – FlashLogging • Future work – Recovery processing – Experiments of PTLog 23 USB flash memory advantages • USB ports are widely available. • USB bus bandwidth is good for logging. • The hotplug capability allows easy replacement of drives. • The price of an individual drive is low. Shimin Chen. FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance. SIGMOD39。 09. 24 Flash devices and disk performance 25 Shimin Chen. FlashLo。