s-tajima/dstat_sysbench.csv

## dstat_sysbench.csv
"Dstat 0.7.0 CSV output"
"Author:","Dag Wieers <dag@wieers.com>",,,,"URL:","http://dag.wieers.com/home-made/dstat/"
"Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root"
"Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:23:31 JST"

"system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total",
"date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send"
01-06 21:23:31,1.431,0.480,97.839,0.232,0.003,0.015,1.850,1.910,2.980,4276502528.0,1417216.0,608673792.0,26650816512.0,387455.559,3407668.729,25.536,220.067,0.0,0.0
01-06 21:23:34,47.029,14.226,23.096,14.393,0.544,0.711,2.740,2.100,3.040,5044092928.0,3162112.0,25317376.0,26464837632.0,261320704.0,30037.333,15849.0,7.333,380.0,799.333
01-06 21:23:37,69.153,19.866,1.593,7.795,0.796,0.796,2.740,2.100,3.040,6165258240.0,3346432.0,26124288.0,25342681088.0,375156736.0,25941.333,22900.667,5.0,978.0,936.0
01-06 21:23:40,61.744,16.437,12.891,7.551,0.709,0.668,4.120,2.400,3.130,7095103488.0,417792.0,21508096.0,24420380672.0,310879573.333,38912.0,18909.333,9.667,1162.0,1570.667
01-06 21:23:43,69.022,18.896,2.258,8.152,0.794,0.878,4.120,2.400,3.130,8245813248.0,909312.0,23552000.0,23267135488.0,381487786.667,29696.0,23246.667,5.667,940.667,963.333
01-06 21:23:46,73.292,19.417,0.583,4.792,0.917,1.0,5.070,2.620,3.200,9423802368.0,2220032.0,25657344.0,22085730304.0,392201557.333,20138.667,23916.0,3.0,783.333,2900.0
01-06 21:23:49,36.055,9.631,42.923,10.553,0.377,0.461,6.110,2.880,3.270,9973288960.0,1527808.0,23822336.0,21538770944.0,183376554.667,47957.333,11121.0,11.0,175.333,554.0
01-06 21:23:52,5.579,1.426,71.225,21.728,0.0,0.042,6.110,2.880,3.270,10055286784.0,1540096.0,23830528.0,21456752640.0,26174805.333,7168.0,1598.333,1.667,228.0,491.333
01-06 21:23:55,5.983,1.715,69.623,22.510,0.0,0.167,6.980,3.110,3.350,10135715840.0,1732608.0,24432640.0,21375528960.0,27443200.0,19114.667,1672.333,3.0,828.667,963.333
01-06 21:23:58,6.040,1.678,71.351,20.847,0.0,0.084,6.980,3.110,3.350,10215645184.0,1740800.0,24432640.0,21295591424.0,27967488.0,5461.333,1706.667,1.0,1403.0,1015.333
01-06 21:24:01,6.195,1.758,71.201,20.720,0.042,0.084,7.860,3.360,3.430,10303709184.0,1757184.0,24432640.0,21207511040.0,27787264.0,21845.333,1696.333,2.333,689.333,648.667
01-06 21:24:04,6.143,1.880,68.742,23.109,0.0,0.125,8.590,3.580,3.500,10398318592.0,1896448.0,25018368.0,21112176640.0,27462314.667,5632.0,1668.0,1.333,1062.0,2131.333
01-06 21:24:07,6.190,1.715,69.176,22.794,0.0,0.125,8.590,3.580,3.500,10480734208.0,1912832.0,25026560.0,21029736448.0,27181056.0,10922.667,1660.0,2.0,1972.333,2023.333
01-06 21:24:10,6.087,1.595,70.613,21.620,0.0,0.084,9.270,3.810,3.570,10566832128.0,1921024.0,25030656.0,20943626240.0,27585194.667,5461.333,1683.0,1.0,978.0,502.0
01-06 21:24:13,6.483,1.798,69.302,22.292,0.0,0.125,9.270,3.810,3.570,10661253120.0,1937408.0,25022464.0,20849197056.0,27989333.333,10922.667,1708.667,2.0,601.667,480.667
01-06 21:24:16,6.444,1.715,67.238,24.435,0.042,0.126,9.890,4.020,3.640,10743136256.0,1945600.0,25030656.0,20767297536.0,28065792.0,5461.333,1713.0,1.0,270.667,480.667
01-06 21:24:19,6.158,1.843,69.753,22.162,0.0,0.084,10.690,4.290,3.730,10829365248.0,1961984.0,25022464.0,20681060352.0,27514197.333,14165.333,1679.333,3.0,317.333,520.0
01-06 21:24:22,6.423,1.553,69.018,22.880,0.0,0.126,10.690,4.290,3.730,10911137792.0,1970176.0,25030656.0,20599271424.0,27694421.333,5461.333,1690.0,1.0,236.0,486.0
01-06 21:24:25,6.410,1.969,69.376,22.162,0.0,0.084,11.360,4.530,3.810,10994384896.0,1990656.0,25030656.0,20516003840.0,27810474.667,17749.333,1698.333,2.667,577.333,491.333
01-06 21:24:28,6.379,1.511,69.912,22.115,0.0,0.084,11.360,4.530,3.810,11078516736.0,1998848.0,25030656.0,20431863808.0,27290282.667,19114.667,1664.667,3.667,249.333,486.0
01-06 21:24:31,6.488,1.716,71.411,20.343,0.0,0.042,11.970,4.770,3.890,11160420352.0,2015232.0,25026560.0,20349947904.0,27159210.667,15018.667,1658.0,2.0,91.333,491.333
01-06 21:24:34,6.549,1.679,69.060,22.586,0.0,0.126,12.450,4.990,3.970,11246514176.0,2023424.0,25030656.0,20263841792.0,28158634.667,5461.333,1718.333,1.0,155.333,491.333
01-06 21:24:37,6.583,1.677,66.373,25.283,0.0,0.084,12.450,4.990,3.970,11324080128.0,2048000.0,25026560.0,20186255360.0,27579733.333,16384.0,1684.0,3.0,316.667,491.333
01-06 21:24:40,6.502,1.762,66.946,24.622,0.042,0.126,12.980,5.230,4.050,11408084992.0,2056192.0,25026560.0,20102242304.0,27858261.333,5461.333,1700.0,1.0,466.667,480.667
01-06 21:24:43,6.669,1.804,68.247,23.154,0.0,0.126,12.980,5.230,4.050,11492212736.0,2072576.0,25022464.0,20018102272.0,27628885.333,9557.333,1686.0,2.0,343.333,480.667
01-06 21:24:46,6.751,1.803,67.463,23.857,0.0,0.126,13.300,5.420,4.120,11574247424.0,2084864.0,25034752.0,19936043008.0,27821397.333,5461.333,1698.667,1.0,511.333,486.0
01-06 21:24:49,6.832,1.718,69.824,21.542,0.0,0.084,13.680,5.630,4.190,11658248192.0,2101248.0,25030656.0,19852029952.0,27792725.333,11434.667,1696.0,2.667,262.0,486.0
01-06 21:24:52,6.410,1.676,70.172,21.575,0.042,0.126,13.680,5.630,4.190,11742367744.0,2109440.0,25034752.0,19767898112.0,26569386.667,5461.333,1621.667,1.0,529.667,491.333
01-06 21:24:55,6.812,1.598,66.905,24.558,0.0,0.126,14.020,5.830,4.270,11824394240.0,2134016.0,25026560.0,19685855232.0,28147712.0,15018.667,1718.0,3.0,249.333,491.333
01-06 21:24:58,7.158,1.758,66.471,24.487,0.0,0.126,14.020,5.830,4.270,11908390912.0,2142208.0,25026560.0,19601850368.0,27830954.667,8192.0,1699.0,1.667,208.667,480.667
01-06 21:25:01,6.885,1.805,67.338,23.887,0.0,0.084,14.420,6.050,4.350,11992379392.0,2158592.0,25034752.0,19517837312.0,27803648.0,13653.333,1697.333,2.0,240.667,486.0
01-06 21:25:04,6.795,2.097,67.743,23.238,0.0,0.126,14.710,6.250,4.420,12076511232.0,2166784.0,25034752.0,19433697280.0,27738112.0,12288.0,1692.667,2.667,410.667,520.0
01-06 21:25:07,7.089,1.846,67.156,23.784,0.042,0.084,14.710,6.250,4.420,12158554112.0,2183168.0,25034752.0,19351638016.0,28076714.667,10922.667,1714.0,2.0,1833.667,1911.333
01-06 21:25:10,7.128,1.803,66.918,24.067,0.0,0.084,14.970,6.450,4.490,12244656128.0,2199552.0,25026560.0,19265527808.0,27716266.667,10922.667,1691.333,2.0,488.0,512.667
01-06 21:25:13,7.167,1.928,66.387,24.392,0.0,0.126,14.970,6.450,4.490,12326551552.0,2215936.0,25022464.0,19183620096.0,27809109.333,10922.667,1697.667,2.0,408.0,480.667
01-06 21:25:16,7.215,1.804,65.688,25.210,0.0,0.084,15.130,6.620,4.560,12410662912.0,2224128.0,25034752.0,19099488256.0,27590656.0,5461.333,1683.333,1.0,206.667,486.0
01-06 21:25:19,7.179,1.847,66.331,24.559,0.0,0.084,15.360,6.810,4.630,12492566528.0,2240512.0,25030656.0,19017572352.0,27721728.0,11434.667,1692.333,2.667,206.667,491.333
01-06 21:25:22,7.314,1.807,66.583,24.212,0.0,0.084,15.360,6.810,4.630,12576567296.0,2256896.0,25026560.0,18933559296.0,27650730.667,10922.667,1687.333,2.0,257.333,491.333
01-06 21:25:25,7.341,1.971,64.681,25.839,0.042,0.126,15.650,7.010,4.710,12658601984.0,2273280.0,25034752.0,18851500032.0,27667114.667,10922.667,1688.667,2.0,112.667,486.0
01-06 21:25:28,7.415,1.969,65.982,24.550,0.0,0.084,15.650,7.010,4.710,12744704000.0,2281472.0,25034752.0,18765389824.0,27601578.667,6826.667,1684.667,1.333,548.0,491.333
01-06 21:25:31,5.747,1.636,70.889,21.602,0.0,0.126,15.920,7.210,4.790,12810342400.0,647168.0,22036480.0,18704384000.0,23704917.333,29354.667,1397.0,6.667,198.0,491.333
01-06 21:25:34,4.987,1.467,70.662,22.842,0.0,0.042,16.250,7.420,4.870,12888330240.0,675840.0,22216704.0,18626187264.0,25781589.333,24576.0,1574.667,3.0,300.0,564.667
01-06 21:25:37,5.737,1.508,70.059,22.613,0.0,0.084,16.250,7.420,4.870,12968116224.0,696320.0,22220800.0,18546376704.0,25993216.0,17749.333,1587.0,2.333,338.0,491.333
01-06 21:25:40,5.581,1.469,70.080,22.786,0.0,0.084,16.470,7.610,4.940,13043732480.0,704512.0,22220800.0,18470752256.0,25985024.0,5461.333,1586.0,1.0,372.667,491.333
01-06 21:25:43,5.537,1.468,71.141,21.812,0.0,0.042,16.470,7.610,4.940,13123407872.0,720896.0,22220800.0,18391060480.0,26083328.0,10922.667,1592.333,2.0,364.667,486.0
01-06 21:25:46,5.668,1.679,67.884,24.601,0.042,0.126,16.670,7.800,5.020,13203857408.0,729088.0,22233088.0,18310590464.0,26169344.0,5461.333,1598.333,1.0,193.333,486.0
01-06 21:25:49,5.860,1.465,71.243,21.348,0.0,0.084,16.700,7.950,5.080,13283786752.0,745472.0,22233088.0,18230644736.0,25859413.333,12288.0,1578.333,2.0,112.667,486.0
01-06 21:25:52,5.700,1.467,70.327,22.422,0.0,0.084,16.700,7.950,5.080,13357166592.0,753664.0,22237184.0,18157252608.0,25236821.333,5461.333,1539.667,1.0,313.333,486.0
01-06 21:25:55,5.702,1.426,69.937,22.851,0.0,0.084,16.800,8.120,5.150,13432774656.0,770048.0,22237184.0,18081628160.0,25351509.333,9557.333,1547.667,2.0,374.667,486.0
01-06 21:25:58,5.961,1.469,70.193,22.292,0.0,0.084,16.800,8.120,5.150,13512704000.0,778240.0,22237184.0,18001690624.0,26525696.0,5461.333,1618.333,1.0,91.333,486.0
01-06 21:26:01,6.006,1.512,69.551,22.848,0.0,0.084,16.900,8.290,5.220,13594730496.0,794624.0,22237184.0,17919647744.0,26624000.0,9557.333,1625.0,2.0,435.333,509.333
01-06 21:26:04,6.310,1.630,68.199,23.778,0.0,0.084,17.140,8.480,5.300,13670936576.0,802816.0,22237184.0,17843433472.0,25948160.0,5461.333,1584.0,1.0,318.333,486.0
01-06 21:26:07,5.959,1.469,68.653,23.836,0.0,0.084,17.140,8.480,5.300,13750996992.0,819200.0,22233088.0,17763360768.0,25930410.667,19114.667,1583.0,3.0,2168.333,1986.0
01-06 21:26:10,6.187,1.672,70.109,21.865,0.042,0.125,17.210,8.640,5.370,13833150464.0,827392.0,22241280.0,17681190912.0,26132480.0,5461.333,1596.0,1.0,428.0,507.333
01-06 21:26:13,6.156,1.675,70.436,21.650,0.0,0.084,17.210,8.640,5.370,13906718720.0,843776.0,22241280.0,17607606272.0,26290858.667,19114.667,1603.333,4.0,332.0,491.333
01-06 21:26:16,5.717,1.597,69.357,23.245,0.0,0.084,17.280,8.790,5.430,13984169984.0,851968.0,22241280.0,17530146816.0,25586346.667,5461.333,1562.0,1.0,263.333,486.0
01-06 21:26:19,6.185,1.672,71.375,20.685,0.0,0.084,17.330,8.950,5.500,14061879296.0,868352.0,22237184.0,17452425216.0,25635498.667,10922.667,1564.333,2.0,735.667,525.333
01-06 21:26:22,6.402,1.506,70.167,21.799,0.0,0.126,17.330,8.950,5.500,14141939712.0,876544.0,22241280.0,17372352512.0,26121557.333,5461.333,1594.667,1.0,455.333,491.333
01-06 21:26:25,6.334,1.678,67.743,24.119,0.0,0.126,17.390,9.100,5.570,14217502720.0,892928.0,22241280.0,17296773120.0,26389162.667,10922.667,1610.333,2.0,91.333,491.333
01-06 21:26:28,6.365,1.508,69.598,22.446,0.0,0.084,17.390,9.100,5.570,14299537408.0,901120.0,22241280.0,17214730240.0,25804800.0,5461.333,1575.0,1.0,967.0,491.333
01-06 21:26:31,6.379,1.637,69.031,22.828,0.042,0.084,17.440,9.240,5.630,14379335680.0,925696.0,22228992.0,17134919680.0,26471082.667,16384.0,1615.667,3.0,313.333,491.333
01-06 21:26:34,6.247,1.677,67.463,24.528,0.0,0.084,17.560,9.400,5.710,14457044992.0,933888.0,22233088.0,17057198080.0,26170709.333,5461.333,1597.667,1.0,155.333,480.667
01-06 21:26:37,6.491,1.633,69.472,22.320,0.0,0.084,17.560,9.400,5.710,14532775936.0,950272.0,22228992.0,16981454848.0,26159786.667,10922.667,1597.0,2.333,423.333,486.0
01-06 21:26:40,6.541,1.593,67.883,23.857,0.0,0.126,17.600,9.550,5.770,14612582400.0,958464.0,22233088.0,16901636096.0,26356394.667,5461.333,1609.0,1.0,519.0,480.667
01-06 21:26:43,6.462,1.595,69.073,22.786,0.0,0.084,17.600,9.550,5.770,14692503552.0,974848.0,22241280.0,16821690368.0,26192554.667,12288.0,1598.667,2.667,112.667,491.333
01-06 21:26:46,6.494,1.801,67.910,23.712,0.0,0.084,17.630,9.690,5.840,14772330496.0,983040.0,22241280.0,16741855232.0,25733802.667,5461.333,1570.0,1.0,562.0,486.0
01-06 21:26:49,6.315,1.798,68.089,23.630,0.042,0.125,17.740,9.840,5.910,14847942656.0,999424.0,22237184.0,16666230784.0,26006869.333,12288.0,1587.667,2.0,237.667,731.333
01-06 21:26:52,6.287,1.676,67.225,24.728,0.0,0.084,17.740,9.840,5.910,14923800576.0,1007616.0,22241280.0,16590360576.0,25089365.333,5461.333,1530.667,1.0,112.667,491.333
01-06 21:26:55,6.787,1.843,68.161,23.125,0.0,0.084,18.0,10.030,5.990,15003602944.0,1032192.0,22233088.0,16510541824.0,26170709.333,16384.0,1597.333,3.0,155.333,491.333
01-06 21:26:58,6.622,1.844,67.770,23.638,0.042,0.084,18.0,10.030,5.990,15079084032.0,1040384.0,22233088.0,16435052544.0,26137941.333,5461.333,1596.0,1.0,270.667,480.667
01-06 21:27:01,6.504,1.721,67.940,23.752,0.0,0.084,18.080,10.180,6.060,15159144448.0,1056768.0,22228992.0,16354979840.0,25935872.0,10922.667,1582.333,2.0,155.333,480.667
01-06 21:27:04,7.047,1.846,65.478,25.545,0.0,0.084,18.070,10.310,6.120,15236857856.0,1064960.0,22245376.0,16277241856.0,26170709.333,5461.333,1597.667,1.0,407.667,520.0
01-06 21:27:07,6.933,1.555,68.361,23.025,0.0,0.126,18.070,10.310,6.120,15318761472.0,1081344.0,22241280.0,16195325952.0,26258090.667,10922.667,1602.667,2.0,1831.667,1852.667
01-06 21:27:10,6.996,1.676,66.946,24.256,0.042,0.084,18.150,10.450,6.190,15396470784.0,1089536.0,22245376.0,16117604352.0,26416469.333,5461.333,1612.0,1.0,346.667,674.667
01-06 21:27:13,7.044,1.761,66.247,24.864,0.0,0.084,18.150,10.450,6.190,15472394240.0,1114112.0,22233088.0,16041668608.0,26105173.333,19114.667,1594.0,3.333,236.0,491.333
01-06 21:27:16,7.131,1.846,64.513,26.384,0.0,0.126,18.130,10.570,6.250,15554281472.0,1122304.0,22245376.0,15959760896.0,26602154.667,6826.667,1623.667,1.333,112.667,507.333
01-06 21:27:19,7.409,1.632,66.095,24.822,0.0,0.042,18.200,10.710,6.320,15636439040.0,1138688.0,22241280.0,15877591040.0,26039637.333,10922.667,1588.667,2.0,112.667,486.0

## my.cnf
[mysqld_multi]
mysqld=/usr/bin/mysqld_safe
mysqladmin=/usr/bin/mysqladmin
log=/var/log/mysql/mysqld_multi.log


[mysqld]
user=mysql
character-set-server=utf8
long_query_time=1
log-bin=mysqld-bin

skip-character-set-client-handshake
skip-name-resolve

sync-binlog=1

relay-log=relay-bin.nnnnnn
relay_log_purge=0
#relay_log_info_repository=TABLE
relay_log_recovery=ON

event_scheduler=on

slow_query_log

innodb_file_per_table

key_buffer_size                = 128M
max_allowed_packet             = 1M
table_open_cache               = 1024
sort_buffer_size               = 2M
net_buffer_length              = 8K
read_buffer_size               = 2M
read_rnd_buffer_size           = 8M
myisam_sort_buffer_size        = 16M
query_cache_size               = 128M
thread_cache_size              = 100
max_connections                = 400

binlog_format                  = mixed
expire_logs_days               = 2

# innodb
innodb_buffer_pool_size        = 5120M
innodb_log_file_size           = 256M
innodb_log_buffer_size         = 16M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout       = 5
innodb_file_format             = Barracuda
innodb_flush_method            = O_DIRECT
innodb_read_io_threads         = 4
innodb_write_io_threads        = 4


[mysqld1]
server-id=1
socket=/fio1/mysql/mysql.sock
pid-file=/fio1/mysql/mysql.pid
datadir=/fio1/mysql/
tmpdir=/fio1/tmp/
port=3310
slow_query_log_file=/fio1/mysql/slow.log
log-error=/fio1/mysql/mysql.log
innodb_log_group_home_dir=/hdd1/fio1logs/
innodb_data_home_dir=/hdd1/fio1logs/

[mysqld2]
server-id=2
socket=/fio2/mysql/mysql.sock
pid-file=/fio2/mysql/mysql.pid
datadir=/fio2/mysql/
tmpdir=/fio2/tmp/
port=3320
slow_query_log_file=/fio2/mysql/slow.log
log-error=/fio2/mysql/mysql.log
innodb_log_group_home_dir=/hdd2/fio2logs/
innodb_data_home_dir=/hdd2/fio2logs/

[mysqld3]
server-id=3
socket=/hdd1/mysql/mysql.sock
pid-file=/hdd1/mysql/mysql.pid
datadir=/hdd1/mysql/
tmpdir=/hdd1/tmp/
port=3330
slow_query_log_file=/hdd1/mysql/slow.log
log-error=/hdd1/mysql/mysql.log
innodb_log_group_home_dir=/fio1/hdd1logs/
innodb_data_home_dir=/fio1/hdd1logs/

[mysqld4]
server-id=4
socket=/hdd2/mysql/mysql.sock
pid-file=/hdd2/mysql/mysql.pid
datadir=/hdd2/mysql/
tmpdir=/hdd2/tmp/
port=3340
slow_query_log_file=/hdd2/mysql/slow.log
log-error=/hdd2/mysql/mysql.log
innodb_log_group_home_dir=/fio1/hdd2logs/
innodb_data_home_dir=/fio1/hdd2logs/

## result.txt
########################################################################################################
### 20140601212331 fio1
########################################################################################################
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16
Initializing random number generator from timer.


Doing OLTP test.
Running mixed OLTP test
Doing read-only test
Using Uniform distribution
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           0
        other:                           20000
        total:                           160000
    transactions:                        10000  (1258.84 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (17623.73 per sec.)
    other operations:                    20000  (2517.68 per sec.)

Test execution summary:
    total time:                          7.9438s
    total number of events:              10000
    total time taken by event execution: 126.9856
    per-request statistics:
         min:                                  5.33ms
         avg:                                 12.70ms
         max:                                133.15ms
         approx.  95 percentile:              18.50ms

Threads fairness:
    events (avg/stddev):           625.0000/8.47
    execution time (avg/stddev):   7.9366/0.00

########################################################################################################
### 20140601212340 fio2
########################################################################################################
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16
Initializing random number generator from timer.


Doing OLTP test.
Running mixed OLTP test
Doing read-only test
Using Uniform distribution
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           0
        other:                           20000
        total:                           160000
    transactions:                        10000  (1364.46 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (19102.39 per sec.)
    other operations:                    20000  (2728.91 per sec.)

Test execution summary:
    total time:                          7.3289s
    total number of events:              10000
    total time taken by event execution: 117.1344
    per-request statistics:
         min:                                  5.89ms
         avg:                                 11.71ms
         max:                                126.65ms
         approx.  95 percentile:              20.53ms

Threads fairness:
    events (avg/stddev):           625.0000/24.18
    execution time (avg/stddev):   7.3209/0.00

########################################################################################################
### 20140601212348 hdd1
########################################################################################################
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16
Initializing random number generator from timer.


Doing OLTP test.
Running mixed OLTP test
Doing read-only test
Using Uniform distribution
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           0
        other:                           20000
        total:                           160000
    transactions:                        10000  (97.73 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (1368.18 per sec.)
    other operations:                    20000  (195.45 per sec.)

Test execution summary:
    total time:                          102.3260s
    total number of events:              10000
    total time taken by event execution: 1636.2561
    per-request statistics:
         min:                                 41.01ms
         avg:                                163.63ms
         max:                                530.99ms
         approx.  95 percentile:             241.62ms

Threads fairness:
    events (avg/stddev):           625.0000/7.88
    execution time (avg/stddev):   102.2660/0.03

########################################################################################################
### 20140601212531 hdd2
########################################################################################################
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16
Initializing random number generator from timer.


Doing OLTP test.
Running mixed OLTP test
Doing read-only test
Using Uniform distribution
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           0
        other:                           20000
        total:                           160000
    transactions:                        10000  (92.05 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (1288.64 per sec.)
    other operations:                    20000  (184.09 per sec.)

Test execution summary:
    total time:                          108.6415s
    total number of events:              10000
    total time taken by event execution: 1737.5062
    per-request statistics:
         min:                                 47.67ms
         avg:                                173.75ms
         max:                                650.35ms
         approx.  95 percentile:             257.91ms

Threads fairness:
    events (avg/stddev):           625.0000/4.92
    execution time (avg/stddev):   108.5941/0.03

## sysbench_benchmark.sh
#!/bin/bash

rm -f result/*

DSTAT_LOG="result/dstat_sysbench.csv"

dstat -tclmdrn --output $DSTAT_LOG 3 &
PID=`echo $!`

for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
	SYSBENCH_LOG="result/${DIR}_sysbench.log"

	sync
	echo 3 >  /proc/sys/vm/drop_caches
	sync

	echo "########################################################################################################" >> $SYSBENCH_LOG
	echo "### `date '+%Y%m%d%H%M%S'` ${DIR}"                                                                        >> $SYSBENCH_LOG
	echo "########################################################################################################" >> $SYSBENCH_LOG

	sysbench \
	--test=oltp \
	--db-driver=mysql \
	--oltp-table-size=50000000 \
	--mysql-socket=/${DIR}/mysql/mysql.sock \
	--mysql-user=sbtestuser \
	--mysql-password=sbtestpass \
	--init-rng=on --oltp-read-only=on --oltp-dist-type=uniform \
	--num-threads=16 --max-time=180 --oltp-test-mode=complex \
	run >> $SYSBENCH_LOG

	echo ""
done

kill $PID
	"Dstat 0.7.0 CSV output"
	"Author:","Dag Wieers <dag@wieers.com>",,,,"URL:","http://dag.wieers.com/home-made/dstat/"
	"Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root"
	"Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:23:31 JST"

	"system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total",
	"date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send"
	01-06 21:23:31,1.431,0.480,97.839,0.232,0.003,0.015,1.850,1.910,2.980,4276502528.0,1417216.0,608673792.0,26650816512.0,387455.559,3407668.729,25.536,220.067,0.0,0.0
	01-06 21:23:34,47.029,14.226,23.096,14.393,0.544,0.711,2.740,2.100,3.040,5044092928.0,3162112.0,25317376.0,26464837632.0,261320704.0,30037.333,15849.0,7.333,380.0,799.333
	01-06 21:23:37,69.153,19.866,1.593,7.795,0.796,0.796,2.740,2.100,3.040,6165258240.0,3346432.0,26124288.0,25342681088.0,375156736.0,25941.333,22900.667,5.0,978.0,936.0
	01-06 21:23:40,61.744,16.437,12.891,7.551,0.709,0.668,4.120,2.400,3.130,7095103488.0,417792.0,21508096.0,24420380672.0,310879573.333,38912.0,18909.333,9.667,1162.0,1570.667
	01-06 21:23:43,69.022,18.896,2.258,8.152,0.794,0.878,4.120,2.400,3.130,8245813248.0,909312.0,23552000.0,23267135488.0,381487786.667,29696.0,23246.667,5.667,940.667,963.333
	01-06 21:23:46,73.292,19.417,0.583,4.792,0.917,1.0,5.070,2.620,3.200,9423802368.0,2220032.0,25657344.0,22085730304.0,392201557.333,20138.667,23916.0,3.0,783.333,2900.0
	01-06 21:23:49,36.055,9.631,42.923,10.553,0.377,0.461,6.110,2.880,3.270,9973288960.0,1527808.0,23822336.0,21538770944.0,183376554.667,47957.333,11121.0,11.0,175.333,554.0
	01-06 21:23:52,5.579,1.426,71.225,21.728,0.0,0.042,6.110,2.880,3.270,10055286784.0,1540096.0,23830528.0,21456752640.0,26174805.333,7168.0,1598.333,1.667,228.0,491.333
	01-06 21:23:55,5.983,1.715,69.623,22.510,0.0,0.167,6.980,3.110,3.350,10135715840.0,1732608.0,24432640.0,21375528960.0,27443200.0,19114.667,1672.333,3.0,828.667,963.333
	01-06 21:23:58,6.040,1.678,71.351,20.847,0.0,0.084,6.980,3.110,3.350,10215645184.0,1740800.0,24432640.0,21295591424.0,27967488.0,5461.333,1706.667,1.0,1403.0,1015.333
	01-06 21:24:01,6.195,1.758,71.201,20.720,0.042,0.084,7.860,3.360,3.430,10303709184.0,1757184.0,24432640.0,21207511040.0,27787264.0,21845.333,1696.333,2.333,689.333,648.667
	01-06 21:24:04,6.143,1.880,68.742,23.109,0.0,0.125,8.590,3.580,3.500,10398318592.0,1896448.0,25018368.0,21112176640.0,27462314.667,5632.0,1668.0,1.333,1062.0,2131.333
	01-06 21:24:07,6.190,1.715,69.176,22.794,0.0,0.125,8.590,3.580,3.500,10480734208.0,1912832.0,25026560.0,21029736448.0,27181056.0,10922.667,1660.0,2.0,1972.333,2023.333
	01-06 21:24:10,6.087,1.595,70.613,21.620,0.0,0.084,9.270,3.810,3.570,10566832128.0,1921024.0,25030656.0,20943626240.0,27585194.667,5461.333,1683.0,1.0,978.0,502.0
	01-06 21:24:13,6.483,1.798,69.302,22.292,0.0,0.125,9.270,3.810,3.570,10661253120.0,1937408.0,25022464.0,20849197056.0,27989333.333,10922.667,1708.667,2.0,601.667,480.667
	01-06 21:24:16,6.444,1.715,67.238,24.435,0.042,0.126,9.890,4.020,3.640,10743136256.0,1945600.0,25030656.0,20767297536.0,28065792.0,5461.333,1713.0,1.0,270.667,480.667
	01-06 21:24:19,6.158,1.843,69.753,22.162,0.0,0.084,10.690,4.290,3.730,10829365248.0,1961984.0,25022464.0,20681060352.0,27514197.333,14165.333,1679.333,3.0,317.333,520.0
	01-06 21:24:22,6.423,1.553,69.018,22.880,0.0,0.126,10.690,4.290,3.730,10911137792.0,1970176.0,25030656.0,20599271424.0,27694421.333,5461.333,1690.0,1.0,236.0,486.0
	01-06 21:24:25,6.410,1.969,69.376,22.162,0.0,0.084,11.360,4.530,3.810,10994384896.0,1990656.0,25030656.0,20516003840.0,27810474.667,17749.333,1698.333,2.667,577.333,491.333
	01-06 21:24:28,6.379,1.511,69.912,22.115,0.0,0.084,11.360,4.530,3.810,11078516736.0,1998848.0,25030656.0,20431863808.0,27290282.667,19114.667,1664.667,3.667,249.333,486.0
	01-06 21:24:31,6.488,1.716,71.411,20.343,0.0,0.042,11.970,4.770,3.890,11160420352.0,2015232.0,25026560.0,20349947904.0,27159210.667,15018.667,1658.0,2.0,91.333,491.333
	01-06 21:24:34,6.549,1.679,69.060,22.586,0.0,0.126,12.450,4.990,3.970,11246514176.0,2023424.0,25030656.0,20263841792.0,28158634.667,5461.333,1718.333,1.0,155.333,491.333
	01-06 21:24:37,6.583,1.677,66.373,25.283,0.0,0.084,12.450,4.990,3.970,11324080128.0,2048000.0,25026560.0,20186255360.0,27579733.333,16384.0,1684.0,3.0,316.667,491.333
	01-06 21:24:40,6.502,1.762,66.946,24.622,0.042,0.126,12.980,5.230,4.050,11408084992.0,2056192.0,25026560.0,20102242304.0,27858261.333,5461.333,1700.0,1.0,466.667,480.667
	01-06 21:24:43,6.669,1.804,68.247,23.154,0.0,0.126,12.980,5.230,4.050,11492212736.0,2072576.0,25022464.0,20018102272.0,27628885.333,9557.333,1686.0,2.0,343.333,480.667
	01-06 21:24:46,6.751,1.803,67.463,23.857,0.0,0.126,13.300,5.420,4.120,11574247424.0,2084864.0,25034752.0,19936043008.0,27821397.333,5461.333,1698.667,1.0,511.333,486.0
	01-06 21:24:49,6.832,1.718,69.824,21.542,0.0,0.084,13.680,5.630,4.190,11658248192.0,2101248.0,25030656.0,19852029952.0,27792725.333,11434.667,1696.0,2.667,262.0,486.0
	01-06 21:24:52,6.410,1.676,70.172,21.575,0.042,0.126,13.680,5.630,4.190,11742367744.0,2109440.0,25034752.0,19767898112.0,26569386.667,5461.333,1621.667,1.0,529.667,491.333
	01-06 21:24:55,6.812,1.598,66.905,24.558,0.0,0.126,14.020,5.830,4.270,11824394240.0,2134016.0,25026560.0,19685855232.0,28147712.0,15018.667,1718.0,3.0,249.333,491.333
	01-06 21:24:58,7.158,1.758,66.471,24.487,0.0,0.126,14.020,5.830,4.270,11908390912.0,2142208.0,25026560.0,19601850368.0,27830954.667,8192.0,1699.0,1.667,208.667,480.667
	01-06 21:25:01,6.885,1.805,67.338,23.887,0.0,0.084,14.420,6.050,4.350,11992379392.0,2158592.0,25034752.0,19517837312.0,27803648.0,13653.333,1697.333,2.0,240.667,486.0
	01-06 21:25:04,6.795,2.097,67.743,23.238,0.0,0.126,14.710,6.250,4.420,12076511232.0,2166784.0,25034752.0,19433697280.0,27738112.0,12288.0,1692.667,2.667,410.667,520.0
	01-06 21:25:07,7.089,1.846,67.156,23.784,0.042,0.084,14.710,6.250,4.420,12158554112.0,2183168.0,25034752.0,19351638016.0,28076714.667,10922.667,1714.0,2.0,1833.667,1911.333
	01-06 21:25:10,7.128,1.803,66.918,24.067,0.0,0.084,14.970,6.450,4.490,12244656128.0,2199552.0,25026560.0,19265527808.0,27716266.667,10922.667,1691.333,2.0,488.0,512.667
	01-06 21:25:13,7.167,1.928,66.387,24.392,0.0,0.126,14.970,6.450,4.490,12326551552.0,2215936.0,25022464.0,19183620096.0,27809109.333,10922.667,1697.667,2.0,408.0,480.667
	01-06 21:25:16,7.215,1.804,65.688,25.210,0.0,0.084,15.130,6.620,4.560,12410662912.0,2224128.0,25034752.0,19099488256.0,27590656.0,5461.333,1683.333,1.0,206.667,486.0
	01-06 21:25:19,7.179,1.847,66.331,24.559,0.0,0.084,15.360,6.810,4.630,12492566528.0,2240512.0,25030656.0,19017572352.0,27721728.0,11434.667,1692.333,2.667,206.667,491.333
	01-06 21:25:22,7.314,1.807,66.583,24.212,0.0,0.084,15.360,6.810,4.630,12576567296.0,2256896.0,25026560.0,18933559296.0,27650730.667,10922.667,1687.333,2.0,257.333,491.333
	01-06 21:25:25,7.341,1.971,64.681,25.839,0.042,0.126,15.650,7.010,4.710,12658601984.0,2273280.0,25034752.0,18851500032.0,27667114.667,10922.667,1688.667,2.0,112.667,486.0
	01-06 21:25:28,7.415,1.969,65.982,24.550,0.0,0.084,15.650,7.010,4.710,12744704000.0,2281472.0,25034752.0,18765389824.0,27601578.667,6826.667,1684.667,1.333,548.0,491.333
	01-06 21:25:31,5.747,1.636,70.889,21.602,0.0,0.126,15.920,7.210,4.790,12810342400.0,647168.0,22036480.0,18704384000.0,23704917.333,29354.667,1397.0,6.667,198.0,491.333
	01-06 21:25:34,4.987,1.467,70.662,22.842,0.0,0.042,16.250,7.420,4.870,12888330240.0,675840.0,22216704.0,18626187264.0,25781589.333,24576.0,1574.667,3.0,300.0,564.667
	01-06 21:25:37,5.737,1.508,70.059,22.613,0.0,0.084,16.250,7.420,4.870,12968116224.0,696320.0,22220800.0,18546376704.0,25993216.0,17749.333,1587.0,2.333,338.0,491.333
	01-06 21:25:40,5.581,1.469,70.080,22.786,0.0,0.084,16.470,7.610,4.940,13043732480.0,704512.0,22220800.0,18470752256.0,25985024.0,5461.333,1586.0,1.0,372.667,491.333
	01-06 21:25:43,5.537,1.468,71.141,21.812,0.0,0.042,16.470,7.610,4.940,13123407872.0,720896.0,22220800.0,18391060480.0,26083328.0,10922.667,1592.333,2.0,364.667,486.0
	01-06 21:25:46,5.668,1.679,67.884,24.601,0.042,0.126,16.670,7.800,5.020,13203857408.0,729088.0,22233088.0,18310590464.0,26169344.0,5461.333,1598.333,1.0,193.333,486.0
	01-06 21:25:49,5.860,1.465,71.243,21.348,0.0,0.084,16.700,7.950,5.080,13283786752.0,745472.0,22233088.0,18230644736.0,25859413.333,12288.0,1578.333,2.0,112.667,486.0
	01-06 21:25:52,5.700,1.467,70.327,22.422,0.0,0.084,16.700,7.950,5.080,13357166592.0,753664.0,22237184.0,18157252608.0,25236821.333,5461.333,1539.667,1.0,313.333,486.0
	01-06 21:25:55,5.702,1.426,69.937,22.851,0.0,0.084,16.800,8.120,5.150,13432774656.0,770048.0,22237184.0,18081628160.0,25351509.333,9557.333,1547.667,2.0,374.667,486.0
	01-06 21:25:58,5.961,1.469,70.193,22.292,0.0,0.084,16.800,8.120,5.150,13512704000.0,778240.0,22237184.0,18001690624.0,26525696.0,5461.333,1618.333,1.0,91.333,486.0
	01-06 21:26:01,6.006,1.512,69.551,22.848,0.0,0.084,16.900,8.290,5.220,13594730496.0,794624.0,22237184.0,17919647744.0,26624000.0,9557.333,1625.0,2.0,435.333,509.333
	01-06 21:26:04,6.310,1.630,68.199,23.778,0.0,0.084,17.140,8.480,5.300,13670936576.0,802816.0,22237184.0,17843433472.0,25948160.0,5461.333,1584.0,1.0,318.333,486.0
	01-06 21:26:07,5.959,1.469,68.653,23.836,0.0,0.084,17.140,8.480,5.300,13750996992.0,819200.0,22233088.0,17763360768.0,25930410.667,19114.667,1583.0,3.0,2168.333,1986.0
	01-06 21:26:10,6.187,1.672,70.109,21.865,0.042,0.125,17.210,8.640,5.370,13833150464.0,827392.0,22241280.0,17681190912.0,26132480.0,5461.333,1596.0,1.0,428.0,507.333
	01-06 21:26:13,6.156,1.675,70.436,21.650,0.0,0.084,17.210,8.640,5.370,13906718720.0,843776.0,22241280.0,17607606272.0,26290858.667,19114.667,1603.333,4.0,332.0,491.333
	01-06 21:26:16,5.717,1.597,69.357,23.245,0.0,0.084,17.280,8.790,5.430,13984169984.0,851968.0,22241280.0,17530146816.0,25586346.667,5461.333,1562.0,1.0,263.333,486.0
	01-06 21:26:19,6.185,1.672,71.375,20.685,0.0,0.084,17.330,8.950,5.500,14061879296.0,868352.0,22237184.0,17452425216.0,25635498.667,10922.667,1564.333,2.0,735.667,525.333
	01-06 21:26:22,6.402,1.506,70.167,21.799,0.0,0.126,17.330,8.950,5.500,14141939712.0,876544.0,22241280.0,17372352512.0,26121557.333,5461.333,1594.667,1.0,455.333,491.333
	01-06 21:26:25,6.334,1.678,67.743,24.119,0.0,0.126,17.390,9.100,5.570,14217502720.0,892928.0,22241280.0,17296773120.0,26389162.667,10922.667,1610.333,2.0,91.333,491.333
	01-06 21:26:28,6.365,1.508,69.598,22.446,0.0,0.084,17.390,9.100,5.570,14299537408.0,901120.0,22241280.0,17214730240.0,25804800.0,5461.333,1575.0,1.0,967.0,491.333
	01-06 21:26:31,6.379,1.637,69.031,22.828,0.042,0.084,17.440,9.240,5.630,14379335680.0,925696.0,22228992.0,17134919680.0,26471082.667,16384.0,1615.667,3.0,313.333,491.333
	01-06 21:26:34,6.247,1.677,67.463,24.528,0.0,0.084,17.560,9.400,5.710,14457044992.0,933888.0,22233088.0,17057198080.0,26170709.333,5461.333,1597.667,1.0,155.333,480.667
	01-06 21:26:37,6.491,1.633,69.472,22.320,0.0,0.084,17.560,9.400,5.710,14532775936.0,950272.0,22228992.0,16981454848.0,26159786.667,10922.667,1597.0,2.333,423.333,486.0
	01-06 21:26:40,6.541,1.593,67.883,23.857,0.0,0.126,17.600,9.550,5.770,14612582400.0,958464.0,22233088.0,16901636096.0,26356394.667,5461.333,1609.0,1.0,519.0,480.667
	01-06 21:26:43,6.462,1.595,69.073,22.786,0.0,0.084,17.600,9.550,5.770,14692503552.0,974848.0,22241280.0,16821690368.0,26192554.667,12288.0,1598.667,2.667,112.667,491.333
	01-06 21:26:46,6.494,1.801,67.910,23.712,0.0,0.084,17.630,9.690,5.840,14772330496.0,983040.0,22241280.0,16741855232.0,25733802.667,5461.333,1570.0,1.0,562.0,486.0
	01-06 21:26:49,6.315,1.798,68.089,23.630,0.042,0.125,17.740,9.840,5.910,14847942656.0,999424.0,22237184.0,16666230784.0,26006869.333,12288.0,1587.667,2.0,237.667,731.333
	01-06 21:26:52,6.287,1.676,67.225,24.728,0.0,0.084,17.740,9.840,5.910,14923800576.0,1007616.0,22241280.0,16590360576.0,25089365.333,5461.333,1530.667,1.0,112.667,491.333
	01-06 21:26:55,6.787,1.843,68.161,23.125,0.0,0.084,18.0,10.030,5.990,15003602944.0,1032192.0,22233088.0,16510541824.0,26170709.333,16384.0,1597.333,3.0,155.333,491.333
	01-06 21:26:58,6.622,1.844,67.770,23.638,0.042,0.084,18.0,10.030,5.990,15079084032.0,1040384.0,22233088.0,16435052544.0,26137941.333,5461.333,1596.0,1.0,270.667,480.667
	01-06 21:27:01,6.504,1.721,67.940,23.752,0.0,0.084,18.080,10.180,6.060,15159144448.0,1056768.0,22228992.0,16354979840.0,25935872.0,10922.667,1582.333,2.0,155.333,480.667
	01-06 21:27:04,7.047,1.846,65.478,25.545,0.0,0.084,18.070,10.310,6.120,15236857856.0,1064960.0,22245376.0,16277241856.0,26170709.333,5461.333,1597.667,1.0,407.667,520.0
	01-06 21:27:07,6.933,1.555,68.361,23.025,0.0,0.126,18.070,10.310,6.120,15318761472.0,1081344.0,22241280.0,16195325952.0,26258090.667,10922.667,1602.667,2.0,1831.667,1852.667
	01-06 21:27:10,6.996,1.676,66.946,24.256,0.042,0.084,18.150,10.450,6.190,15396470784.0,1089536.0,22245376.0,16117604352.0,26416469.333,5461.333,1612.0,1.0,346.667,674.667
	01-06 21:27:13,7.044,1.761,66.247,24.864,0.0,0.084,18.150,10.450,6.190,15472394240.0,1114112.0,22233088.0,16041668608.0,26105173.333,19114.667,1594.0,3.333,236.0,491.333
	01-06 21:27:16,7.131,1.846,64.513,26.384,0.0,0.126,18.130,10.570,6.250,15554281472.0,1122304.0,22245376.0,15959760896.0,26602154.667,6826.667,1623.667,1.333,112.667,507.333
	01-06 21:27:19,7.409,1.632,66.095,24.822,0.0,0.042,18.200,10.710,6.320,15636439040.0,1138688.0,22241280.0,15877591040.0,26039637.333,10922.667,1588.667,2.0,112.667,486.0
	[mysqld_multi]
	mysqld=/usr/bin/mysqld_safe
	mysqladmin=/usr/bin/mysqladmin
	log=/var/log/mysql/mysqld_multi.log


	[mysqld]
	user=mysql
	character-set-server=utf8
	long_query_time=1
	log-bin=mysqld-bin

	skip-character-set-client-handshake
	skip-name-resolve

	sync-binlog=1

	relay-log=relay-bin.nnnnnn
	relay_log_purge=0
	#relay_log_info_repository=TABLE
	relay_log_recovery=ON

	event_scheduler=on

	slow_query_log

	innodb_file_per_table

	key_buffer_size = 128M
	max_allowed_packet = 1M
	table_open_cache = 1024
	sort_buffer_size = 2M
	net_buffer_length = 8K
	read_buffer_size = 2M
	read_rnd_buffer_size = 8M
	myisam_sort_buffer_size = 16M
	query_cache_size = 128M
	thread_cache_size = 100
	max_connections = 400

	binlog_format = mixed
	expire_logs_days = 2

	# innodb
	innodb_buffer_pool_size = 5120M
	innodb_log_file_size = 256M
	innodb_log_buffer_size = 16M
	innodb_flush_log_at_trx_commit = 1
	innodb_lock_wait_timeout = 5
	innodb_file_format = Barracuda
	innodb_flush_method = O_DIRECT
	innodb_read_io_threads = 4
	innodb_write_io_threads = 4


	[mysqld1]
	server-id=1
	socket=/fio1/mysql/mysql.sock
	pid-file=/fio1/mysql/mysql.pid
	datadir=/fio1/mysql/
	tmpdir=/fio1/tmp/
	port=3310
	slow_query_log_file=/fio1/mysql/slow.log
	log-error=/fio1/mysql/mysql.log
	innodb_log_group_home_dir=/hdd1/fio1logs/
	innodb_data_home_dir=/hdd1/fio1logs/

	[mysqld2]
	server-id=2
	socket=/fio2/mysql/mysql.sock
	pid-file=/fio2/mysql/mysql.pid
	datadir=/fio2/mysql/
	tmpdir=/fio2/tmp/
	port=3320
	slow_query_log_file=/fio2/mysql/slow.log
	log-error=/fio2/mysql/mysql.log
	innodb_log_group_home_dir=/hdd2/fio2logs/
	innodb_data_home_dir=/hdd2/fio2logs/

	[mysqld3]
	server-id=3
	socket=/hdd1/mysql/mysql.sock
	pid-file=/hdd1/mysql/mysql.pid
	datadir=/hdd1/mysql/
	tmpdir=/hdd1/tmp/
	port=3330
	slow_query_log_file=/hdd1/mysql/slow.log
	log-error=/hdd1/mysql/mysql.log
	innodb_log_group_home_dir=/fio1/hdd1logs/
	innodb_data_home_dir=/fio1/hdd1logs/

	[mysqld4]
	server-id=4
	socket=/hdd2/mysql/mysql.sock
	pid-file=/hdd2/mysql/mysql.pid
	datadir=/hdd2/mysql/
	tmpdir=/hdd2/tmp/
	port=3340
	slow_query_log_file=/hdd2/mysql/slow.log
	log-error=/hdd2/mysql/mysql.log
	innodb_log_group_home_dir=/fio1/hdd2logs/
	innodb_data_home_dir=/fio1/hdd2logs/
	########################################################################################################
	### 20140601212331 fio1
	########################################################################################################
	sysbench 0.4.12: multi-threaded system evaluation benchmark

	Running the test with following options:
	Number of threads: 16
	Initializing random number generator from timer.


	Doing OLTP test.
	Running mixed OLTP test
	Doing read-only test
	Using Uniform distribution
	Using "BEGIN" for starting transactions
	Using auto_inc on the id column
	Maximum number of requests for OLTP test is limited to 10000
	Threads started!
	Done.

	OLTP test statistics:
	queries performed:
	read: 140000
	write: 0
	other: 20000
	total: 160000
	transactions: 10000 (1258.84 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (17623.73 per sec.)
	other operations: 20000 (2517.68 per sec.)

	Test execution summary:
	total time: 7.9438s
	total number of events: 10000
	total time taken by event execution: 126.9856
	per-request statistics:
	min: 5.33ms
	avg: 12.70ms
	max: 133.15ms
	approx. 95 percentile: 18.50ms

	Threads fairness:
	events (avg/stddev): 625.0000/8.47
	execution time (avg/stddev): 7.9366/0.00

	########################################################################################################
	### 20140601212340 fio2
	########################################################################################################
	sysbench 0.4.12: multi-threaded system evaluation benchmark

	Running the test with following options:
	Number of threads: 16
	Initializing random number generator from timer.


	Doing OLTP test.
	Running mixed OLTP test
	Doing read-only test
	Using Uniform distribution
	Using "BEGIN" for starting transactions
	Using auto_inc on the id column
	Maximum number of requests for OLTP test is limited to 10000
	Threads started!
	Done.

	OLTP test statistics:
	queries performed:
	read: 140000
	write: 0
	other: 20000
	total: 160000
	transactions: 10000 (1364.46 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (19102.39 per sec.)
	other operations: 20000 (2728.91 per sec.)

	Test execution summary:
	total time: 7.3289s
	total number of events: 10000
	total time taken by event execution: 117.1344
	per-request statistics:
	min: 5.89ms
	avg: 11.71ms
	max: 126.65ms
	approx. 95 percentile: 20.53ms

	Threads fairness:
	events (avg/stddev): 625.0000/24.18
	execution time (avg/stddev): 7.3209/0.00

	########################################################################################################
	### 20140601212348 hdd1
	########################################################################################################
	sysbench 0.4.12: multi-threaded system evaluation benchmark

	Running the test with following options:
	Number of threads: 16
	Initializing random number generator from timer.


	Doing OLTP test.
	Running mixed OLTP test
	Doing read-only test
	Using Uniform distribution
	Using "BEGIN" for starting transactions
	Using auto_inc on the id column
	Maximum number of requests for OLTP test is limited to 10000
	Threads started!
	Done.

	OLTP test statistics:
	queries performed:
	read: 140000
	write: 0
	other: 20000
	total: 160000
	transactions: 10000 (97.73 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (1368.18 per sec.)
	other operations: 20000 (195.45 per sec.)

	Test execution summary:
	total time: 102.3260s
	total number of events: 10000
	total time taken by event execution: 1636.2561
	per-request statistics:
	min: 41.01ms
	avg: 163.63ms
	max: 530.99ms
	approx. 95 percentile: 241.62ms

	Threads fairness:
	events (avg/stddev): 625.0000/7.88
	execution time (avg/stddev): 102.2660/0.03

	########################################################################################################
	### 20140601212531 hdd2
	########################################################################################################
	sysbench 0.4.12: multi-threaded system evaluation benchmark

	Running the test with following options:
	Number of threads: 16
	Initializing random number generator from timer.


	Doing OLTP test.
	Running mixed OLTP test
	Doing read-only test
	Using Uniform distribution
	Using "BEGIN" for starting transactions
	Using auto_inc on the id column
	Maximum number of requests for OLTP test is limited to 10000
	Threads started!
	Done.

	OLTP test statistics:
	queries performed:
	read: 140000
	write: 0
	other: 20000
	total: 160000
	transactions: 10000 (92.05 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (1288.64 per sec.)
	other operations: 20000 (184.09 per sec.)

	Test execution summary:
	total time: 108.6415s
	total number of events: 10000
	total time taken by event execution: 1737.5062
	per-request statistics:
	min: 47.67ms
	avg: 173.75ms
	max: 650.35ms
	approx. 95 percentile: 257.91ms

	Threads fairness:
	events (avg/stddev): 625.0000/4.92
	execution time (avg/stddev): 108.5941/0.03
	#!/bin/bash

	rm -f result/*

	DSTAT_LOG="result/dstat_sysbench.csv"

	dstat -tclmdrn --output $DSTAT_LOG 3 &
	PID=`echo $!`

	for DIR in "fio1" "fio2" "hdd1" "hdd2"
	do
	SYSBENCH_LOG="result/${DIR}_sysbench.log"

	sync
	echo 3 > /proc/sys/vm/drop_caches
	sync

	echo "########################################################################################################" >> $SYSBENCH_LOG
	echo "### `date '+%Y%m%d%H%M%S'` ${DIR}" >> $SYSBENCH_LOG
	echo "########################################################################################################" >> $SYSBENCH_LOG

	sysbench \
	--test=oltp \
	--db-driver=mysql \
	--oltp-table-size=50000000 \
	--mysql-socket=/${DIR}/mysql/mysql.sock \
	--mysql-user=sbtestuser \
	--mysql-password=sbtestpass \
	--init-rng=on --oltp-read-only=on --oltp-dist-type=uniform \
	--num-threads=16 --max-time=180 --oltp-test-mode=complex \
	run >> $SYSBENCH_LOG

	echo ""
	done

	kill $PID