Abstract
Redo log of database must be written to permanence storage like disks. When database is heavily loaded, the crowded redo log writing queue will become a performance bottleneck. In this paper, the operation principle of database redo log is analyzed. It is found that if redo log is stored on virtual memory disk directly, the database will demonstrate better performance. In addition, the reliability of redo log system based on virtual memory disk is analyzed. At the end of the paper, a contrastive performance measurement result is given.
This research was partially supported by the Chinese “863” project, sponsored by the Chinese Ministry of Science and Technology under contract 2003AA1Z2330.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Lomet, D.B.: Persistent applications using generalized redo recovery. In: Proceedings of the 1998 14th International Conference on Data Engineering, pp. 154–163 (1998)
Haerder, T., Reuter, A.: Optimization of logging and recovery in a database system. ACS Symposium Series, pp. 151–168 (1979)
Ashdown, L., Moore, V.: Oracle9i Backup and Recovery Concepts, Release 2 (9.2). Oracle Corporation. Oracle Parkway, Redwood City (2002)
Kumar, V., Moe, S.D.: Performance of recovery algorithms for centralized database management systems. Information Sciences 86(1-3), 101–147 (1995)
Shu, J.W., Xue, W., Li, B.G., Zheng, W.M.: TH-MSNS: A High Scalable Network Storage System. Chinese Journal of Computers 28(3), 326–333 (2005)
Jin, C., Zheng, W.M., Mao, Y., Wang, D.S.: Two methods to improve the performance of synchronous disk I/O in Linux environment. In: The Third LCI International Conference on Linux Clusters, St. Petersburg, USA (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wu, H., Yu, H., Li, B., Wei, X., Zheng, W. (2006). A Database Redo Log System Based on Virtual Memory Disk. In: Alexandrov, V.N., van Albada, G.D., Sloot, P.M.A., Dongarra, J. (eds) Computational Science – ICCS 2006. ICCS 2006. Lecture Notes in Computer Science, vol 3993. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11758532_86
Download citation
DOI: https://doi.org/10.1007/11758532_86
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-34383-7
Online ISBN: 978-3-540-34384-4
eBook Packages: Computer ScienceComputer Science (R0)