Abstract
Snapshot isolation (SI) is a widely studied concurrency control approach, with great impact in practice within platforms such as Oracle or SQL Server. Berenson et al. showed though that SI does not guarantee serializable execution; in certain situations, data consistency can be violated through concurrency between correct applications. Recently, variants of SI have been proposed, that keep the key properties such as (often) allowing concurrency between reads and updates, and that also guarantee that every execution will be serializable. We have had the opportunity to use three implementations of two different algorithms of this type, all based on the InnoDB open source infrastructure. We measure the performance attained by these implementations, on high-end hardware with a substantial number of cores. We explore the impact of the differences in algorithm, and also of the low-level implementation decisions.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Stonebraker, M.: Are We Polishing a Round Ball? (Panel). In: Proceedings of the 1993 IEEE International Conference on Data Engineering (ICDE), p. 606 (1993)
Berenson, H., Bernstein, P., Gray, J., Melton, J., O’Neil, E., O’Neil, P.: A Critique of ANSI SQL Isolation Levels. In: Proceedings of SIGMOD 1995, pp. 1–10 (1995)
Jacobs, K.: Concurrency Control: Transaction Isolation and Serializability in SQL92 and Oracle7. Technical Report A33745 (White Paper), Oracle Corporation (1995)
Jorwekar, S., Fekete, A., Ramamritham, K., Sudarshan, S.: Automating the Detection of Snapshot Isolation Anomalies. In: Proceedings of VLDB 2007, pp. 1263–1274 (2007)
Cahill, M.J., Röhm, U., Fekete, A.D.: Serializable Isolation for Snapshot Databases. In: Proceedings of SIGMOD 2008, pp. 729–738 (2008)
Cahill, M.J., Röhm, U., Fekete, A.: Serializable Isolation for Snapshot Databases. ACM Transactions on Database Systems 34, 1–42 (2009)
Fekete, A., Liarokapis, D., O’Neil, E., O’Neil, P., Shasha, D.: Making Snapshot Isolation Serializable. ACM Transactions on Database Systems 30, 492–528 (2005)
Revilak, S., O’Neil, P., O’Neil, E.: Precisely Serializable Snapshot Isolation (PSSI). In: Proceedings of ICDE 2011, pp. 482–493 (2011)
Casanova, M., Bernstein, P.: General purpose schedulers for database systems. Acta Informatica 14, 195–220 (1980)
Boyd-Wickizer, S., Clements, A.T., Mao, Y., Pesterev, A., Kaashoek, M.F., Morris, R., Zeldovich, N.: An analysis of Linux scalability to many cores. In: OSDI 2010, pp. 1–8 (2010)
Clements, A.T., Kaashoek, F., Zeldovich, N.: Scalable Address Spaces Using RCU Balanced Trees. In: Proceedings of ASPLOS 2012 (2012)
Johnson, R., Pandis, I., Hardavellas, N., Ailamaki, A., Falsafi, B.: Shore-MT: a scalable storage manager for the multicore era. In: Proceedings of EDBT 2009, pp. 24–35 (2009)
Pandis, I., Johnson, R., Hardavellas, N., Ailamaki, A.: Data-Oriented Transaction Execution. In: Proceedings of VLDB 2010, pp. 928–939 (2010)
Ports, D.R.K., Grittner, K.: Serializable Snapshot Isolation in PostgreSQL. In: Proceedings of VLDB 2012, pp. 1850–1861 (2012)
Jung, H., Han, J.H., Fekete, A., Röhm, U., Yeom, H.Y.: Performance of serializable snapshot isolation on multicore servers. Technical Report TR693, School of Information Technologies, The University of Sydney (December 2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jung, H., Han, H., Fekete, A., Röhm, U., Yeom, H.Y. (2013). Performance of Serializable Snapshot Isolation on Multicore Servers. In: Meng, W., Feng, L., Bressan, S., Winiwarter, W., Song, W. (eds) Database Systems for Advanced Applications. DASFAA 2013. Lecture Notes in Computer Science, vol 7826. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-37450-0_31
Download citation
DOI: https://doi.org/10.1007/978-3-642-37450-0_31
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-37449-4
Online ISBN: 978-3-642-37450-0
eBook Packages: Computer ScienceComputer Science (R0)