Abstract
Monitoring query processing has proven to be an effective technique to detect bottlenecks in sequential query execution systems' components. Monitoring distributed execution in parallel systems, however, is a difficult task. The monitoring data of all nodes must be collected at the same time to value load-balancing and scheduling. Furthermore, we want to extract not only information about resource allocation of single processes but also allow for monitoring of single tuples and attribute value distribution. The monitoring system we present in this paper is a client-server architecture where each process of the parallel database system is a client of the monitoring server. This architecture enables the user to monitor even load-balancing or scheduling effects. The monitoring extensions, each client is attached with, provide inspection of the processes at a fine granularity. Furthermore user-defined interpretation of monitoring data on the client side enables emulation of special parallel hardware by low costly components.
supported by the German Research Council under contract DFG Fr 1142/1-1.
Preview
Unable to display preview. Download preview PDF.
References
D. J. DeWitt and J. Gray. Parallel Database Systems: The Future of High Performance Database Systems. Communications of the ACM, 35(6), June 1992.
J. Gray. A Survey of Parallel Database Techniques and Systems. In Tutorial Handouts of the 21st Int'l. Conf. on Very Large Data Bases, Zurich, Switzerland, September 1995.
Jim Gray, editor. The Benchmark Handbook. Morgan Kaufmann, San Mateo, CA, USA, 2 edition, 1993.
H. Pirahesh, C. Mohan, J. Cheng, T. S. Liu, and P. Selinger. Parallelism in Relational Data Base Systems: Architectural Issues and Design Approaches. InProc. Int'l. Symp. on Databases in Parallel and Distr. Systems, Dublin, Ireland, July 1990.
D. A. Schneider and D. J DeWitt. A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment. In Proc. ACM SIGMOD Int'l. Conf, May 1989.
P. Valduriez. Parallel Database Systems: The Case for Shared-Something (Keynote Address). In Proc. IEEE Int'l. Conf. on Data Eng., Vienna, Austria, April 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1997 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Manegold, S., Waas, F., Gudlat, D. (1997). In quest of the bottleneck — monitoring parallel database systems. In: Bubak, M., Dongarra, J., Waśniewski, J. (eds) Recent Advances in Parallel Virtual Machine and Message Passing Interface. EuroPVM/MPI 1997. Lecture Notes in Computer Science, vol 1332. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63697-8_95
Download citation
DOI: https://doi.org/10.1007/3-540-63697-8_95
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-63697-7
Online ISBN: 978-3-540-69629-2
eBook Packages: Springer Book Archive