Towards Automated Performance Tuning for Complex Workloads.
Kurt P. Brown, Manish Mehta, Michael J. Carey, Miron Livny:
Towards Automated Performance Tuning for Complex Workloads.
VLDB 1994: 72-84@inproceedings{DBLP:conf/vldb/BrownMCL94,
author = {Kurt P. Brown and
Manish Mehta 0002 and
Michael J. Carey and
Miron Livny},
editor = {Jorge B. Bocca and
Matthias Jarke and
Carlo Zaniolo},
title = {Towards Automated Performance Tuning for Complex Workloads},
booktitle = {VLDB'94, Proceedings of 20th International Conference on Very
Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile},
publisher = {Morgan Kaufmann},
year = {1994},
isbn = {1-55860-153-8},
pages = {72-84},
ee = {db/conf/vldb/vldb94-72.html},
crossref = {DBLP:conf/vldb/94},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
In this paper we explore the problem of automatically adjusting DBMS
multiprogramming levels and memory allocations in order to achieve a
set of per-class response time goals for a complex multiclass
workload. We start by describing the phenomena that make this a very
challenging problem, the foremost of which is the interdependence
between classes that results from their competition for shared
resources. We then describe M&M, a feedback-based algorithm for
simultaneously determining the MPL and memory settings for each class
independently, and we evaluate the algorithm's effectiveness using a
detailed simulation model. We show that our algorithm can successfully
achieve response times that are within a few percent of the goals for
mixed workloads consisting of short transactions and longer-running ad
hoc join queries.
Copyright © 1994 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Jorge B. Bocca, Matthias Jarke, Carlo Zaniolo (Eds.):
VLDB'94, Proceedings of 20th International Conference on Very Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile.
Morgan Kaufmann 1994, ISBN 1-55860-153-8
Contents BibTeX
References
- [Brown93a]
- Kurt P. Brown, Michael J. Carey, Miron Livny:
Managing Memory to Meet Multiclass Workload Response Time Goals.
VLDB 1993: 328-341 BibTeX
- [Brown93b]
- Kurt P. Brown, Michael J. Carey, Miron Livny:
Towards an Autopilot in the DBMS Performance Cockpit.
HPTS 1993: 0- BibTeX
- [DeWitt84]
- David J. DeWitt, Randy H. Katz, Frank Olken, Leonard D. Shapiro, Michael Stonebraker, David A. Wood:
Implementation Techniques for Main Memory Database Systems.
SIGMOD Conference 1984: 1-8 BibTeX
- [DeWitt90]
- David J. DeWitt, Shahram Ghandeharizadeh, Donovan A. Schneider, Allan Bricker, Hui-I Hsiao, Rick Rasmussen:
The Gamma Database Machine Project.
IEEE Trans. Knowl. Data Eng. 2(1): 44-62(1990) BibTeX
- [DeWitt92]
- David J. DeWitt, Jim Gray:
Parallel Database Systems: The Future of High Performance Database Systems.
Commun. ACM 35(6): 85-98(1992) BibTeX
- [Ferg93]
- Donald F. Ferguson, Leonidas Georgiadis, Christos Nikolaou, K. Davies:
Goal Oriented, Adaptive Transaction Routing for High Performance Transaction Processing Systems.
PDIS 1993: 138-147 BibTeX
- [IBM93]
- ...
- [Mehta93]
- Manish Mehta, David J. DeWitt:
Dynamic Memory Allocation for Multiple-Query Workloads.
VLDB 1993: 354-367 BibTeX
- [Nikolaou92]
- ...
- [Pang93]
- HweeHwa Pang, Michael J. Carey, Miron Livny:
Memory-Adaptive External Sorting.
VLDB 1993: 618-629 BibTeX
- [Patel93]
- Jignesh M. Patel, Michael J. Carey, Mary K. Vernon:
Accurate Modeling of the Hybrid Hash Join Algorithm.
SIGMETRICS 1994: 56-66 BibTeX
- [Pirahesh90]
- Hamid Pirahesh, C. Mohan, Josephine M. Cheng, T. S. Liu, Patricia G. Selinger:
Parallelism in Relational Data Base Systems: Architectural Issues and Design Approaches.
DPDS 1990: 4-29 BibTeX
- [Weikum93]
- Gerhard Weikum, Christof Hasse, Axel Mönkeberg, Michael Rys, Peter Zabback:
The COMFORT Project (Synopsis).
PDIS 1993: 158-161 BibTeX
- [Yu93]
- Philip S. Yu, Douglas W. Cornell:
Buffer Management Based on Return on Consumption in a Multi-Query Environment.
VLDB J. 2(1): 1-37(1993) BibTeX
Referenced by
- Surajit Chaudhuri, Gerhard Weikum:
Rethinking Database System Architecture: Towards a Self-Tuning RISC-Style Database System.
VLDB 2000: 1-10
- Manish Mehta, David J. DeWitt:
Data Placement in Shared-Nothing Parallel Database Systems.
VLDB J. 6(1): 53-72(1997)
- Markus Sinnwell, Gerhard Weikum:
A Cost-Model-Based Online Method for Ditributed Caching.
ICDE 1997: 532-541
- Kurt P. Brown, Michael J. Carey, Miron Livny:
Goal-Oriented Buffer Management Revisited.
SIGMOD Conference 1996: 353-364
- HweeHwa Pang, Michael J. Carey, Miron Livny:
Multiclass Query Scheduling in Real-Time Database Systems.
IEEE Trans. Knowl. Data Eng. 7(4): 533-551(1995)
- Erhard Rahm, Robert Marek:
Dynamic Multi-Resource Load Balancing in Parallel Database Systems.
VLDB 1995: 395-406
- Manish Mehta, David J. DeWitt:
Managing Intra-operator Parallelism in Parallel Database Systems.
VLDB 1995: 382-394
- Diane L. Davison, Goetz Graefe:
Dynamic Resource Brokering for Multi-User Query Execution.
SIGMOD Conference 1995: 281-292
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:00 2009
