In this paper, based on an empirical simulation study, we report on the performance implications of five atomic commit protocols on transaction throughput in future, wide-area gigabit-networked database systems. In our study, in addition to the three well known two-phase commit (2PC) variants, we considered two single-phase commit protocols, namely, the implicit yes-vote (IYV) and coordinator log. Salient results of our study show that IYV is, in general, better than all the other evaluated protocols during normal processing. Performance enhancements due to a read-only optimization are more pronounced with short transactions. The choice of a 2PC variant has very little impact on performance in the case of long transactions as opposed to short ones, with presumed commit being better than presumed abort in most cases.
展开▼