Performance modeling and analysis of a database server with write-heavy workload

Authors:
Manfred Dellkrantz;Maria Kihl;Anders Robertsson
Affiliations:
Department of Automatic Control, Lund University, Sweden;Department of Electrical and Information Technology, Lund University, Lund, Sweden;Department of Automatic Control, Lund University, Sweden
Venue:
ESOCC'12 Proceedings of the First European conference on Service-Oriented and Cloud Computing
Year:
2012

Citing 4
Cited 0

I/O reference behavior of production database workloads and the TPC benchmarks—an analysis at the logical level

ACM Transactions on Database Systems (TODS)
Theory, Volume 1, Queueing Systems

Theory, Volume 1, Queueing Systems
Control-theoretic Analysis of Admission Control Mechanisms for Web Server Systems

World Wide Web
Using Eager Strategies to Improve NFS I/O Performance

NAS '11 Proceedings of the 2011 IEEE Sixth International Conference on Networking, Architecture, and Storage

Quantified Score

Hi-index	0.00

Visualization

Abstract

Resource-optimization of the infrastructure for service oriented applications require accurate performance models. In this paper we investigate the performance dynamics of a MySQL/InnoDB database server with write-heavy workload. The main objective of our investigation was to understand the system dynamics due to the buffering of disk operations that occurs in database servers with write-heavy workload. In the paper, we characterize the traffic and its periodic anomalies caused by flushing of the buffer. Further, we present a performance model for the response time of the requests and show how this model can be configured to fit with actual database measurements.