Skip to main content
SpringerLink
Log in
Book cover

International Conference: Beyond Databases, Architectures and Structures

BDAS 2015: Beyond Databases, Architectures and Structures pp 180–189Cite as

Efficient Multidisk Database Storage Configuration

  • Conference paper

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 521))

Abstract

Simple database storage configuration includes block device and filesystem. In advanced multi-disk database storage configuration also disk manager is required. Article presents multi-disk storage configuration impact on relational database performance. Research results include various local multi-disk storage space configuration scenarios for database cluster in modern database management systems with popular disk managers like software RAID and standard or thin provisioned logical volume equipped with disk allocation policy. The research conclusions facilitate the local storage space configuration for efficient transaction processing in relational databases.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Anderson, E., Swaminathan, R., Veitch, A., Alvarez, G., Wilkes, J.: Selecting raid levels for disk arrays. In: Proceedings of the 1st USENIX Conference on File and Storage Technologies (2002)

    Google Scholar 

  2. Axboe, J.: Linux block io present and future. In: Proceedings of Ottawa Linux Symposium, pp. 51–61 (2004)

    Google Scholar 

  3. Bryant, R., Forester, R., Hawkes, J.: Filesystem performance and scalability in linux 2.4.17. In: Proceeding of the FREENIX TRACK, pp. 259–274 (2002)

    Google Scholar 

  4. Hsu, W.W., Smith, A.J., Young, H.C.: I/o reference behavior of production database workloads and the tpc benchmarks an analysis at the logical level. ACM Transactions on Database Systems 26, 96–143 (2001)

    Article  MATH  Google Scholar 

  5. Percona Benchmark: Benchmanrks For Percona Server, 2015, http://www.percona.com/software/percona-server/benchmarks

  6. Llanos, D.R.: Tpcc-uva: An open-source tpc-c implementation for global performance measurement of computer systems. ACM SIGMOD RECORD 35, 6–15 (2006)

    Article  Google Scholar 

  7. Rodeh, O., Bacik, J., Mason, C.: Btrfs: The linux b-tree filesystem. ACM Transactions on Storage 9, 1–32 (2013)

    Article  Google Scholar 

  8. Salomie, T.I., Subasu, I.E., Giceva, J.: Database engines on multicores, why parallelize when you can distribute? In: Proceedings of the EUROSYS Conference, pp. 17–30 (2011)

    Google Scholar 

  9. TPC: Transaction Performance Council (2015), http://www.tpc.org

Download references

Author information

Authors and Affiliations

  1. Institute of Information Technology, Technical University of Lodz, Wolczaska 215, 90-924, Lodz, Poland

    Mateusz Smolinski

Authors
  1. Mateusz Smolinski
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Mateusz Smolinski .

Editor information

Editors and Affiliations

  1. Silesian University of Technology, Gliwice, Poland

    Stanisław Kozielski

  2. Silesian University of Technology, Gliwice, Poland

    Dariusz Mrozek

  3. Silesian University of Technology, Gliwice, Poland

    Paweł Kasprowski

  4. Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Silesian University of Technology, Gliwice,, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Smolinski, M. (2015). Efficient Multidisk Database Storage Configuration. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_16

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-18422-7_16

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-18421-0

  • Online ISBN: 978-3-319-18422-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation