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)

Abstract

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.

Keywords

performance modeling service-oriented analysis database server admission control 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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