An OLTP performance comparison test was previously done: SAS vs SSD various modes MySQL TPCC OLTP comparison test results, this time to do the OLAP comparison test.
The comparison test results are shown below:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLAP_benchmarking _20121225.jpg "style=" border:0px; "alt=" sas_vs_ssd_mysql_olap_benchmarking_20121 "/>
The corresponding performance boost ratio for SSD devices:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLAP_benchmarking _ratio_20121225.jpg "style=" border:0px; "alt=" Sas_vs_ssd_mysql_olap_benchmarking_ratio "/>
Test environment:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLAP_benchmarking _env_20121225.jpg "style=" border:0px; "alt=" sas_vs_ssd_mysql_olap_benchmarking_env_2 "/>
--------------------------------------Split Line--------------------------------------
http://zhishuedu.comTraining is a professional quality training brand jointly launched by senior MySQL expert Ye Jinlong and Wu Bingxi, with MySQL dba combat optimization and Python devops Development course, which is the most conscientious and The most quality training courses.
This article is from the "Lao Ye teahouse" blog, please be sure to keep this source http://imysql.blog.51cto.com/1540006/1879754
SAS vs SSD compare test MySQL tpch performance