Abstract
Optimizing configuration parameters is time-consuming and skills-intensive. This paper proposes a generic approach to automating this task. By generic, we mean that the approach is relatively independent of the target system for which the optimization is done. Our approach uses online adjustment of configuration parameters to discover the system’s performance characteristics. Doing so creates two challenges: (1) handling interdependencies between configuration parameters and (2) minimizing the deleterious effects on production workload while the optimization is underway. Our approach addresses (1) by including in the architecture a rule-based component that handles interdependencies between configuration parameters. For (2), we use a feedback mechanism for online optimization that searches the parameter space in a way that generally avoids poor performance at intermediate steps. Our studies of a DB2 Universal Database Server under an e-commerce workload indicate that our approach can be effective in practice.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
IBM: Autonomic computing: IBM’s perspective on the state of information technology (2001), available at http://www.research.ibm.com/autonomic/
Franklin, G.F., Powell, J.D., Emani-Naeini, A.: Feedback Control of Dynamic Systems, 3rd edn. Addison-Wesley, Reading (1994)
Hollot, C.V., Misra, V., Towsley, D., Gong, W.B.: On designing improved controllers for AQM routers supporting TCP flows. In: INFOCOM (2001)
Lu, C., Stankovic, J.A., Abdelzaher, T.F., Tao, G., Son, S., Marley, M.: Performance specifications and metrics for adaptive real time systems. In: Proceedings 21st IEEE Real Time Systems Symposium, November 2000, pp. 13–24 (2000)
Menasce, D., Barbara, D., Dodge, R.: Preserving QoS of e-commerce sites through self-tuning: A performance model approach. In: Proceedings of 2001 ACM Conference on E-commerce (2001)
Liu, Z., Squillante, M.S., Wolf, J.L.: On maximizing service-level-agreement profits. In: Proceedings of the ACM Conference on Electronic Commerce (2001)
Diao, Y., Hellerstein, J.L., Parekh, S.: Optimizing quality of service using fuzzy control. In: Proceedings of Distributed Systems Operations and Management (2002)
Raghavachari, M., Reimer, D., Johnson, R.: The deployer’s problem: Configuring application servers for performance and reliability. In: Proceedings of the International Conference on Software Engineering, Portland, OR (2003)
Diao, Y., Eskesen, F., Froehlich, S., Hellerstein, J.L., Keller, A., Spainhower, L., Surendra, M.: Generic on-line discovery of quantitative models for service level management. In: Proceedings of IEEE/IFIP Symposium on Integrated Network Management (2003)
Weikum, G., Moenkeberg, A., Hasse, C., Zabback, P.: Self-tuning database technology and information services: from wishful thinking to viable engineering. In: International Conference on Very Large Data Bases (2002)
Lohman, G.M., Lightstone, S.S.: Smart: Making db2 (more) autonomic. In: Proceedings of the 28th International Conference on Very Large Data Bases, Hong Kong, China (2002)
Rao, J., Zhang, C., Lohman, G.M., Megiddo, N.: Automating physical database design in a parallel database. In: SIGMOD (2002)
Common Information Model (CIM) Core Model, Version 2.4, white paper (August 2000), http://www.dmtf.org/var/release/Whitepapers/DSP0111.pdf
Bigus, J.P., Schlosnagle, D.A., Pilgrim, J.R., Mills III, W.N., Diao, Y.: ABLE: A toolkit for building multiagent autonomic systems. IBM Systems Journal 41(3) (2002)
Luenberger, D.G.: Linear and nonlinear programming. Addison-Wesley, Reading (1984)
Liu, X., Sha, L., Diao, Y., Froehlich, S., Hellerstein, J.L., Parekh, S.: Online response time optimization of apache web server. In: Proceedings of the 11th International Workshop on Quality of Service, pp. 461–478 (2003)
Nelder, J.A., Mead, R.: A simplex method for function minimizatioin. Computer Journal (1965)
Walters, F.H., Parker, J.L.R., Morgan, S.L., Deming, S.N.: Sequential Simplex Optimization: A technique for improving quality and productivity in research, development, and manufacturing. CRC Press, Boca Raton (1991)
Brooks, C.H.: An introduction to amoeba, available at http://nexus.cs.usfca.edu/~brooks/papers/amoeba.pdf
Kephart, J.O., Das, R., MacKie-Mason, J.K.: Two-sided learning in an agent economy for information bundles. In: AmEC IJCAI (1999)
Smith, W.D.: TPC-W: Benchmarking an ecommerce solution, in http://www.tpc.org/tpcw
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Diao, Y., Eskesen, F., Froehlich, S., Hellerstein, J.L., Spainhower, L.F., Surendra, M. (2003). Generic Online Optimization of Multiple Configuration Parameters with Application to a Database Server. In: Brunner, M., Keller, A. (eds) Self-Managing Distributed Systems. DSOM 2003. Lecture Notes in Computer Science, vol 2867. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39671-0_2
Download citation
DOI: https://doi.org/10.1007/978-3-540-39671-0_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20314-8
Online ISBN: 978-3-540-39671-0
eBook Packages: Springer Book Archive