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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Park, K.-H., Choe, J.-k., Lee, Y.-H., Cheong, S.-K., Kim, Y.-S.: Performance Analysis for DRAM-based SSD system. Korean Information Technical Academic Society Dissertation 7(4), 41–47 (2009)
Kang, Y.-H., Yoo, J.-H., Cheong, S.-K.: Performance Evaluation of the SSD based on DRAM Storage System IOPS. Korean Information Technical Academic Society Dissertation 7(1), 265–272 (2009)
Cheong, S.-K., Jeong, Y.-W., Jeong, Y.-J., Jeong, J.-j.: Input-Output Performance Analysis of HDD and DDR-SSD Storage under the Streaming Workload. Korean Information Technical Academic Society Dissertation, 322–325 (2010)
Cheong, S.-K., Ko, D.-s.: Technology Prospect of Next Generation Storage. Korean Information Technical Academic Society Dissertation Summer Synthetic Scientific Announcement Thesis, 137 (2008)
Kim, H.: Learn to MYSQL Database Programming. Young-jin.com
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Song, HJ., Lee, YH., Cheong, SK. (2011). Performance Analysis of HDD and DRAM-SSD Using TPC-H Benchmark on MYSQL. In: Kim, Th., Adeli, H., Robles, R.J., Balitanas, M. (eds) Advanced Communication and Networking. ACN 2011. Communications in Computer and Information Science, vol 199. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-23312-8_15
Download citation
DOI: https://doi.org/10.1007/978-3-642-23312-8_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-23311-1
Online ISBN: 978-3-642-23312-8
eBook Packages: Computer ScienceComputer Science (R0)