基于磁盘数据库系统的瓶颈主要在磁盘I/O,通常采用缓冲池的设计,将读到的数据页先放入到内存缓冲池后再进行操作。因此,缓存池的大小直接决定了数据库的性能。通过研究基于闪存固态硬盘的特性,提出了一种基于闪存固态硬盘的辅助缓冲池设计。最后,通过修改开源数据库MySQL InnoDB存储引擎,并通过TPC-C实验对比分析了启用辅助缓冲池后数据库的性能可有100%-320%的提高。
Disk based on database performance mainly depends on the disk IO speed. Generally, database system has a large buffer pool, where the db operations take place. Hence, the database performance depends on the size of buffer pool. In this paper, we propose a secondary buffer pool solution based on the flash memory SSD(solid state drive), which uses the high random access speed and high IOPS feature of the SSD. We implemented our solution within MySQL InnoDB. Our real machine experiments running online transaction processing workloads (TPCC) show that after enabling secondary buffer pool, the database performance will achieves up to 100% - 320% improvements.