MTPower: A parallel database storage engine for batch insertion

作者：Chen, Hu^*; Tang, Hai-Hao; Liao, Jiang-Miao; Peng, Jiang-Feng

来源：Chinese Journal of Computers, 2010, 33(8): 1492-1499.

DOI：10.3724/SP.J.1016.2010.01492

• Disk buffer
• Multi-core processor
• Parallel Database
• Parallel Hash index
• Tree indices

This paper presents a parallel MySQL storage engine, MTPower, which focuses on using parallel computing capacity of multi-core processors to improve index insertion in batch insertion. MTPower includes storage engine interface, parallel batch linear hash index, parallel batch B+ tree index and disk buffer. The test results indicate that MTPower performances are 6.1 times and 4.8 times than MyISAM, a traditional single-threaded storage engine in MySQL, at best in testing batch insertion with hash index and B+ tree index. MTPower can achieve the best performance, when the total number of threads is close to the core number of processors. With the increase of the number of processor cores, the performance of MTPower increases subsequently.

• 出版日期2010-8
• 单位华南理工大学