Performance analysis of HDD and DRAM-SSD using TPC-H Benchmark on MYSQL

Abstract

Recently, Users needed storage for processing high-capacity data. Meanwhile, the HDD was used primarily as storage media, difference of the development of the processing speed of the HDD and CPU processing speed of development has occurred and serious the data input / output bottleneck that was created to solve a problem is SSD. So in this paper, using TPC-H Benchmark on MYSQL, we will compare DRAM-SSD to HDD and confirm showing good performance in data processing. As a performance analysis results , when DBMS database Size increased QphH@size was increased with TPC-H, but difference of the ad-hoc query processing ability are increased when compared of each database capacity. Based on these results, using DRAM-SSD Storage is judged to be effective at large amounts of data I/O required field or applications. © 2011 Springer-Verlag Berlin Heidelberg.