Advanced

Performance Modeling and Analysis of a Database Server with Write-Heavy Workload

Dellkrantz, Manfred LU ; Kihl, Maria LU and Robertsson, Anders LU (2012) 2012 European Conference on Service-Oriented and Cloud Computing In [Host publication title missing]
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. Also, we show that window-based admission control outperforms rate-based... (More)
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. Also, we show that window-based admission control outperforms rate-based admission control for these types of systems. (Less)
Please use this url to cite or link to this publication:
author
organization
publishing date
type
Chapter in Book/Report/Conference proceeding
publication status
published
subject
in
[Host publication title missing]
publisher
Springer
conference name
2012 European Conference on Service-Oriented and Cloud Computing
external identifiers
  • Scopus:84866023344
project
Broadband Communications: Modelling and Control of Server Systems
LCCC
language
English
LU publication?
yes
id
33da43dc-61e0-4701-8ca9-1c852d1173ed (old id 2796379)
date added to LUP
2012-06-13 09:07:54
date last changed
2016-10-13 04:42:01
@misc{33da43dc-61e0-4701-8ca9-1c852d1173ed,
  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. Also, we show that window-based admission control outperforms rate-based admission control for these types of systems.},
  author       = {Dellkrantz, Manfred and Kihl, Maria and Robertsson, Anders},
  language     = {eng},
  publisher    = {ARRAY(0x9355948)},
  series       = {[Host publication title missing]},
  title        = {Performance Modeling and Analysis of a Database Server with Write-Heavy Workload},
  year         = {2012},
}