In a variety of test mix scenarios, the combination of 10 (combination 10:SSD * 2, RAID 0, Xfs,wb,nobarrier,noop) has the highest overall performance, so it is the benchmark, and the comparison of other schemes, the following table is the comparison of the combinations and combinations 10:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLTP%E5%AF%B9%E6% Af%94%e6%b5%8b%e8%af%95%e8%a1%a8-20120907.png "style=" border:0px; "alt=" sas_vs_ssd_mysql_oltp%e5%af%b9%e6%af%94% "/>
The corresponding contrast line graph:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLTP%E5%AF%B9%E6% Af%94%e6%b5%8b%e8%af%95%e5%9b%be-20120907.png "style=" border:0px; "alt=" sas_vs_ssd_mysql_oltp%e5%af%b9%e6%af%94% "/>
Test environment:
650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLTP_ Env-20120907.jpg "style=" border:0px; "alt=" sas_vs_ssd_mysql_oltp_env-20120907.jpg "/>
--------------------------------------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/1879748
SAS vs SSD various modes MySQL TPCC OLTP comparison test results