Paper Info
Title
DBMS workload control using throttling: experimental insights
Abstract
Today's database management systems (DBMSs) are required to handle diverse, mixed workloads and to provide differentiated levels of service to ensure that critical work takes priority. In order to meet these needs, it is necessary for a DBMS to have control over the workload executing in the system. Lower priority workloads should be limited to allow higher priority workloads to complete in a timely fashion. In this paper we examine query throttling techniques as a method of workload control. In our approach, a workload class may be slowed down during execution in order to release system resources that can be used by higher priority workloads. We examine two methods of throttling; constant throttling throughout query execution, and a single interruption in which a query is paused for a period of time. A set of experiments using Postresql 8.1 provides insights regarding the performance of these different throttling techniques under different workload conditions and how they compare to using operating system process priority control as a throttling mechanism.
Year
DOI
Venue
2008
10.1145/1463788.1463790
CASCON
Keywords
Field
DocType
query throttling technique,throttling mechanism,workload class,experimental insight,different throttling technique,mixed workloads,dbms workload control,operating system process priority,higher priority workloads,lower priority workloads,different workload condition,constant throttling,database management system,level of service,operating system
Level of service,Workload,Computer science,Real-time computing,Database,Bandwidth throttling,Operating system,Distributed computing
Conference
Citations 
PageRank 
References 
3
0.42
7
Authors
3
Name
Order
Citations
PageRank
Wendy Powley132928.43
Pat Martin2805.64
Paul Bird31198.78