Performance measurements and modeling of database servers
(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:
https://lup.lub.lu.se/record/2018672
- author
- Kihl, Maria LU ; Cedersjö, Gustav LU ; Robertsson, Anders LU and Aspernäs, Bertil
- organization
- publishing date
- 2011
- 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)
- conference location
- Karlsruhe, Germany
- conference dates
- 2011-06-14
- project
- Broadband Communications: Modelling and Control of Server Systems
- LCCC
- language
- English
- LU publication?
- yes
- id
- 0dc5fe66-0bb5-4bf4-9336-49f91a215008 (old id 2018672)
- date added to LUP
- 2016-04-04 14:01:41
- date last changed
- 2018-11-21 21:17:50
@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}}, url = {{https://lup.lub.lu.se/search/files/6263091/2018673.pdf}}, year = {{2011}}, }