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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
Axboe, J.: Linux block io present and future. In: Proceedings of Ottawa Linux Symposium, pp. 51–61 (2004)
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)
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)
Percona Benchmark: Benchmanrks For Percona Server, 2015, http://www.percona.com/software/percona-server/benchmarks
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)
Rodeh, O., Bacik, J., Mason, C.: Btrfs: The linux b-tree filesystem. ACM Transactions on Storage 9, 1–32 (2013)
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)
TPC: Transaction Performance Council (2015), http://www.tpc.org
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)