UWSpace is currently experiencing technical difficulties resulting from its recent migration to a new version of its software. These technical issues are not affecting the submission and browse features of the site. UWaterloo community members may continue submitting items to UWSpace. We apologize for the inconvenience, and are actively working to resolve these technical issues.
 

Automatically Tuning Database Server Multiprogramming Level

Thumbnail Image

Files

thesis.pdf (1.4 MB)

Date

2007-09-06T17:56:20Z

Authors

Abouzour, Mohammed

Journal Title

Journal ISSN

Volume Title

Publisher

University of Waterloo

Abstract

Optimizing database systems to achieve the maximum attainable throughput of the underlying hardware is one of the many difficult tasks that face Database Administrators. With the increased use of database systems in many environments, this task has even become more difficult. One of the parameters that needs to be configured is the number of worker tasks that the database server uses (the multiprogramming level). This thesis will focus on how to automatically adjust the number of database server worker tasks to achieve maximum throughput under varying workload characteristics. The underlying intuition is that every workload has an optimal multiprogramming level that can achieve the best throughput given the workload characteristic.

Description

Keywords

Auto-tuning optimization database servers

LC Keywords

Citation

URI

http://hdl.handle.net/10012/3207

Collections

Theses
Computer Science