A Database Redo Log System Based on Virtual Memory Disk
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.
KeywordsApplication Server Data Block Hard Copy Node Server Performance Bottleneck
- 1.Lomet, D.B.: Persistent applications using generalized redo recovery. In: Proceedings of the 1998 14th International Conference on Data Engineering, pp. 154–163 (1998)Google Scholar
- 2.Haerder, T., Reuter, A.: Optimization of logging and recovery in a database system. ACS Symposium Series, pp. 151–168 (1979)Google Scholar
- 3.Ashdown, L., Moore, V.: Oracle9i Backup and Recovery Concepts, Release 2 (9.2). Oracle Corporation. Oracle Parkway, Redwood City (2002)Google Scholar
- 5.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)Google Scholar
- 6.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)Google Scholar