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

  • Manfred Dellkrantz
  • Maria Kihl
  • Anders Robertsson
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7592)


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.


performance modeling service-oriented analysis database server admission control 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Cao, J., Andersson, M., Nyberg, C., Kihl, M.: Web Server Performance Modeling using an M/G/1/K*PS Queue. In: Proceedings of the 10th IEEE International Conference on Telecommunications (2003)Google Scholar
  2. 2.
    Liu, X., Heo, J., Sha, L., Zhu, X.: Adaptive Control of Multi-Tiered Web Application Using Queueing Predictor. In: Proceedings of: 10th IEEE/IFIP Network Operations and Management Symposium, NOMS 2006 (2006)Google Scholar
  3. 3.
    Kihl, M., Robertsson, A., Andersson, M., Wittenmark, B.: Control-theoretic Analysis of Admission Control Mechanisms for Web Server Systems. World Wide Web Journal 11, 93–116 (2008)CrossRefGoogle Scholar
  4. 4.
    Kihl, M., Cedersjö, G., Robertsson, A., Aspernäs, B.: Performance measurements and modeling of database servers. In: Sixth International Workshop on Feedback Control Implementation and Design in Computing Systems and Networks, June 14 (2011)Google Scholar
  5. 5.
    Kamra, A., Misra, V., Nahum, E.M.: Yaksha: A Self-Tuning Controller for Managing the Performance of 3-Tiered Web sites. In: Twelfth IEEE International Workshop on Quality of Service (June 2004)Google Scholar
  6. 6.
    DeWitt, D.J.: The Wisconsin Benchmark: Past, Present, and Future. In: Proceedings of: 9th International Conference on Very Large Data Bases, pp. 8–19. Citeseer (1991)Google Scholar
  7. 7.
    Rago, S., Bohra, A., Ungureanu, C.: Using Eager Strategies to Improve NFS I/O Performance. In: Sixth IEEE International Conference on Networking, Architecture, and Storage (2011)Google Scholar
  8. 8.
    Hsu, W.W., Smith, A.J., Young, H.C.: I/O Reference Behavior of Production Database Workloads and the TPC Benchmarks — An Analysis at the Logical Level. ACM Transactions on Database Systems 26(1), 96–143 (2001)MATHCrossRefGoogle Scholar
  9. 9.
    Kleinrock, L.: Queueing Systems: Theory, vol. I. Wiley Interscience, New York (1975)MATHGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Manfred Dellkrantz
    • 1
  • Maria Kihl
    • 2
  • Anders Robertsson
    • 1
  1. 1.Department of Automatic ControlLund UniversitySweden
  2. 2.Department of Electrical and Information TechnologyLund UniversityLundSweden

Personalised recommendations