This study investigates software aging effects caused by the activation of concurrency bugs in a well-known database management system (DBMS), namely MySQL. Experiments with different workloads are performed in order to reproduce the most likely conditions for concurrency bugs activation. Besides the typical aging effects observed in many operational systems (i.e., a gradual degradation over time), results highlight that both available resources and DBMS performance (e.g. service rate, service time, and connection latency) can decrease with time in a hard-to-predict way. We observed that, due to the activation of concurrency bug, the DBMS enters a degraded state in which: i) the estimation of Time-To-Failure (TTF) by means of memory depletion trend analysis is highly inaccurate, and ii) the failure rate does not depend on the instantaneous and/or mean accumulated work. Results suggest that, in such cases, finer-grained indicators and/or different techniques need to be taken into account for properly preventing failures.
On the Aging Effects due to Concurrency Bugs: a Case Study on MySQL / Bovenzi, Antonio; Cotroneo, Domenico; Pietrantuono, Roberto; Russo, Stefano. - (2012), pp. 211-220. (Intervento presentato al convegno 23rd IEEE International Symposium on Software Reliability Engineering (ISSRE 2012) tenutosi a Dallas, Texas (USA) nel 27-30 NOV 2012) [10.1109/ISSRE.2012.50].
On the Aging Effects due to Concurrency Bugs: a Case Study on MySQL
BOVENZI, ANTONIO;COTRONEO, DOMENICO;PIETRANTUONO, ROBERTO;RUSSO, STEFANO
2012
Abstract
This study investigates software aging effects caused by the activation of concurrency bugs in a well-known database management system (DBMS), namely MySQL. Experiments with different workloads are performed in order to reproduce the most likely conditions for concurrency bugs activation. Besides the typical aging effects observed in many operational systems (i.e., a gradual degradation over time), results highlight that both available resources and DBMS performance (e.g. service rate, service time, and connection latency) can decrease with time in a hard-to-predict way. We observed that, due to the activation of concurrency bug, the DBMS enters a degraded state in which: i) the estimation of Time-To-Failure (TTF) by means of memory depletion trend analysis is highly inaccurate, and ii) the failure rate does not depend on the instantaneous and/or mean accumulated work. Results suggest that, in such cases, finer-grained indicators and/or different techniques need to be taken into account for properly preventing failures.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
