Influence of the storage space snapshots on transaction processing in relational database

Mateusz Smoliński

Abstract


This paper presents influence of storage snapshots in various relational database storage space configuration on performance in database transaction processing. The obtained results for single and multi disk storage space configurations in popular database management systems like PostgreSQL and MariaDB allow to choose storage space configuration for relational database, which support snapshotting and minimize performance drop in database transaction processing.

Keywords


transaction processing performance; snapshots in relational database storage space

Full Text:

PDF (Polski)

References


Bernstein P. A., Newcomer E.: Principles of Transaction Processing. 2nd Edition. Morgan Kaufmann, 2009.

Bryant R., Forester R., Hawkes J.: Filesystem Performance and Scalability in Linux 2.4.17 Usenix. Proceeding of the Freenix Track, 2002, s. 259÷274.

Llanos D. R.: TPCC-UVa: An Open-Source TPC-C Implementation for Global Performance Measurement of Computer Systems. Sigmod Record,Vol. 35, Issue 4, 2006, s. 6÷15.

Rodeh O., Bacik J., Mason C.: BTRFS: The Linux B-Tree Filesystem. ACM Transactions on Storage, Vol. 9, Issue 3, 2013, s. 1÷32.

Sobell M. G.: Fedora and RedHat Enterprise Linux. 6th Edition. Prentice Hall, 2011.

Tanenbaum A. S., Bos H.: Modern Operating Systems. 4th Edition. Prentice Hall, 2014.

Teigland D., Mauelshagen H.: Volume Managers in Linux. Proceedings of the Usenix Conference, 2001, s. 185÷198.

Vossen G., Weikum G.: Transactional Information Systems. Academic Press, 2002.




DOI: http://dx.doi.org/10.21936/si2015_v36.n1.729