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 07:10:51 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 07:10:51,1.783,0.552,97.424,0.218,0.004,0.019,1.920,2.0,2.0,4254179328.0,1740800.0,18673664.0,27262816256.0,307614.938,4346259.893,21.981,281.470,0.0,0.0
01-06 07:10:54,54.904,16.513,18.022,9.179,0.712,0.671,3.050,2.230,2.070,5205237760.0,2875392.0,25862144.0,26303434752.0,316738218.667,32426.667,19246.333,6.667,336.667,4300.0
01-06 07:10:57,64.304,18.205,1.720,14.346,0.713,0.713,3.050,2.230,2.070,6245322752.0,2908160.0,25858048.0,25263321088.0,344883200.0,45056.0,21054.0,4.0,290.0,4216.667
01-06 07:11:00,61.109,16.132,8.045,13.256,0.709,0.750,4.080,2.460,2.150,7094710272.0,503808.0,20262912.0,24421933056.0,285379242.667,59562.667,17383.333,12.667,301.333,4606.0
01-06 07:11:03,64.089,17.851,8.570,7.734,0.878,0.878,4.080,2.460,2.150,8165613568.0,696320.0,22368256.0,23348731904.0,354282154.667,33621.333,21599.667,5.333,450.0,4104.667
01-06 07:11:06,72.087,19.405,0.377,6.370,0.838,0.922,4.960,2.670,2.220,9326039040.0,835584.0,22376448.0,22188158976.0,385448618.667,16042.667,23524.333,3.0,2014.333,2953.333
01-06 07:11:09,42.242,10.958,36.261,9.536,0.460,0.544,5.920,2.910,2.300,9965817856.0,565248.0,22425600.0,21548601344.0,212960597.333,26965.333,12942.0,8.0,508.0,4070.667
01-06 07:11:12,5.700,1.676,70.159,22.381,0.0,0.084,5.920,2.910,2.300,10050199552.0,573440.0,22421504.0,21464215552.0,27582464.0,20138.667,1684.667,3.0,888.667,4086.667
01-06 07:11:15,5.793,1.847,68.556,23.720,0.0,0.084,6.730,3.120,2.370,10146967552.0,589824.0,22425600.0,21367427072.0,27841877.333,16384.0,1698.667,2.333,785.667,4182.667
01-06 07:11:18,6.242,1.508,69.920,22.245,0.0,0.084,6.730,3.120,2.370,10230956032.0,598016.0,22425600.0,21283430400.0,27738112.0,5461.333,1693.0,1.333,542.667,3981.333
01-06 07:11:21,5.988,1.717,69.849,22.320,0.0,0.126,7.550,3.350,2.450,10315083776.0,614400.0,22421504.0,21199290368.0,27552426.667,10922.667,1683.0,2.333,460.0,2380.667
01-06 07:11:24,6.276,1.883,70.711,21.046,0.0,0.084,8.470,3.610,2.540,10409766912.0,622592.0,22429696.0,21104590848.0,27944277.333,5632.0,1706.0,1.667,657.333,3968.667
01-06 07:11:27,5.988,1.717,71.817,20.352,0.042,0.084,8.470,3.610,2.540,10493501440.0,638976.0,22446080.0,21020823552.0,27426816.0,10922.667,1673.333,2.333,206.667,1306.0
01-06 07:11:30,6.289,1.635,71.321,20.671,0.0,0.084,9.150,3.830,2.610,10575536128.0,647168.0,22446080.0,20938780672.0,28038485.333,11434.667,1711.333,2.667,438.0,4337.333
01-06 07:11:33,6.292,1.720,70.050,21.854,0.0,0.084,9.150,3.830,2.610,10660732928.0,663552.0,22446080.0,20853567488.0,27962026.667,10922.667,1706.333,2.333,612.667,4036.667
01-06 07:11:36,6.279,1.674,71.034,20.929,0.0,0.084,9.940,4.090,2.700,10746953728.0,671744.0,22446080.0,20767338496.0,27486890.667,5461.333,1678.333,1.333,390.0,4010.0
01-06 07:11:39,6.494,1.676,70.674,21.072,0.0,0.084,10.660,4.330,2.790,10828853248.0,688128.0,22446080.0,20685422592.0,27749034.667,10922.667,1693.333,2.333,583.333,1311.333
01-06 07:11:42,6.569,1.632,71.004,20.669,0.0,0.126,10.660,4.330,2.790,10910760960.0,696320.0,22446080.0,20603506688.0,27612501.333,5461.333,1685.333,1.333,337.0,4154.0
01-06 07:11:45,6.308,1.766,67.914,23.970,0.0,0.042,11.250,4.560,2.870,10994905088.0,716800.0,22441984.0,20519346176.0,27815936.0,19114.667,1698.0,3.333,564.0,3992.0
01-06 07:11:48,6.557,1.555,69.357,22.404,0.042,0.084,11.250,4.560,2.870,11076808704.0,724992.0,22446080.0,20437430272.0,28027562.667,12288.0,1710.333,3.0,514.667,4026.0
01-06 07:11:51,6.129,1.511,68.346,23.929,0.0,0.084,11.870,4.800,2.960,11156606976.0,741376.0,22441984.0,20357619712.0,26159786.667,10922.667,1597.667,2.333,223.333,1425.333
01-06 07:11:54,6.384,1.638,68.711,23.184,0.0,0.084,12.360,5.020,3.040,11238510592.0,749568.0,22446080.0,20275703808.0,27448661.333,5461.333,1674.667,1.333,208.0,3600.667
01-06 07:11:57,6.423,1.595,69.563,22.292,0.0,0.126,12.360,5.020,3.040,11320270848.0,765952.0,22450176.0,20193923072.0,27394048.0,10922.667,1672.333,2.333,268.667,4015.333
01-06 07:12:00,6.756,1.679,69.324,22.157,0.0,0.084,12.970,5.270,3.130,11406733312.0,921600.0,22450176.0,20107304960.0,27702613.333,11434.667,1691.667,3.333,470.0,3917.333
01-06 07:12:03,6.739,1.884,69.401,21.850,0.0,0.126,12.970,5.270,3.130,11488636928.0,937984.0,22446080.0,20025389056.0,27830954.667,10922.667,1698.667,2.333,455.0,4004.667
01-06 07:12:06,6.748,1.928,67.645,23.554,0.0,0.126,13.620,5.530,3.220,11572649984.0,946176.0,22454272.0,19941359616.0,27870549.333,5461.333,1700.333,1.333,2169.667,6140.0
01-06 07:12:09,6.619,1.885,69.962,21.408,0.0,0.126,14.130,5.770,3.310,11652452352.0,962560.0,22454272.0,19861540864.0,27710805.333,9557.333,1692.0,2.333,587.333,3963.333
01-06 07:12:12,6.748,1.886,65.004,26.236,0.042,0.084,14.130,5.770,3.310,11738673152.0,970752.0,22454272.0,19775311872.0,27437738.667,5461.333,1674.333,1.333,518.0,4065.333
01-06 07:12:15,6.843,1.763,67.632,23.720,0.0,0.042,14.440,5.970,3.390,11824893952.0,987136.0,22454272.0,19689074688.0,27830954.667,9557.333,1698.667,2.333,577.333,1316.667
01-06 07:12:18,6.979,1.964,69.327,21.605,0.0,0.125,14.440,5.970,3.390,11904688128.0,1003520.0,22454272.0,19609264128.0,27650730.667,13653.333,1687.667,3.333,547.333,6222.667
01-06 07:12:21,6.873,1.928,68.818,22.213,0.042,0.126,14.800,6.190,3.480,11988688896.0,1019904.0,22450176.0,19525251072.0,27759957.333,13653.333,1694.0,2.333,617.333,3981.333
01-06 07:12:24,6.987,2.134,68.787,22.008,0.0,0.084,15.460,6.470,3.580,12070735872.0,1028096.0,22454272.0,19443191808.0,27765418.667,9557.333,1695.0,2.333,528.667,1473.333
01-06 07:12:27,7.011,1.973,67.548,23.384,0.0,0.084,15.460,6.470,3.580,12156829696.0,1044480.0,22454272.0,19357081600.0,27962026.667,10922.667,1706.333,2.333,424.667,3992.0
01-06 07:12:30,7.235,2.008,67.461,23.170,0.0,0.125,15.740,6.670,3.660,12240961536.0,1052672.0,22454272.0,19272941568.0,27820032.0,5973.333,1698.0,2.0,389.333,4031.333
01-06 07:12:33,6.963,2.013,68.414,22.525,0.0,0.084,15.740,6.670,3.660,12322717696.0,1077248.0,22454272.0,19191160832.0,27590656.0,16384.0,1684.0,3.667,292.0,4054.667
01-06 07:12:36,7.238,2.008,64.770,25.858,0.0,0.126,16.0,6.880,3.750,12408938496.0,1085440.0,22454272.0,19104931840.0,27836416.0,5461.333,1699.333,1.333,416.667,3986.667
01-06 07:12:39,7.161,1.884,67.295,23.576,0.042,0.042,16.240,7.080,3.830,12488994816.0,1101824.0,22454272.0,19024859136.0,27099136.0,10922.667,1653.667,2.333,728.0,4026.0
01-06 07:12:42,7.580,1.926,66.206,24.204,0.0,0.084,16.240,7.080,3.830,12575215616.0,1118208.0,22454272.0,18938621952.0,28054869.333,10922.667,1712.667,2.667,340.0,4031.333
01-06 07:12:45,7.702,1.967,67.350,22.855,0.0,0.126,16.460,7.280,3.910,12657135616.0,1134592.0,22450176.0,18856689664.0,27759957.333,10922.667,1694.333,2.333,500.0,4020.667
01-06 07:12:48,7.344,1.930,66.932,23.668,0.0,0.126,16.460,7.280,3.910,12741263360.0,1142784.0,22454272.0,18772549632.0,27847338.667,6826.667,1699.667,1.667,771.333,2037.333
01-06 07:12:51,5.665,1.553,70.248,22.451,0.0,0.084,16.590,7.450,3.980,12804923392.0,471040.0,22327296.0,18709688320.0,23135573.333,29354.667,1355.333,7.667,241.333,1422.0
01-06 07:12:54,5.400,1.632,71.829,21.097,0.0,0.042,16.780,7.650,4.060,12889489408.0,495616.0,22343680.0,18625081344.0,27161941.333,24576.0,1658.0,3.667,320.667,4099.333
01-06 07:12:57,5.292,1.470,71.231,21.924,0.0,0.084,16.780,7.650,4.060,12967190528.0,503808.0,22347776.0,18547367936.0,25707861.333,12800.0,1570.333,2.333,295.333,3986.667
01-06 07:13:00,5.744,1.509,70.650,22.013,0.0,0.084,16.960,7.830,4.140,13047119872.0,647168.0,22347776.0,18467295232.0,26497024.0,1706.667,1616.667,0.667,252.667,3986.667
01-06 07:13:03,5.700,1.635,70.495,22.087,0.0,0.084,16.960,7.830,4.140,13126930432.0,655360.0,22347776.0,18387476480.0,26685440.0,8533.333,1628.333,1.667,595.333,2300.667
01-06 07:13:06,6.067,1.757,67.782,24.268,0.042,0.084,17.120,8.020,4.220,13204905984.0,655360.0,22364160.0,18309484544.0,26120192.0,1706.667,1595.333,0.667,2105.0,3740.0
01-06 07:13:09,5.737,1.466,72.069,20.687,0.0,0.042,17.110,8.170,4.290,13286936576.0,663552.0,22368256.0,18227441664.0,25832106.667,7168.0,1576.333,1.667,502.667,4010.0
01-06 07:13:12,5.840,1.513,68.950,23.613,0.0,0.084,17.110,8.170,4.290,13362552832.0,663552.0,22368256.0,18151825408.0,26602154.667,1706.667,1624.333,0.667,758.0,4008.0
01-06 07:13:15,5.683,1.672,71.208,21.312,0.0,0.125,17.100,8.310,4.360,13442940928.0,671744.0,22364160.0,18071433216.0,25761109.333,5802.667,1571.667,1.667,1110.0,4026.0
01-06 07:13:18,5.776,1.549,71.159,21.432,0.0,0.084,17.100,8.310,4.360,13520650240.0,671744.0,22368256.0,17993719808.0,25640960.0,4949.333,1565.0,1.667,359.333,4026.0
01-06 07:13:21,5.781,1.550,69.753,22.832,0.0,0.084,17.330,8.510,4.440,13594296320.0,679936.0,22368256.0,17920065536.0,25903104.0,5802.667,1581.333,1.667,418.667,3986.667
01-06 07:13:24,5.786,1.719,71.279,21.090,0.0,0.126,17.310,8.650,4.510,13674323968.0,679936.0,22368256.0,17840037888.0,26023253.333,1706.667,1589.0,0.667,368.0,3986.667
01-06 07:13:27,5.833,1.595,71.171,21.318,0.0,0.084,17.310,8.650,4.510,13752029184.0,696320.0,22368256.0,17762316288.0,26151594.667,16725.333,1596.0,2.667,511.333,4010.0
01-06 07:13:30,6.085,1.553,69.912,22.409,0.0,0.042,17.280,8.790,4.580,13831974912.0,696320.0,22368256.0,17682370560.0,26203477.333,1706.667,1599.0,0.667,267.333,1425.333
01-06 07:13:33,5.900,1.632,69.665,22.636,0.042,0.126,17.280,8.790,4.580,13909618688.0,704512.0,22368256.0,17604718592.0,25799338.667,18090.667,1574.667,4.0,344.0,4054.667
01-06 07:13:36,6.190,1.631,69.929,22.166,0.0,0.084,17.260,8.920,4.640,13989429248.0,704512.0,22368256.0,17524908032.0,26050560.0,1706.667,1590.333,0.667,501.0,3986.667
01-06 07:13:39,5.961,1.553,69.144,23.258,0.0,0.084,17.240,9.060,4.710,14065045504.0,712704.0,22368256.0,17449283584.0,26159786.667,7168.0,1596.667,1.667,570.0,3156.0
01-06 07:13:42,6.205,1.509,70.440,21.761,0.0,0.084,17.240,9.060,4.710,14144991232.0,712704.0,22368256.0,17369337856.0,26296320.0,1706.667,1604.667,0.667,252.667,3992.0
01-06 07:13:45,6.038,1.929,69.476,22.432,0.042,0.084,17.380,9.220,4.790,14222848000.0,720896.0,22368256.0,17291472896.0,26105173.333,7168.0,1594.0,1.667,319.333,1960.667
01-06 07:13:48,6.205,1.593,69.140,22.977,0.0,0.084,17.380,9.220,4.790,14304763904.0,720896.0,22368256.0,17209556992.0,26176170.667,4949.333,1597.0,1.667,650.0,4049.333
01-06 07:13:51,6.069,1.507,70.113,22.269,0.0,0.042,17.430,9.370,4.860,14376181760.0,729088.0,22364160.0,17138135040.0,24526848.0,7168.0,1497.333,1.667,635.0,1478.667
01-06 07:13:54,6.247,1.677,69.811,22.222,0.0,0.042,17.470,9.510,4.930,14455996416.0,729088.0,22368256.0,17058316288.0,26170709.333,3413.333,1597.333,1.333,554.333,3992.0
01-06 07:13:57,6.365,1.717,69.137,22.613,0.042,0.126,17.470,9.510,4.930,14533828608.0,737280.0,22368256.0,16980475904.0,26340010.667,7168.0,1607.333,2.0,294.0,1354.0
01-06 07:14:00,6.166,1.720,68.582,23.406,0.0,0.126,17.520,9.650,5.0,14611423232.0,737280.0,22368256.0,16902881280.0,25924949.333,1706.667,1582.333,0.667,688.333,1388.0
01-06 07:14:03,6.462,1.553,67.898,24.003,0.0,0.084,17.520,9.650,5.0,14689263616.0,745472.0,22368256.0,16825032704.0,26187093.333,8533.333,1598.667,1.667,280.667,1348.667
01-06 07:14:06,6.527,1.757,67.071,24.477,0.042,0.126,17.390,9.760,5.060,14769614848.0,745472.0,22368256.0,16744681472.0,25651882.667,3072.0,1566.0,1.0,1995.0,5396.0
01-06 07:14:09,6.580,1.718,68.776,22.842,0.0,0.084,17.440,9.890,5.130,14847201280.0,753664.0,22368256.0,16667086848.0,26181632.0,7168.0,1597.667,2.0,318.667,4271.333
01-06 07:14:12,6.823,1.758,68.481,22.855,0.0,0.084,17.440,9.890,5.130,14927257600.0,753664.0,22368256.0,16587030528.0,26498389.333,1706.667,1617.333,0.667,564.0,1461.333
01-06 07:14:15,6.577,1.676,70.088,21.575,0.0,0.084,17.570,10.040,5.200,15002750976.0,761856.0,22364160.0,16511533056.0,25832106.667,7168.0,1576.333,1.667,304.0,1398.667
01-06 07:14:18,6.507,1.637,68.388,23.426,0.0,0.042,17.570,10.040,5.200,15084654592.0,761856.0,22368256.0,16429625344.0,25739264.0,6656.0,1571.0,2.333,274.0,3992.0
01-06 07:14:21,6.868,1.759,68.216,22.990,0.042,0.126,17.600,10.180,5.270,15160266752.0,770048.0,22372352.0,16354000896.0,26389162.667,7168.0,1610.667,1.667,323.333,1306.0
01-06 07:14:24,7.101,2.089,67.920,22.807,0.0,0.084,17.550,10.290,5.330,15240167424.0,770048.0,22372352.0,16274100224.0,26312704.0,1706.667,1606.333,0.667,516.333,4015.333
01-06 07:14:27,6.840,1.637,66.051,25.388,0.0,0.084,17.550,10.290,5.330,15319982080.0,778240.0,22368256.0,16194281472.0,26356394.667,5802.667,1608.667,1.667,287.333,1359.333
01-06 07:14:30,6.759,1.721,67.674,23.720,0.0,0.126,17.590,10.420,5.400,15397826560.0,778240.0,22372352.0,16116432896.0,26279936.0,1706.667,1604.0,0.667,274.0,3992.0
01-06 07:14:33,6.753,1.804,67.534,23.826,0.0,0.084,17.590,10.420,5.400,15477624832.0,790528.0,22372352.0,16036622336.0,25795242.667,11605.333,1575.333,2.667,354.333,3992.0
01-06 07:14:36,6.921,1.762,67.534,23.658,0.0,0.126,17.700,10.560,5.470,15555211264.0,790528.0,22372352.0,15959035904.0,26214400.0,1706.667,1599.333,0.667,605.667,4010.0
01-06 07:14:39,7.286,1.717,68.216,22.697,0.0,0.084,17.640,10.670,5.530,15632924672.0,798720.0,22372352.0,15881314304.0,26405546.667,7168.0,1611.667,1.667,458.667,4026.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

[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

[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

[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

## result.txt
########################################################################################################
### 20140601071051 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  (1212.96 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (16981.51 per sec.)
    other operations:                    20000  (2425.93 per sec.)

Test execution summary:
    total time:                          8.2443s
    total number of events:              10000
    total time taken by event execution: 131.7897
    per-request statistics:
         min:                                  5.88ms
         avg:                                 13.18ms
         max:                                122.48ms
         approx.  95 percentile:              19.09ms

Threads fairness:
    events (avg/stddev):           625.0000/8.06
    execution time (avg/stddev):   8.2369/0.00

########################################################################################################
### 20140601071100 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  (1352.03 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (18928.36 per sec.)
    other operations:                    20000  (2704.05 per sec.)

Test execution summary:
    total time:                          7.3963s
    total number of events:              10000
    total time taken by event execution: 118.2103
    per-request statistics:
         min:                                  5.38ms
         avg:                                 11.82ms
         max:                                123.31ms
         approx.  95 percentile:              20.56ms

Threads fairness:
    events (avg/stddev):           625.0000/19.95
    execution time (avg/stddev):   7.3881/0.00

########################################################################################################
### 20140601071108 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.82 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (1369.54 per sec.)
    other operations:                    20000  (195.65 per sec.)

Test execution summary:
    total time:                          102.2244s
    total number of events:              10000
    total time taken by event execution: 1633.3043
    per-request statistics:
         min:                                 46.19ms
         avg:                                163.33ms
         max:                                431.65ms
         approx.  95 percentile:             241.69ms

Threads fairness:
    events (avg/stddev):           625.0000/5.37
    execution time (avg/stddev):   102.0815/0.07

########################################################################################################
### 20140601071250 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.32 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 140000 (1292.55 per sec.)
    other operations:                    20000  (184.65 per sec.)

Test execution summary:
    total time:                          108.3132s
    total number of events:              10000
    total time taken by event execution: 1732.1327
    per-request statistics:
         min:                                 35.77ms
         avg:                                173.21ms
         max:                                474.58ms
         approx.  95 percentile:             257.91ms

Threads fairness:
    events (avg/stddev):           625.0000/5.12
    execution time (avg/stddev):   108.2583/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

## sysbench_prepare.sh
#!/bin/bash

for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
	sysbench \
	--test=oltp \
	--db-driver=mysql \
	--oltp-table-size=50000000 \
	--mysql-socket=/${DIR}/mysql/mysql.sock \
	--mysql-user=sbtestuser \
	--mysql-password=sbtestpass \
	prepare
done
	"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 07:10:51 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 07:10:51,1.783,0.552,97.424,0.218,0.004,0.019,1.920,2.0,2.0,4254179328.0,1740800.0,18673664.0,27262816256.0,307614.938,4346259.893,21.981,281.470,0.0,0.0
	01-06 07:10:54,54.904,16.513,18.022,9.179,0.712,0.671,3.050,2.230,2.070,5205237760.0,2875392.0,25862144.0,26303434752.0,316738218.667,32426.667,19246.333,6.667,336.667,4300.0
	01-06 07:10:57,64.304,18.205,1.720,14.346,0.713,0.713,3.050,2.230,2.070,6245322752.0,2908160.0,25858048.0,25263321088.0,344883200.0,45056.0,21054.0,4.0,290.0,4216.667
	01-06 07:11:00,61.109,16.132,8.045,13.256,0.709,0.750,4.080,2.460,2.150,7094710272.0,503808.0,20262912.0,24421933056.0,285379242.667,59562.667,17383.333,12.667,301.333,4606.0
	01-06 07:11:03,64.089,17.851,8.570,7.734,0.878,0.878,4.080,2.460,2.150,8165613568.0,696320.0,22368256.0,23348731904.0,354282154.667,33621.333,21599.667,5.333,450.0,4104.667
	01-06 07:11:06,72.087,19.405,0.377,6.370,0.838,0.922,4.960,2.670,2.220,9326039040.0,835584.0,22376448.0,22188158976.0,385448618.667,16042.667,23524.333,3.0,2014.333,2953.333
	01-06 07:11:09,42.242,10.958,36.261,9.536,0.460,0.544,5.920,2.910,2.300,9965817856.0,565248.0,22425600.0,21548601344.0,212960597.333,26965.333,12942.0,8.0,508.0,4070.667
	01-06 07:11:12,5.700,1.676,70.159,22.381,0.0,0.084,5.920,2.910,2.300,10050199552.0,573440.0,22421504.0,21464215552.0,27582464.0,20138.667,1684.667,3.0,888.667,4086.667
	01-06 07:11:15,5.793,1.847,68.556,23.720,0.0,0.084,6.730,3.120,2.370,10146967552.0,589824.0,22425600.0,21367427072.0,27841877.333,16384.0,1698.667,2.333,785.667,4182.667
	01-06 07:11:18,6.242,1.508,69.920,22.245,0.0,0.084,6.730,3.120,2.370,10230956032.0,598016.0,22425600.0,21283430400.0,27738112.0,5461.333,1693.0,1.333,542.667,3981.333
	01-06 07:11:21,5.988,1.717,69.849,22.320,0.0,0.126,7.550,3.350,2.450,10315083776.0,614400.0,22421504.0,21199290368.0,27552426.667,10922.667,1683.0,2.333,460.0,2380.667
	01-06 07:11:24,6.276,1.883,70.711,21.046,0.0,0.084,8.470,3.610,2.540,10409766912.0,622592.0,22429696.0,21104590848.0,27944277.333,5632.0,1706.0,1.667,657.333,3968.667
	01-06 07:11:27,5.988,1.717,71.817,20.352,0.042,0.084,8.470,3.610,2.540,10493501440.0,638976.0,22446080.0,21020823552.0,27426816.0,10922.667,1673.333,2.333,206.667,1306.0
	01-06 07:11:30,6.289,1.635,71.321,20.671,0.0,0.084,9.150,3.830,2.610,10575536128.0,647168.0,22446080.0,20938780672.0,28038485.333,11434.667,1711.333,2.667,438.0,4337.333
	01-06 07:11:33,6.292,1.720,70.050,21.854,0.0,0.084,9.150,3.830,2.610,10660732928.0,663552.0,22446080.0,20853567488.0,27962026.667,10922.667,1706.333,2.333,612.667,4036.667
	01-06 07:11:36,6.279,1.674,71.034,20.929,0.0,0.084,9.940,4.090,2.700,10746953728.0,671744.0,22446080.0,20767338496.0,27486890.667,5461.333,1678.333,1.333,390.0,4010.0
	01-06 07:11:39,6.494,1.676,70.674,21.072,0.0,0.084,10.660,4.330,2.790,10828853248.0,688128.0,22446080.0,20685422592.0,27749034.667,10922.667,1693.333,2.333,583.333,1311.333
	01-06 07:11:42,6.569,1.632,71.004,20.669,0.0,0.126,10.660,4.330,2.790,10910760960.0,696320.0,22446080.0,20603506688.0,27612501.333,5461.333,1685.333,1.333,337.0,4154.0
	01-06 07:11:45,6.308,1.766,67.914,23.970,0.0,0.042,11.250,4.560,2.870,10994905088.0,716800.0,22441984.0,20519346176.0,27815936.0,19114.667,1698.0,3.333,564.0,3992.0
	01-06 07:11:48,6.557,1.555,69.357,22.404,0.042,0.084,11.250,4.560,2.870,11076808704.0,724992.0,22446080.0,20437430272.0,28027562.667,12288.0,1710.333,3.0,514.667,4026.0
	01-06 07:11:51,6.129,1.511,68.346,23.929,0.0,0.084,11.870,4.800,2.960,11156606976.0,741376.0,22441984.0,20357619712.0,26159786.667,10922.667,1597.667,2.333,223.333,1425.333
	01-06 07:11:54,6.384,1.638,68.711,23.184,0.0,0.084,12.360,5.020,3.040,11238510592.0,749568.0,22446080.0,20275703808.0,27448661.333,5461.333,1674.667,1.333,208.0,3600.667
	01-06 07:11:57,6.423,1.595,69.563,22.292,0.0,0.126,12.360,5.020,3.040,11320270848.0,765952.0,22450176.0,20193923072.0,27394048.0,10922.667,1672.333,2.333,268.667,4015.333
	01-06 07:12:00,6.756,1.679,69.324,22.157,0.0,0.084,12.970,5.270,3.130,11406733312.0,921600.0,22450176.0,20107304960.0,27702613.333,11434.667,1691.667,3.333,470.0,3917.333
	01-06 07:12:03,6.739,1.884,69.401,21.850,0.0,0.126,12.970,5.270,3.130,11488636928.0,937984.0,22446080.0,20025389056.0,27830954.667,10922.667,1698.667,2.333,455.0,4004.667
	01-06 07:12:06,6.748,1.928,67.645,23.554,0.0,0.126,13.620,5.530,3.220,11572649984.0,946176.0,22454272.0,19941359616.0,27870549.333,5461.333,1700.333,1.333,2169.667,6140.0
	01-06 07:12:09,6.619,1.885,69.962,21.408,0.0,0.126,14.130,5.770,3.310,11652452352.0,962560.0,22454272.0,19861540864.0,27710805.333,9557.333,1692.0,2.333,587.333,3963.333
	01-06 07:12:12,6.748,1.886,65.004,26.236,0.042,0.084,14.130,5.770,3.310,11738673152.0,970752.0,22454272.0,19775311872.0,27437738.667,5461.333,1674.333,1.333,518.0,4065.333
	01-06 07:12:15,6.843,1.763,67.632,23.720,0.0,0.042,14.440,5.970,3.390,11824893952.0,987136.0,22454272.0,19689074688.0,27830954.667,9557.333,1698.667,2.333,577.333,1316.667
	01-06 07:12:18,6.979,1.964,69.327,21.605,0.0,0.125,14.440,5.970,3.390,11904688128.0,1003520.0,22454272.0,19609264128.0,27650730.667,13653.333,1687.667,3.333,547.333,6222.667
	01-06 07:12:21,6.873,1.928,68.818,22.213,0.042,0.126,14.800,6.190,3.480,11988688896.0,1019904.0,22450176.0,19525251072.0,27759957.333,13653.333,1694.0,2.333,617.333,3981.333
	01-06 07:12:24,6.987,2.134,68.787,22.008,0.0,0.084,15.460,6.470,3.580,12070735872.0,1028096.0,22454272.0,19443191808.0,27765418.667,9557.333,1695.0,2.333,528.667,1473.333
	01-06 07:12:27,7.011,1.973,67.548,23.384,0.0,0.084,15.460,6.470,3.580,12156829696.0,1044480.0,22454272.0,19357081600.0,27962026.667,10922.667,1706.333,2.333,424.667,3992.0
	01-06 07:12:30,7.235,2.008,67.461,23.170,0.0,0.125,15.740,6.670,3.660,12240961536.0,1052672.0,22454272.0,19272941568.0,27820032.0,5973.333,1698.0,2.0,389.333,4031.333
	01-06 07:12:33,6.963,2.013,68.414,22.525,0.0,0.084,15.740,6.670,3.660,12322717696.0,1077248.0,22454272.0,19191160832.0,27590656.0,16384.0,1684.0,3.667,292.0,4054.667
	01-06 07:12:36,7.238,2.008,64.770,25.858,0.0,0.126,16.0,6.880,3.750,12408938496.0,1085440.0,22454272.0,19104931840.0,27836416.0,5461.333,1699.333,1.333,416.667,3986.667
	01-06 07:12:39,7.161,1.884,67.295,23.576,0.042,0.042,16.240,7.080,3.830,12488994816.0,1101824.0,22454272.0,19024859136.0,27099136.0,10922.667,1653.667,2.333,728.0,4026.0
	01-06 07:12:42,7.580,1.926,66.206,24.204,0.0,0.084,16.240,7.080,3.830,12575215616.0,1118208.0,22454272.0,18938621952.0,28054869.333,10922.667,1712.667,2.667,340.0,4031.333
	01-06 07:12:45,7.702,1.967,67.350,22.855,0.0,0.126,16.460,7.280,3.910,12657135616.0,1134592.0,22450176.0,18856689664.0,27759957.333,10922.667,1694.333,2.333,500.0,4020.667
	01-06 07:12:48,7.344,1.930,66.932,23.668,0.0,0.126,16.460,7.280,3.910,12741263360.0,1142784.0,22454272.0,18772549632.0,27847338.667,6826.667,1699.667,1.667,771.333,2037.333
	01-06 07:12:51,5.665,1.553,70.248,22.451,0.0,0.084,16.590,7.450,3.980,12804923392.0,471040.0,22327296.0,18709688320.0,23135573.333,29354.667,1355.333,7.667,241.333,1422.0
	01-06 07:12:54,5.400,1.632,71.829,21.097,0.0,0.042,16.780,7.650,4.060,12889489408.0,495616.0,22343680.0,18625081344.0,27161941.333,24576.0,1658.0,3.667,320.667,4099.333
	01-06 07:12:57,5.292,1.470,71.231,21.924,0.0,0.084,16.780,7.650,4.060,12967190528.0,503808.0,22347776.0,18547367936.0,25707861.333,12800.0,1570.333,2.333,295.333,3986.667
	01-06 07:13:00,5.744,1.509,70.650,22.013,0.0,0.084,16.960,7.830,4.140,13047119872.0,647168.0,22347776.0,18467295232.0,26497024.0,1706.667,1616.667,0.667,252.667,3986.667
	01-06 07:13:03,5.700,1.635,70.495,22.087,0.0,0.084,16.960,7.830,4.140,13126930432.0,655360.0,22347776.0,18387476480.0,26685440.0,8533.333,1628.333,1.667,595.333,2300.667
	01-06 07:13:06,6.067,1.757,67.782,24.268,0.042,0.084,17.120,8.020,4.220,13204905984.0,655360.0,22364160.0,18309484544.0,26120192.0,1706.667,1595.333,0.667,2105.0,3740.0
	01-06 07:13:09,5.737,1.466,72.069,20.687,0.0,0.042,17.110,8.170,4.290,13286936576.0,663552.0,22368256.0,18227441664.0,25832106.667,7168.0,1576.333,1.667,502.667,4010.0
	01-06 07:13:12,5.840,1.513,68.950,23.613,0.0,0.084,17.110,8.170,4.290,13362552832.0,663552.0,22368256.0,18151825408.0,26602154.667,1706.667,1624.333,0.667,758.0,4008.0
	01-06 07:13:15,5.683,1.672,71.208,21.312,0.0,0.125,17.100,8.310,4.360,13442940928.0,671744.0,22364160.0,18071433216.0,25761109.333,5802.667,1571.667,1.667,1110.0,4026.0
	01-06 07:13:18,5.776,1.549,71.159,21.432,0.0,0.084,17.100,8.310,4.360,13520650240.0,671744.0,22368256.0,17993719808.0,25640960.0,4949.333,1565.0,1.667,359.333,4026.0
	01-06 07:13:21,5.781,1.550,69.753,22.832,0.0,0.084,17.330,8.510,4.440,13594296320.0,679936.0,22368256.0,17920065536.0,25903104.0,5802.667,1581.333,1.667,418.667,3986.667
	01-06 07:13:24,5.786,1.719,71.279,21.090,0.0,0.126,17.310,8.650,4.510,13674323968.0,679936.0,22368256.0,17840037888.0,26023253.333,1706.667,1589.0,0.667,368.0,3986.667
	01-06 07:13:27,5.833,1.595,71.171,21.318,0.0,0.084,17.310,8.650,4.510,13752029184.0,696320.0,22368256.0,17762316288.0,26151594.667,16725.333,1596.0,2.667,511.333,4010.0
	01-06 07:13:30,6.085,1.553,69.912,22.409,0.0,0.042,17.280,8.790,4.580,13831974912.0,696320.0,22368256.0,17682370560.0,26203477.333,1706.667,1599.0,0.667,267.333,1425.333
	01-06 07:13:33,5.900,1.632,69.665,22.636,0.042,0.126,17.280,8.790,4.580,13909618688.0,704512.0,22368256.0,17604718592.0,25799338.667,18090.667,1574.667,4.0,344.0,4054.667
	01-06 07:13:36,6.190,1.631,69.929,22.166,0.0,0.084,17.260,8.920,4.640,13989429248.0,704512.0,22368256.0,17524908032.0,26050560.0,1706.667,1590.333,0.667,501.0,3986.667
	01-06 07:13:39,5.961,1.553,69.144,23.258,0.0,0.084,17.240,9.060,4.710,14065045504.0,712704.0,22368256.0,17449283584.0,26159786.667,7168.0,1596.667,1.667,570.0,3156.0
	01-06 07:13:42,6.205,1.509,70.440,21.761,0.0,0.084,17.240,9.060,4.710,14144991232.0,712704.0,22368256.0,17369337856.0,26296320.0,1706.667,1604.667,0.667,252.667,3992.0
	01-06 07:13:45,6.038,1.929,69.476,22.432,0.042,0.084,17.380,9.220,4.790,14222848000.0,720896.0,22368256.0,17291472896.0,26105173.333,7168.0,1594.0,1.667,319.333,1960.667
	01-06 07:13:48,6.205,1.593,69.140,22.977,0.0,0.084,17.380,9.220,4.790,14304763904.0,720896.0,22368256.0,17209556992.0,26176170.667,4949.333,1597.0,1.667,650.0,4049.333
	01-06 07:13:51,6.069,1.507,70.113,22.269,0.0,0.042,17.430,9.370,4.860,14376181760.0,729088.0,22364160.0,17138135040.0,24526848.0,7168.0,1497.333,1.667,635.0,1478.667
	01-06 07:13:54,6.247,1.677,69.811,22.222,0.0,0.042,17.470,9.510,4.930,14455996416.0,729088.0,22368256.0,17058316288.0,26170709.333,3413.333,1597.333,1.333,554.333,3992.0
	01-06 07:13:57,6.365,1.717,69.137,22.613,0.042,0.126,17.470,9.510,4.930,14533828608.0,737280.0,22368256.0,16980475904.0,26340010.667,7168.0,1607.333,2.0,294.0,1354.0
	01-06 07:14:00,6.166,1.720,68.582,23.406,0.0,0.126,17.520,9.650,5.0,14611423232.0,737280.0,22368256.0,16902881280.0,25924949.333,1706.667,1582.333,0.667,688.333,1388.0
	01-06 07:14:03,6.462,1.553,67.898,24.003,0.0,0.084,17.520,9.650,5.0,14689263616.0,745472.0,22368256.0,16825032704.0,26187093.333,8533.333,1598.667,1.667,280.667,1348.667
	01-06 07:14:06,6.527,1.757,67.071,24.477,0.042,0.126,17.390,9.760,5.060,14769614848.0,745472.0,22368256.0,16744681472.0,25651882.667,3072.0,1566.0,1.0,1995.0,5396.0
	01-06 07:14:09,6.580,1.718,68.776,22.842,0.0,0.084,17.440,9.890,5.130,14847201280.0,753664.0,22368256.0,16667086848.0,26181632.0,7168.0,1597.667,2.0,318.667,4271.333
	01-06 07:14:12,6.823,1.758,68.481,22.855,0.0,0.084,17.440,9.890,5.130,14927257600.0,753664.0,22368256.0,16587030528.0,26498389.333,1706.667,1617.333,0.667,564.0,1461.333
	01-06 07:14:15,6.577,1.676,70.088,21.575,0.0,0.084,17.570,10.040,5.200,15002750976.0,761856.0,22364160.0,16511533056.0,25832106.667,7168.0,1576.333,1.667,304.0,1398.667
	01-06 07:14:18,6.507,1.637,68.388,23.426,0.0,0.042,17.570,10.040,5.200,15084654592.0,761856.0,22368256.0,16429625344.0,25739264.0,6656.0,1571.0,2.333,274.0,3992.0
	01-06 07:14:21,6.868,1.759,68.216,22.990,0.042,0.126,17.600,10.180,5.270,15160266752.0,770048.0,22372352.0,16354000896.0,26389162.667,7168.0,1610.667,1.667,323.333,1306.0
	01-06 07:14:24,7.101,2.089,67.920,22.807,0.0,0.084,17.550,10.290,5.330,15240167424.0,770048.0,22372352.0,16274100224.0,26312704.0,1706.667,1606.333,0.667,516.333,4015.333
	01-06 07:14:27,6.840,1.637,66.051,25.388,0.0,0.084,17.550,10.290,5.330,15319982080.0,778240.0,22368256.0,16194281472.0,26356394.667,5802.667,1608.667,1.667,287.333,1359.333
	01-06 07:14:30,6.759,1.721,67.674,23.720,0.0,0.126,17.590,10.420,5.400,15397826560.0,778240.0,22372352.0,16116432896.0,26279936.0,1706.667,1604.0,0.667,274.0,3992.0
	01-06 07:14:33,6.753,1.804,67.534,23.826,0.0,0.084,17.590,10.420,5.400,15477624832.0,790528.0,22372352.0,16036622336.0,25795242.667,11605.333,1575.333,2.667,354.333,3992.0
	01-06 07:14:36,6.921,1.762,67.534,23.658,0.0,0.126,17.700,10.560,5.470,15555211264.0,790528.0,22372352.0,15959035904.0,26214400.0,1706.667,1599.333,0.667,605.667,4010.0
	01-06 07:14:39,7.286,1.717,68.216,22.697,0.0,0.084,17.640,10.670,5.530,15632924672.0,798720.0,22372352.0,15881314304.0,26405546.667,7168.0,1611.667,1.667,458.667,4026.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

	[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

	[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

	[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
	########################################################################################################
	### 20140601071051 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 (1212.96 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (16981.51 per sec.)
	other operations: 20000 (2425.93 per sec.)

	Test execution summary:
	total time: 8.2443s
	total number of events: 10000
	total time taken by event execution: 131.7897
	per-request statistics:
	min: 5.88ms
	avg: 13.18ms
	max: 122.48ms
	approx. 95 percentile: 19.09ms

	Threads fairness:
	events (avg/stddev): 625.0000/8.06
	execution time (avg/stddev): 8.2369/0.00

	########################################################################################################
	### 20140601071100 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 (1352.03 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (18928.36 per sec.)
	other operations: 20000 (2704.05 per sec.)

	Test execution summary:
	total time: 7.3963s
	total number of events: 10000
	total time taken by event execution: 118.2103
	per-request statistics:
	min: 5.38ms
	avg: 11.82ms
	max: 123.31ms
	approx. 95 percentile: 20.56ms

	Threads fairness:
	events (avg/stddev): 625.0000/19.95
	execution time (avg/stddev): 7.3881/0.00

	########################################################################################################
	### 20140601071108 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.82 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (1369.54 per sec.)
	other operations: 20000 (195.65 per sec.)

	Test execution summary:
	total time: 102.2244s
	total number of events: 10000
	total time taken by event execution: 1633.3043
	per-request statistics:
	min: 46.19ms
	avg: 163.33ms
	max: 431.65ms
	approx. 95 percentile: 241.69ms

	Threads fairness:
	events (avg/stddev): 625.0000/5.37
	execution time (avg/stddev): 102.0815/0.07

	########################################################################################################
	### 20140601071250 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.32 per sec.)
	deadlocks: 0 (0.00 per sec.)
	read/write requests: 140000 (1292.55 per sec.)
	other operations: 20000 (184.65 per sec.)

	Test execution summary:
	total time: 108.3132s
	total number of events: 10000
	total time taken by event execution: 1732.1327
	per-request statistics:
	min: 35.77ms
	avg: 173.21ms
	max: 474.58ms
	approx. 95 percentile: 257.91ms

	Threads fairness:
	events (avg/stddev): 625.0000/5.12
	execution time (avg/stddev): 108.2583/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