Webbläsaren som du använder stöds inte av denna webbplats. Alla versioner av Internet Explorer stöds inte längre, av oss eller Microsoft (läs mer här: * https://www.microsoft.com/en-us/microsoft-365/windows/end-of-ie-support).

Var god och använd en modern webbläsare för att ta del av denna webbplats, som t.ex. nyaste versioner av Edge, Chrome, Firefox eller Safari osv.

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

In English

Författare

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.

Publiceringsår

2012

Språk

Engelska

Publikation/Tidskrift/Serie

[Host publication title missing]

Dokumenttyp

Konferensbidrag

Förlag

Springer

Ämne

  • 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

Projekt

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

Forskningsgrupp

  • Broadband Communication
  • LCCC