Performance Analysis of DRAM-SSD and HDD According to the Each Environment on MYSQL

被引:0
作者
Song, Hyun-Ju [1 ]
Lee, Young-Hun [1 ]
Cheong, Seung-Kook [2 ]
机构
[1] Hannam Univ, Dept Elect Eng, Taejon 306791, South Korea
[2] ETRI, Dept Principal Member Engn, Daejeon 305700, South Korea
来源
COMMUNICATION AND NETWORKING, PT II | 2011年 / 266卷
关键词
SSD; HDD; Mysql; TPC-H; SAN;
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Recently. Users needed storage for processing high-capacity data. Meanwhile, the HDD was used primarily as storage device, but SSD was developed as a fast access device. So, the use of SSD increased a lot of capacity-process. Using a SAN Switch, we tested in order to resolve data process faster. So in this paper, DRAM-SSD and HDD's performance ability in the data process will be confirmed using TPC-H Benchmark on MYSQL at SAN environment. From the performance analysis results, performance difference of HDD and DRAM-SSD is little when database size is low at san switch connecting with storage. But ad-hoc query process ability difference between DRAM-SSD and HDD increased. Based on these results in a SAN-based. DRAM-SSD has a better performance than the HDD. Therefore San is judged to be more effective when dealing with the large amounts of data using a SAN to manage data.
引用
收藏
页码:330 / +
页数:3
相关论文
共 6 条
  • [1] Cheong S.-K., 2010, KOREAN INFORM TECHNI, P322
  • [2] Cheong S.-K, 2008, THESIS, P137
  • [3] Judd J., 1996, BUILDING SANS WITCH, P9
  • [4] Kang Y.-H., 2009, KOREAN INFORM TECHNI, V7, P265
  • [5] Kim H., LEARN MYSQL DATABASE
  • [6] Park K.-H., 2009, KOREAN INFORM TECHNI, V7, P41