The browser you are using is not supported by this website. All versions of Internet Explorer are no longer supported, either by us or Microsoft (read more here: https://www.microsoft.com/en-us/microsoft-365/windows/end-of-ie-support).

Please use a modern browser to fully experience our website, such as the newest versions of Edge, Chrome, Firefox or Safari etc.

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

På svenska

Author

Summary, in English

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.

Publishing year

2012

Language

English

Publication/Series

[Host publication title missing]

Document type

Conference paper

Publisher

Springer

Topic

  • Electrical Engineering, Electronic Engineering, Information Engineering
  • Control Engineering

Conference name

2012 European Conference on Service-Oriented and Cloud Computing

Conference date

2012-09-19

Conference place

Bertinoro, Italy

Status

Published

Project

  • Broadband Communications: Modelling and Control of Server Systems
  • LCCC

Research group

  • Broadband Communication
  • LCCC