文章基本信息

标题：CUBRID Analysis of the Effectiveness according to Buffer Size Variation of Storage (multi load)
本地全文：下载
作者：Jae-Hwan Lee ; Young-Hun Lee
期刊名称：International Journal of Software Engineering and Its Applications
印刷版ISSN：1738-9984
出版年度：2014
卷号：8
期号：3
页码：379-388
DOI：10.14257/ijseia.2014.8.3.34
出版社：SERSC
摘要：In this study, the efficiency by storage medium according to changes in the buffer size was compared and analyzed focusing on parameters setting the size of the buffer that most of DBMSs have in common in relation to storage media. efficiency was compared and analyzed by NBD(NHN Bulletin Board Application Database) according changes to the buffer size when single load which different work load from that of the TPC-H model. It was observed In QUIBRID that there is a difference due to the performance of the two storage media when TPS has been measured by giving single or multi-load through Level 2 of the NBD Benchmark but that there is no change in TPS according to the buffer size. It is because the small loads of Level 2 are processed within a range of not exceeding the buffer capacity. Thus it appears that for small loads for reading, printing out, or searching posts, there is no need to apply the large buffer to the two storage media all. D-SSD show no performance degradation due to excellent Read/Write functions. Thus, it is expected to achieve the desired performance without tuning works on the buffer size to process DB data.
关键词：NBD; HDD; MYSQL; CUBRID; Buffer Size