Stress Testing of Transactional Database Systems

Authors

  • Jorge Augusto Meira University of Luxembourg http://wwwen.uni.lu/snt/people/jorge_augusto_meira
  • Eduardo Cunha de Almeida Universidade Federal do Paraná
  • Gerson Sunyé INRIA - University of Nantes
  • Yves Le Traon University of Luxembourg
  • Patrick Valduriez INRIA e LIRMM - University of Montpellier

DOI:

https://doi.org/10.5753/jidm.2013.1498

Keywords:

Stress Testing, Database, Testing Methodology, Transaction

Abstract

Transactional database management systems (DBMS) have been successful at supporting traditionaltransaction processing workloads. However, web-based applications that tend to generate huge numbers of concurrentbusiness operations are pushing DBMS performance over their limits, thus threatening overall system availability. Then,a crucial question is how to test DBMS performance under heavy workload conditions. Answering this question requiresa testing methodology to set up non-biased conditions for pushing a particular DBMS over its normal performancelimits (i.e., to stress it). In this article, we present a stress testing methodology for DBMS to search for defects insupporting very heavy workloads. Our methodology leverages distributed testing techniques and takes into account thevarious biases that may a?ect the test results. It progressively increases the workload along with several tuning stepsup to a stress condition. We validate our methodology with empirical studies on two popular DBMS (one proprietary,one open-source) and detail the defects that have been found.

Downloads

Download data is not yet available.

Downloads

Published

2013-09-25

How to Cite

Meira, J. A., Almeida, E. C. de, Sunyé, G., Le Traon, Y., & Valduriez, P. (2013). Stress Testing of Transactional Database Systems. Journal of Information and Data Management, 4(3), 279. https://doi.org/10.5753/jidm.2013.1498

Issue

Section

SBBD Articles