skip to main content
10.1145/1565694.1565697acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Evaluating and repairing write performance on flash devices

Published:28 June 2009Publication History

ABSTRACT

In the last few years NAND flash storage has become more and more popular as price per GB and capacity both improve at exponential rates. Flash memory offers significant benefits compared to magnetic hard disk drives (HDDs) and DBMSs are highly likely to use flash as a general storage backend, either alone or in heterogeneous storage solutions with HDDs. Flash devices, however, respond quite differently than HDDs for common access patterns, and recent research shows a strong asymmetry between read and write performance. Moreover, flash storage devices behave unpredictably, showing a high dependence on previous IO history and usage patterns.

In this paper we investigate how a DBMS can overcome these issues to take full advantage of flash memory as persistent storage. We propose new a flash aware data layout --- append and pack --- which stabilizes device performance by eliminating random writes. We assess the impact of append and pack on OLTP workload performance using both an analytical model and micro-benchmarks, and our results suggest that significant improvements can be achieved for real workloads.

References

  1. The FusionIO drive. Technical specifications available at: http://www.fusionio.com/PDFs/Fusion%20Specsheet.pdf.Google ScholarGoogle Scholar
  2. The LogFS file system. Available at: http://logfs.org/logfs/.Google ScholarGoogle Scholar
  3. Transaction Processing Performance Council (TPC). TPC Benchmark C: Standard Specification. Available online at: http://www.tpc.org/tpcc/spec/tpcc_current.pdf.Google ScholarGoogle Scholar
  4. L. Bouganim, B. T. Jónsson, and P. Bonnet. uFLIP: Understanding Flash IO Patterns. In CIDR, 2009.Google ScholarGoogle Scholar
  5. H. Dai, M. Neufeld, and R. Han. ELF: an efficient log-structured flash file system for micro sensor nodes. In SenSys, pages 176--187, 2004. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. A. Kawaguchi, S. Nishioka, and H. Motoda. A flash-memory based file system. In In Proceedings of the Winter 1995 USENIX Technical Conference, pages 155--164, 1995. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. G.-J. Kim, S.-C. Baek, H.-S. Lee, H.-D. Lee, and M. J. Joe. LGeDBMS: a small DBMS for embedded system with flash memory. In VLDB '06: Proceedings of the 32nd international conference on Very large data bases, pages 1255--1258. VLDB Endowment, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. S.-W. Lee and B. Moon. Design of flash-based DBMS: an in-page logging approach. In SIGMOD Conference, pages 55--66, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. S.-W. Lee, B. Moon, C. Park, J.-M. Kim, and S.-W. Kim. A case for flash memory SSD in enterprise database applications. In SIGMOD Conference, pages 1075--1086, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. M. Rosenblum and J. K. Ousterhout. The Design and Implementation of a Log-Structured File-System. ACM Trans. Comput. Syst., 10(1):26--52, 1992. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. D. Woodhouse. JFFS: The Journalling Flash File System. Ottawa Linux Symposium, 2001, available at: http://sources.redhat.com/jffs2/jffs2.pdf.Google ScholarGoogle Scholar

Index Terms

  1. Evaluating and repairing write performance on flash devices

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in
          • Published in

            cover image ACM Conferences
            DaMoN '09: Proceedings of the Fifth International Workshop on Data Management on New Hardware
            June 2009
            63 pages
            ISBN:9781605587011
            DOI:10.1145/1565694

            Copyright © 2009 ACM

            Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 28 June 2009

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • research-article

            Acceptance Rates

            Overall Acceptance Rate80of102submissions,78%

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader