loading...
Database Server Workload Characterization in an E-Commerce Environment
Volendam, The Netherlands October 04-October 08
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MASCOT.2004.134830312th IEEE International Symposium on ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Fujian Liu, University of Saskatchewan
Yanping Zhao, University of Saskatchewan
Wenguang Wang, University of Saskatchewan
Dwight Makaroff, University of Saskatchewan
In an E-commerce system, the database server performance is crucial. Dynamic cache is often used to reduce the load on the database server, which reduces the need for scalability. A good understanding of the workload characteristics of the database server in an E-commerce environment is important to the design, tuning, and capacity planning of the database server. In this paper, we characterize the database server workloads in a benchmark E-commerce system. We focus on the response time, CPU utilization, the database page reference characteristics, and disk I/Os of the database server. We found that using dynamic cache can substantially reduce the CPU utilization but not always the number of disk I/Os of the database server. In most cases, using dynamic cache reduces temporal locality in database page references, but to a smaller degree than that reported in file servers and web proxies. Interestingly, in certain E-commerce workloads, using dynamic cache results in better temporal locality.
Citation:
Fujian Liu, Yanping Zhao, Wenguang Wang, Dwight Makaroff, "Database Server Workload Characterization in an E-Commerce Environment," mascots, pp.475-483, 12th IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems (MASCOTS'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.