earticle

영어

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. And CO2 &power consumption was tested. CO2 emissions analysis result during analysis of performance of each storage using Postmark and TPC-H, as shown in Figure 4 HDD storage can be considered less CO2 emissions due to the power consumption when non-load. But, increasing the load to DRAM-SSD storage generated less CO2 emission.