Database Tuning.

Dennis Shasha, Steve Rozen: Database Tuning. VLDB 1992: 313

@inproceedings{DBLP:conf/vldb/ShashaR92,
  author    = {Dennis Shasha and
               Steve Rozen},
  editor    = {Li-Yan Yuan},
  title     = {Database Tuning},
  booktitle = {18th International Conference on Very Large Data Bases, August
               23-27, 1992, Vancouver, Canada, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1992},
  isbn      = {1-55860-151-1},
  pages     = {313},
  ee        = {db/conf/vldb/ShashaR92.html},
  crossref  = {DBLP:conf/vldb/92},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Database tuning is the activity of making a database application run more quickly. Tuning is difficult because it requires global knowledge of an information system, from the hardware to the operating system to the transaction subsystem to the query language to the application. This tutorial will discuss the principles of tuning in a way that can be immediately applied. Some typical questions it will address are:

How much main memory should you buy?
What concurrency level of consistency should you use?
For what queries is a non-clustering index better than a clustering one?
How should you partition a hot table and its indexes across disks in read-intensive and write-intensive applications?

The tutorial will cover the following:

Four general tuning principles
Tuning the hardware, operating system, and transaction subsystem
Choosing indexes
Relational system tuning

Copyright © 1992 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

Download PDF file (www.vldb.org, Darmstadt, Germany)
Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the CD and click on the path of your mount point:
/Anthology/vldb8997 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the DVD and click on the path of your mount point:
/Anthology/aDVD1 or /dvd

Printed Edition

Li-Yan Yuan (Ed.): 18th International Conference on Very Large Data Bases, August 23-27, 1992, Vancouver, Canada, Proceedings. Morgan Kaufmann 1992, ISBN 1-55860-151-1
Contents