First Advisor
Kuhn, Darl
Second Advisor
Ina, Donald J.
Third Advisor
Birkenheuer, Nancy
College
College for Professional Studies
Degree Name
MS Software and Information Systems
School
School of Computer & Information Science
Document Type
Thesis - Open Access
Number of Pages
164 pages
Abstract
Manual physical configuration and tuning of database servers, is a complicated task requiring a high level of expertise. Database administrators must consider numerous possibilities, to determine a candidate configuration for implementation. In recent times database vendors have responded to this problem, providing solutions which can automatically configure and tune their products. Poor configuration choices, resulting in performance degradation commonplace in manual configurations, have been significantly reduced in these solutions. However, no such solution exists for MySQL Community Server. This thesis, proposes a novel framework for automatically tuning a MySQL Community Server. A first iteration of the framework has been built and is presented in this paper together with its performance measurements.
Date of Award
Summer 2010
Location (Creation)
Colorado (state); Denver (county); Denver (inhabited place)
Copyright
© Kevin Spillane
Rights Statement
All content in this Collection is owned by and subject to the exclusive control of Regis University and the authors of the materials. It is available only for research purposes and may not be used in violation of copyright laws or for unlawful purposes. The materials may not be downloaded in whole or in part without permission of the copyright holder or as otherwise authorized in the “fair use” standards of the U.S. copyright laws and regulations.
Recommended Citation
Spillane, Kevin, "A Framework for the Automatic Physical Configuration and Tuning of a Mysql Community Server" (2010). Regis University Student Publications (comprehensive collection). 310.
https://epublications.regis.edu/theses/310