| | |
Summary: Priority Mechanisms for OLTP and Transactional Web Applications
David T. McWherter Bianca Schroeder Anastassia Ailamaki Mor Harchol-Balter
Abstract
Transactional workloads are a hallmark of modern
OLTP and Web applications, ranging from electronic com-
merce and banking to online shopping. Often, the database
at the core of these applications is the performance bottle-
neck. Given the limited resources available to the database,
transaction execution times can vary wildly as they compete
and wait for critical resources. As the competitor is "only a
click away," valuable (high-priority) users must be ensured
consistently good performance via QoS and transaction pri-
oritization.
This paper analyzes and proposes prioritization for
transactional workloads in traditional database systems
(DBMS). This work first performs a detailed bottleneck
analysis of resource usage by transactional workloads on
commercial and noncommercial DBMS (IBM DB2, Post-
greSQL, Shore) under a range of configurations. Second,
|
