首页    期刊浏览 2024年07月09日 星期二
登录注册

文章基本信息

  • 标题: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
国家哲学社会科学文献中心版权所有