Performance Modeling and Analysis of a Database Server with Write-Heavy Workload
(2012) 2012 European Conference on Service-Oriented and Cloud Computing- 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:
https://lup.lub.lu.se/record/2796379
- author
- Dellkrantz, Manfred LU ; Kihl, Maria LU and Robertsson, Anders LU
- organization
- publishing date
- 2012
- type
- Chapter in Book/Report/Conference proceeding
- publication status
- published
- subject
- host publication
- [Host publication title missing]
- publisher
- Springer
- conference name
- 2012 European Conference on Service-Oriented and Cloud Computing
- conference location
- Bertinoro, Italy
- conference dates
- 2012-09-19
- 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
- 2016-04-04 10:46:57
- date last changed
- 2022-01-29 20:47:48
@inproceedings{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}}, booktitle = {{[Host publication title missing]}}, language = {{eng}}, publisher = {{Springer}}, title = {{Performance Modeling and Analysis of a Database Server with Write-Heavy Workload}}, url = {{https://lup.lub.lu.se/search/files/5619890/3242711.pdf}}, year = {{2012}}, }