| | |
Summary: QShuffler: Getting the Query Mix Right
Mumtaz Ahmad 1
, Ashraf Aboulnaga 1
, Shivnath Babu 2
, Kamesh Munagala 2
1
David R. Cheriton School of Computer Science, University of Waterloo
{m4ahmad, ashraf}@cs.uwaterloo.ca
2
Department of Computer Science, Duke University
{shivnath, kamesh}@cs.duke.edu
Abstract-- The typical workload in a database system consists
of a mixture of multiple queries of different types, running
concurrently and interacting with each other. Hence, optimizing
performance requires reasoning about query mixes and their
interactions, rather than considering individual queries or query
types. In this paper, we use such a reasoning approach to develop
a query scheduler. We treat the database system as a black box
and experimentally build a model to estimate the performance of
different query mixes. Our scheduler uses this model to decide
|
