Performance comparison of thrashing control policies for concurrent Mergesorts with parallel prefetching
- 1 June 1993
- proceedings article
- Published by Association for Computing Machinery (ACM)
- Vol. 21 (1) , 171-182
- https://doi.org/10.1145/166955.167003
Abstract
We study the performance of various run-time thrashing control policies for the merge phase of concurrent mergesorts using parallel prefetching, where initial sorted runs are stored on multiple disks and the final sorted run is written back to another dedicated disk. Parallel prefetching via multiple disks can be attractive in reducing the response times for concurrent mergesorts. However, severe thrashing may develop due to imbalances between input and output rates, thus a large number of prefetched pages in the buffer can be replaced before referenced. We evaluate through detailed simulations three run-time thrashing control policies: (a) disabling prefetching, (b) forcing synchronous writes and (c) lowering the prefetch quantity in addition to forcing synchronous writes. The results show that (1) thrashing resulted from parallel prefetching can severely degrade the system response time; (2) though effective in reducing the degree of thrashing, disabling prefetching may worsen the response time since more synchronous reads are needed; (3) forcing synchronous writes can both reduce thrashing and improve the response time; (4) lowering the prefetch quantity in addition to forcing synchronous writes is most effective in reducing thrashing and improving the response time.Keywords
This publication has 11 references indexed in Scilit:
- Buffer management based on return on consumption in a multi-query environmentThe VLDB Journal, 1993
- Flexible buffer allocation based on marginal gainsPublished by Association for Computing Machinery (ACM) ,1991
- Merging sorted runs using large main memoryActa Informatica, 1989
- Storage hierarchiesIBM Systems Journal, 1989
- The input/output complexity of sorting and related problemsCommunications of the ACM, 1988
- Buffer management in relational database systemsACM Transactions on Database Systems, 1986
- The I/O Performance of Multiway Mergesort and Tag SortIEEE Transactions on Computers, 1985
- Implementation techniques for main memory database systemsPublished by Association for Computing Machinery (ACM) ,1984
- Managing IBM Database 2 buffers to maximize performanceIBM Systems Journal, 1984
- Parallel algorithms for the execution of relational database operationsACM Transactions on Database Systems, 1983