Advanced

Performance measurements and modeling of database servers

Kihl, Maria LU ; Cedersjö, Gustav LU ; Robertsson, Anders LU and Aspernäs, Bertil (2011) Sixth International Workshop on Feedback Control Implementation and Design in Computing Systems and Networks (FeBID 2011)
Abstract
In this paper we present some experiments on the MySQL

database server. The objective of the experiments was to

investigate the high load dynamics for varying relation sizes and

requests. We show that the dynamics for SELECT (read) requests

can be modeled as a modified M/M/1 system, whereas, the

dynamics for UPDATE (write) are completely different. Our

results can be used for designing control and optimization

algorithms for database servers.
Please use this url to cite or link to this publication:
author
organization
publishing date
type
Contribution to conference
publication status
published
subject
conference name
Sixth International Workshop on Feedback Control Implementation and Design in Computing Systems and Networks (FeBID 2011)
project
LCCC
Broadband Communications: Modelling and Control of Server Systems
language
English
LU publication?
yes
id
0dc5fe66-0bb5-4bf4-9336-49f91a215008 (old id 2018672)
date added to LUP
2011-07-04 12:53:40
date last changed
2016-04-16 11:59:55
@misc{0dc5fe66-0bb5-4bf4-9336-49f91a215008,
  abstract     = {In this paper we present some experiments on the MySQL<br/><br>
database server. The objective of the experiments was to<br/><br>
investigate the high load dynamics for varying relation sizes and<br/><br>
requests. We show that the dynamics for SELECT (read) requests<br/><br>
can be modeled as a modified M/M/1 system, whereas, the<br/><br>
dynamics for UPDATE (write) are completely different. Our<br/><br>
results can be used for designing control and optimization<br/><br>
algorithms for database servers.},
  author       = {Kihl, Maria and Cedersjö, Gustav and Robertsson, Anders and Aspernäs, Bertil},
  language     = {eng},
  title        = {Performance measurements and modeling of database servers},
  year         = {2011},
}