Improving transaction abort rates without compromising throughput through judicious scheduling
暂无分享,去创建一个
Althought optimistic concurrency control protocols have increasingly been used in distributed database management systems, they imply a trade-off between the number of transactions that can be executed concurrently, hence, the peak throughput, and transactions aborted due to conflicts.
We propose a novel optimistic concurrency control mechanism that controls transaction abort rate by minimizing the time during which transactions are vulnerable to abort, without compromising throughput. Briefly, we throttle transaction execution with an adaptive mechanism based on the state of the transaction queues while allowing out-of-order execution based on expected transaction latency. Preliminary evaluation shows that this provides a substantial improvement in committed transaction throughput.
[1] José Pereira,et al. AKARA: A Flexible Clustering Protocol for Demanding Transactional Workloads , 2008, OTM Conferences.
[2] Gustavo Alonso,et al. Don't Be Lazy, Be Consistent: Postgres-R, A New Way to Implement Database Replication , 2000, VLDB.
[3] Rachid Guerraoui,et al. The Database State Machine Approach , 2003, Distributed and Parallel Databases.
[4] Daniel Gómez Ferro,et al. A critique of snapshot isolation , 2012, EuroSys '12.