Performance measurements and modeling of database servers
Författare
Summary, in English
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.
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.
Avdelning/ar
Publiceringsår
2011
Språk
Engelska
Fulltext
- Available as PDF - 664 kB
- Download statistics
Dokumenttyp
Konferensbidrag
Ämne
- Control Engineering
- Electrical Engineering, Electronic Engineering, Information Engineering
Conference name
Sixth International Workshop on Feedback Control Implementation and Design in Computing Systems and Networks (FeBID 2011)
Conference date
2011-06-14
Conference place
Karlsruhe, Germany
Status
Published
Projekt
- Broadband Communications: Modelling and Control of Server Systems
- LCCC
Forskningsgrupp
- Broadband Communication
- LCCC