NVM aware MariaDB database system

2015 IEEE Non-Volatile Memory System and Applications Symposium (NVMSA) Pub Date : 2015-10-29 DOI:10.1109/NVMSA.2015.7304362

Jan Lindström, Dhananjoy Das, Torben Mathiasen, D. Arteaga, Nisha Talagala

{"title":"NVM aware MariaDB database system","authors":"Jan Lindström, Dhananjoy Das, Torben Mathiasen, D. Arteaga, Nisha Talagala","doi":"10.1109/NVMSA.2015.7304362","DOIUrl":null,"url":null,"abstract":"MariaDB is a community-developed fork of the MySQL relational database management system and originally designed and implemented to use traditional spinning disk architecture. Now that devices with Non-Volatile memory (NVM) technologies are available, MariaDB addresses this challenge by adding support for NVM devices and introduces NVM Compression method. NVM Compression is a novel hybrid technique that combines application level compression with flash awareness for optimal performance and storage efficiency. Utilizing new interface primitives exported by Flash Translation Layers (FTLs), we leverage the garbage collection available in flash devices to optimize the capacity management required by compression systems. We implement NVM Compression in the popular MariaDB database and use variants of commonly available POSIX file system interfaces to provide the extended FTL capabilities to the user space application. The experimental results show that the hybrid approach of NVM Compression can improve compression performance by 2-7x, deliver compression performance for flash devices that is within 5% of uncompressed performance, improves storage efficiency by 19% over legacy Row-Compression, reduce data writes by up to 4x when combined with other flash aware techniques such as Atomic Writes, and deliver further advantages in power efficiency and CPU utilization.","PeriodicalId":353528,"journal":{"name":"2015 IEEE Non-Volatile Memory System and Applications Symposium (NVMSA)","volume":"37 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2015-10-29","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"8","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2015 IEEE Non-Volatile Memory System and Applications Symposium (NVMSA)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/NVMSA.2015.7304362","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 8

Abstract

MariaDB is a community-developed fork of the MySQL relational database management system and originally designed and implemented to use traditional spinning disk architecture. Now that devices with Non-Volatile memory (NVM) technologies are available, MariaDB addresses this challenge by adding support for NVM devices and introduces NVM Compression method. NVM Compression is a novel hybrid technique that combines application level compression with flash awareness for optimal performance and storage efficiency. Utilizing new interface primitives exported by Flash Translation Layers (FTLs), we leverage the garbage collection available in flash devices to optimize the capacity management required by compression systems. We implement NVM Compression in the popular MariaDB database and use variants of commonly available POSIX file system interfaces to provide the extended FTL capabilities to the user space application. The experimental results show that the hybrid approach of NVM Compression can improve compression performance by 2-7x, deliver compression performance for flash devices that is within 5% of uncompressed performance, improves storage efficiency by 19% over legacy Row-Compression, reduce data writes by up to 4x when combined with other flash aware techniques such as Atomic Writes, and deliver further advantages in power efficiency and CPU utilization.

查看原文本刊更多论文

支持NVM的MariaDB数据库系统

MariaDB是MySQL关系数据库管理系统的一个社区开发的分支，最初设计和实现使用传统的旋转磁盘架构。现在，使用非易失性内存(NVM)技术的设备已经可用，MariaDB通过增加对NVM设备的支持并引入NVM压缩方法来解决这一挑战。NVM压缩是一种新颖的混合技术，它将应用级压缩与闪存感知相结合，以获得最佳性能和存储效率。利用Flash转换层(ftl)导出的新接口原语，我们利用Flash设备中可用的垃圾收集来优化压缩系统所需的容量管理。我们在流行的MariaDB数据库中实现了NVM压缩，并使用常用的POSIX文件系统接口的变体来为用户空间应用程序提供扩展的FTL功能。实验结果表明，NVM压缩的混合方法可以将压缩性能提高2-7倍，将闪存设备的压缩性能提高到未压缩性能的5%以内，比传统的行压缩提高19%的存储效率，当与其他闪存感知技术(如Atomic writes)结合使用时，将数据写入减少多达4倍，并在电源效率和CPU利用率方面提供进一步的优势。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

2015 IEEE Non-Volatile Memory System and Applications Symposium (NVMSA)

自引率

0.00%

发文量