Characterizing the Scalability of Decision-Support Workloads on Clusters and SMP Systems

Using a public domain version of a commercial clustered
database server and TPC-H like 3 decision support queries, this paper
studies the performance and scalability issues ofaPentium/Linux clus-
ter and an 8-way Linux SMP. The execution pro le demonstrates the
dominance of the I/O subsystem in the execution, and the importance
of the communication subsystem for cluster scalability. In addition to
quantifying their importance, this paper provides further details on how
these subsystems are exercised by the database engine.

By: Shailabh Nagar, Yanyong Zhang, Anand Sivasubramaniam, Hubertus Franke, Jianyong Zhang

Published in: Lecture Notes in Computer Science, volume 2400, (no ), pages 355-64 in 2002

Please obtain a copy of this paper from your local library. IBM cannot distribute this paper externally.

Questions about this service can be mailed to reports@us.ibm.com .