Skip to content

Instantly share code, notes, and snippets.

@s-tajima

s-tajima/dstat_sysbench.csv

Created June 1, 2014 03:37
Show Gist options
  • Save s-tajima/7f06821de83f6b096828 to your computer and use it in GitHub Desktop.
Save s-tajima/7f06821de83f6b096828 to your computer and use it in GitHub Desktop.
Download ZIP
sysbench result at 2014/06/01 Case4
Raw
dstat_sysbench.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
"Dstat 0.7.0 CSV output"
"Author:","Dag Wieers <[email protected]>",,,,"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:32:39 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:32:39,1.438,0.482,97.809,0.253,0.003,0.015,2.110,5.040,5.080,15639875584.0,2957312.0,24035328.0,15870541824.0,434943.708,3399727.415,28.423,219.556,0.0,0.0
01-06 21:32:42,60.277,17.953,9.983,9.941,0.671,1.174,2.110,5.040,5.080,16463581184.0,33243136.0,30912512.0,15009673216.0,270903978.667,25427968.0,16781.0,4485.0,680.667,1038.667
01-06 21:32:45,68.889,20.713,1.887,6.457,0.797,1.258,3.380,5.250,5.150,17397170176.0,71507968.0,39022592.0,14029709312.0,308944896.0,32279210.667,19147.667,5671.667,748.333,2178.667
01-06 21:32:48,69.414,20.084,2.343,6.109,0.669,1.381,3.380,5.250,5.150,18174820352.0,110497792.0,47333376.0,13204758528.0,277154474.667,34275328.0,17216.0,5779.0,294.667,514.667
01-06 21:32:51,50.482,16.003,23.670,8.085,0.545,1.215,3.430,5.230,5.150,18693677056.0,8847360.0,26214400.0,12808671232.0,213220010.667,142210048.0,13135.333,7314.667,180.667,530.667
01-06 21:32:54,63.833,20.458,2.167,11.458,0.792,1.292,4.360,5.390,5.200,19494137856.0,20086784.0,33718272.0,11989467136.0,265479509.333,201148586.667,16452.0,9872.667,239.333,536.0
01-06 21:32:57,64.676,20.084,1.754,11.357,0.793,1.336,4.360,5.390,5.200,20252700672.0,31440896.0,41799680.0,11211468800.0,252107434.667,205403818.667,15642.0,10145.667,302.667,1102.0
01-06 21:33:00,52.506,13.910,23.058,9.273,0.543,0.710,4.810,5.470,5.220,20684165120.0,634880.0,23093248.0,10829516800.0,193598805.333,17844736.0,11964.667,2759.0,356.0,491.333
01-06 21:33:03,12.563,5.185,39.966,41.610,0.169,0.506,4.810,5.470,5.220,20769153024.0,4952064.0,22704128.0,10740600832.0,27122346.667,172452522.667,1681.0,6227.0,193.333,530.667
01-06 21:33:06,12.306,5.754,38.765,42.419,0.168,0.588,6.030,5.710,5.300,20851728384.0,9453568.0,23273472.0,10652954624.0,27930624.0,177664000.0,1726.0,6467.667,1903.667,2121.333
01-06 21:33:09,11.401,5.133,41.565,41.228,0.168,0.505,6.910,5.900,5.370,20933574656.0,13885440.0,24346624.0,10565603328.0,27615232.0,154797738.667,1710.667,5787.333,193.333,491.333
01-06 21:33:12,7.524,2.018,64.649,25.641,0.0,0.168,6.910,5.900,5.370,21012611072.0,18243584.0,25968640.0,10480586752.0,27396778.667,3361792.0,1695.0,643.667,176.667,512.667
01-06 21:33:15,7.531,2.343,63.264,26.695,0.0,0.167,7.790,6.100,5.430,21096542208.0,23105536.0,26648576.0,10391113728.0,26994005.333,3385002.667,1666.333,649.0,638.333,748.667
01-06 21:33:18,7.331,2.472,63.804,26.267,0.0,0.126,7.790,6.100,5.430,21176332288.0,27856896.0,27750400.0,10305470464.0,27181056.0,3327829.333,1679.0,640.0,474.0,855.333
01-06 21:33:21,7.473,2.477,63.392,26.448,0.042,0.168,8.530,6.280,5.500,21258772480.0,32362496.0,27545600.0,10218729472.0,27380394.667,3465216.0,1695.0,665.333,888.667,806.0
01-06 21:33:24,7.744,2.595,59.732,29.761,0.042,0.126,9.130,6.440,5.550,21339353088.0,37203968.0,29396992.0,10131456000.0,27613866.667,3495253.333,1705.0,671.667,428.667,609.333
01-06 21:33:27,7.440,2.354,63.892,26.145,0.0,0.168,9.130,6.440,5.550,21425369088.0,41979904.0,32141312.0,10037919744.0,27807744.0,3432448.0,1684.333,659.0,282.0,530.667
01-06 21:33:30,8.106,2.604,59.849,29.273,0.042,0.126,9.760,6.610,5.610,21510610944.0,47214592.0,33550336.0,9946034176.0,27799552.0,3685546.667,1722.0,707.667,286.0,2648.0
01-06 21:33:33,7.928,2.517,60.864,28.523,0.0,0.168,9.760,6.610,5.610,21594562560.0,52006912.0,33890304.0,9856950272.0,27336704.0,3672746.667,1695.333,705.667,651.333,548.667
01-06 21:33:36,7.599,2.519,63.476,26.238,0.042,0.126,10.420,6.800,5.680,21675225088.0,56680448.0,34586624.0,9770917888.0,27082752.0,3618133.333,1679.0,696.667,372.667,491.333
01-06 21:33:39,8.012,2.391,61.619,27.810,0.0,0.168,10.860,6.960,5.730,21755285504.0,61407232.0,35205120.0,9685512192.0,27060906.667,3635882.667,1677.667,696.0,557.333,491.333
01-06 21:33:42,8.060,2.519,61.839,27.414,0.0,0.168,10.860,6.960,5.730,21839110144.0,66273280.0,36368384.0,9595658240.0,27392682.667,3762858.667,1698.333,720.667,134.0,491.333
01-06 21:33:45,8.235,2.479,60.336,28.739,0.042,0.168,11.520,7.160,5.800,21921222656.0,71221248.0,37081088.0,9507885056.0,27578368.0,3799722.667,1712.0,729.333,598.0,491.333
01-06 21:33:48,7.789,2.232,62.905,26.905,0.0,0.168,11.520,7.160,5.800,22005215232.0,76046336.0,37736448.0,9418412032.0,26899797.333,3692373.333,1668.0,709.333,276.667,491.333
01-06 21:33:51,7.615,2.314,60.665,29.239,0.0,0.168,12.120,7.350,5.880,22083428352.0,80814080.0,38055936.0,9335111680.0,26379605.333,3663189.333,1634.667,703.0,200.0,491.333
01-06 21:33:54,8.277,2.605,60.378,28.571,0.042,0.126,12.670,7.550,5.950,22167691264.0,85893120.0,38694912.0,9245130752.0,27403605.333,3907584.0,1701.333,750.667,345.333,491.333
01-06 21:33:57,8.323,2.606,60.277,28.583,0.042,0.168,12.670,7.550,5.950,22249062400.0,90955776.0,39882752.0,9157509120.0,27443200.0,3903488.0,1702.667,750.0,334.667,491.333
01-06 21:34:00,8.351,2.644,61.016,27.864,0.0,0.126,13.090,7.720,6.010,22331351040.0,96092160.0,40214528.0,9069752320.0,27415893.333,3944960.0,1700.667,757.667,509.333,491.333
01-06 21:34:03,8.634,2.682,59.807,28.667,0.042,0.168,13.090,7.720,6.010,22413910016.0,101310464.0,41340928.0,8980848640.0,27383125.333,4018176.0,1700.667,774.0,363.0,491.333
01-06 21:34:06,8.449,2.648,58.806,29.929,0.042,0.126,13.570,7.910,6.080,22495141888.0,106422272.0,42135552.0,8893710336.0,27051349.333,3937621.333,1679.0,757.667,2233.0,2066.0
01-06 21:34:09,8.809,2.475,57.802,30.747,0.0,0.168,13.920,8.070,6.140,22579310592.0,111763456.0,42860544.0,8803475456.0,27568810.667,4101461.333,1711.333,788.667,342.667,491.333
01-06 21:34:12,8.831,2.817,57.611,30.614,0.0,0.126,13.920,8.070,6.140,22661947392.0,117284864.0,43212800.0,8714964992.0,27708074.667,4265301.333,1721.333,818.333,240.667,512.667
01-06 21:34:15,8.843,2.682,60.101,28.164,0.0,0.210,13.930,8.170,6.190,22745399296.0,122703872.0,44449792.0,8624857088.0,26961237.333,5576021.333,1675.333,803.333,170.0,491.333
01-06 21:34:18,8.824,2.773,55.546,32.689,0.042,0.126,13.930,8.170,6.190,22830153728.0,128192512.0,45195264.0,8533868544.0,27511466.667,4257621.333,1710.0,817.0,182.667,525.333
01-06 21:34:21,8.911,2.900,56.789,31.232,0.0,0.168,14.330,8.350,6.250,22909845504.0,133746688.0,45989888.0,8447827968.0,27365376.0,4288512.0,1699.667,828.667,428.0,491.333
01-06 21:34:24,8.639,2.781,56.637,31.732,0.042,0.169,14.470,8.480,6.310,22990188544.0,139284480.0,46927872.0,8361009152.0,26989909.333,4277589.333,1678.333,821.667,511.333,491.333
01-06 21:34:27,8.950,2.857,57.731,30.210,0.042,0.210,14.470,8.480,6.310,23070220288.0,144986112.0,47742976.0,8274460672.0,27347626.667,5547349.333,1700.667,878.333,249.333,491.333
01-06 21:34:30,9.175,2.778,56.481,31.355,0.0,0.210,14.990,8.690,6.380,23111421952.0,150740992.0,47742976.0,8227504128.0,28012544.0,8002730.667,1741.667,990.0,221.333,491.333
01-06 21:34:33,9.350,2.767,58.365,29.308,0.042,0.168,14.990,8.690,6.380,23121002496.0,155500544.0,49086464.0,8211820544.0,26978986.667,6559061.333,1677.333,954.333,290.0,491.333
01-06 21:34:36,9.340,2.608,55.743,32.099,0.0,0.210,15.230,8.840,6.450,23125544960.0,159444992.0,49737728.0,8202682368.0,27780437.333,7593984.0,1727.0,996.0,302.0,653.333
01-06 21:34:39,8.102,3.149,63.056,25.315,0.0,0.378,14.250,8.740,6.430,23132291072.0,7344128.0,23773184.0,8374001664.0,18490709.333,100910080.0,1076.333,4118.667,539.667,530.667
01-06 21:34:42,7.239,2.988,57.071,32.323,0.042,0.337,14.250,8.740,6.430,23173451776.0,16404480.0,23683072.0,8323870720.0,14426112.0,139408384.0,892.667,5304.333,91.333,491.333
01-06 21:34:45,3.601,1.549,70.142,24.665,0.0,0.042,14.710,8.930,6.500,23209844736.0,19050496.0,24375296.0,8284139520.0,11395072.0,27806378.667,704.0,1169.667,388.0,491.333
01-06 21:34:48,3.598,1.339,70.502,24.477,0.0,0.084,14.710,8.930,6.500,23241216000.0,21856256.0,24694784.0,8249643008.0,10891264.0,29597354.667,673.333,1228.0,319.333,491.333
01-06 21:34:51,3.886,1.546,68.993,25.449,0.042,0.084,14.890,9.060,6.560,23281037312.0,24322048.0,24920064.0,8207130624.0,12640256.0,26294272.0,781.667,1132.333,308.0,491.333
01-06 21:34:54,3.474,1.298,72.122,23.064,0.0,0.042,14.980,9.180,6.610,23308525568.0,26869760.0,25186304.0,8176828416.0,10212693.333,30378666.667,632.667,1258.0,313.333,491.333
01-06 21:34:57,3.682,1.506,70.837,23.891,0.0,0.084,14.980,9.180,6.610,23342288896.0,30072832.0,25194496.0,8139853824.0,10234538.667,41255082.667,633.333,1652.667,112.667,491.333
01-06 21:35:00,2.929,1.213,72.510,23.305,0.0,0.042,15.140,9.310,6.660,23365410816.0,32677888.0,25710592.0,8113610752.0,8007680.0,33439402.667,496.333,1349.0,329.333,514.667
01-06 21:35:03,3.262,1.255,71.769,23.630,0.042,0.042,15.140,9.310,6.660,23392972800.0,35315712.0,25821184.0,8083300352.0,8907434.667,33094314.667,551.333,1328.667,406.667,491.333
01-06 21:35:06,3.018,1.299,69.447,26.194,0.0,0.042,15.210,9.420,6.710,23416045568.0,37961728.0,26107904.0,8057294848.0,8059562.667,34648405.333,500.0,1374.0,1974.333,2100.0
01-06 21:35:09,3.181,1.046,70.364,25.366,0.0,0.042,15.430,9.560,6.770,23445331968.0,40132608.0,26550272.0,8025395200.0,9610581.333,22283946.667,595.667,964.333,198.0,491.333
01-06 21:35:12,3.098,1.130,72.457,23.273,0.0,0.042,15.430,9.560,6.770,23483260928.0,41140224.0,26877952.0,7986130944.0,12315306.667,974677.333,762.0,203.667,321.333,512.667
01-06 21:35:15,4.431,1.505,72.074,21.948,0.0,0.042,15.720,9.720,6.840,23533735936.0,42483712.0,27168768.0,7934021632.0,16681642.667,1306112.0,1033.333,274.333,236.0,491.333
01-06 21:35:18,4.895,1.674,70.126,23.222,0.0,0.084,15.720,9.720,6.840,23588003840.0,43999232.0,27553792.0,7877853184.0,18249045.333,1474218.667,1129.667,310.0,155.333,491.333
01-06 21:35:21,4.561,1.506,69.247,24.603,0.0,0.084,15.900,9.850,6.900,23640875008.0,45391872.0,27877376.0,7823265792.0,16879616.0,1348266.667,1045.0,281.0,300.0,491.333
01-06 21:35:24,5.353,1.882,67.127,25.512,0.042,0.084,15.830,9.940,6.940,23695736832.0,46972928.0,27992064.0,7766708224.0,19207509.333,1546581.333,1190.667,325.667,228.0,491.333
01-06 21:35:27,5.772,1.715,67.210,25.178,0.042,0.084,15.830,9.940,6.940,23758802944.0,48668672.0,28827648.0,7701110784.0,20155050.667,1645909.333,1249.0,346.333,545.333,486.0
01-06 21:35:30,6.245,1.802,67.687,24.225,0.0,0.042,15.840,10.040,6.990,23826329600.0,50511872.0,28852224.0,7631716352.0,21852160.0,1791658.667,1353.333,377.0,238.667,491.333
01-06 21:35:33,6.247,1.803,68.721,23.145,0.0,0.084,15.840,10.040,6.990,23891546112.0,52404224.0,29794304.0,7563665408.0,22126592.0,1835520.0,1372.0,385.333,466.0,525.333
01-06 21:35:36,6.399,2.091,66.207,25.220,0.0,0.084,15.930,10.150,7.040,23956750336.0,54312960.0,30478336.0,7495868416.0,22245376.0,1868800.0,1379.0,393.0,362.0,491.333
01-06 21:35:39,6.370,2.096,64.795,26.572,0.042,0.126,15.940,10.250,7.090,24023986176.0,56262656.0,30941184.0,7426220032.0,22771029.333,1901568.0,1412.333,400.0,570.0,491.333
01-06 21:35:42,7.373,1.969,62.128,28.404,0.0,0.126,15.940,10.250,7.090,24103849984.0,58392576.0,31559680.0,7343607808.0,24670208.0,2075648.0,1528.667,437.333,198.0,491.333
01-06 21:35:45,7.161,2.178,65.452,25.042,0.042,0.126,16.100,10.380,7.150,24175521792.0,60456960.0,32190464.0,7269240832.0,24246954.667,2032298.667,1501.333,428.333,110.667,491.333
01-06 21:35:48,6.695,1.937,62.021,29.221,0.0,0.126,16.100,10.380,7.150,24248844288.0,62554112.0,32710656.0,7193300992.0,23719936.0,2050389.333,1471.0,431.333,236.0,491.333
01-06 21:35:51,6.871,2.137,64.223,26.644,0.0,0.126,16.420,10.540,7.220,24318214144.0,64651264.0,33361920.0,7121182720.0,23330816.0,2047658.667,1446.667,432.0,157.333,491.333
01-06 21:35:54,6.957,2.137,63.412,27.368,0.0,0.126,16.700,10.700,7.290,24387710976.0,66764800.0,33751040.0,7049183232.0,23995733.333,2063018.667,1487.333,435.0,894.333,491.333
01-06 21:35:57,7.338,2.306,62.642,27.673,0.0,0.042,16.700,10.700,7.290,24463560704.0,68993024.0,34590720.0,6970265600.0,24413525.333,2171221.333,1514.333,456.0,198.0,736.667
01-06 21:36:00,7.047,2.181,61.829,28.775,0.042,0.126,16.890,10.830,7.350,24532652032.0,71172096.0,35192832.0,6898393088.0,23983445.333,2121728.0,1488.333,446.667,112.667,491.333
01-06 21:36:03,7.389,2.225,62.720,27.498,0.0,0.168,16.890,10.830,7.350,24608874496.0,73449472.0,35872768.0,6819213312.0,24795818.667,2227029.333,1538.0,469.333,236.0,491.333
01-06 21:36:06,7.485,2.523,61.354,28.469,0.0,0.168,16.890,10.940,7.400,24688967680.0,75808768.0,36683776.0,6735949824.0,25049770.667,2295466.667,1554.667,483.333,1887.0,1980.667
01-06 21:36:09,7.293,2.347,61.651,28.500,0.042,0.168,16.900,11.040,7.450,24760786944.0,78069760.0,37208064.0,6661345280.0,24480426.667,2218666.667,1518.333,466.667,176.667,491.333
01-06 21:36:12,7.854,2.058,60.815,29.147,0.0,0.126,16.900,11.040,7.450,24834240512.0,80396288.0,37867520.0,6584905728.0,24993792.0,2287616.0,1551.333,483.333,497.667,512.667
01-06 21:36:15,7.686,2.142,61.487,28.559,0.0,0.126,16.910,11.130,7.500,24910082048.0,82755584.0,38592512.0,6505979904.0,24502272.0,2301610.667,1521.0,486.0,191.333,491.333
01-06 21:36:18,7.837,2.347,61.903,27.745,0.042,0.126,16.910,11.130,7.500,24983478272.0,85131264.0,39260160.0,6429540352.0,24763050.667,2334378.667,1537.333,491.667,515.333,525.333
01-06 21:36:21,7.515,2.267,61.461,28.631,0.0,0.126,17.0,11.250,7.560,25059827712.0,87457792.0,40017920.0,6350106624.0,23815509.333,3684352.0,1479.667,487.0,438.667,491.333
01-06 21:36:24,7.728,2.352,57.707,32.045,0.042,0.126,17.160,11.380,7.620,25131327488.0,89808896.0,40153088.0,6276120576.0,24143189.333,2310826.667,1499.333,489.667,322.0,486.0
01-06 21:36:27,7.818,2.396,61.244,28.373,0.0,0.168,17.160,11.380,7.620,25204346880.0,92225536.0,41418752.0,6199418880.0,24735744.0,2396501.333,1537.667,501.667,134.0,491.333
01-06 21:36:30,7.809,2.477,59.068,30.521,0.0,0.126,17.220,11.490,7.680,25280086016.0,94683136.0,42147840.0,6120493056.0,24653824.0,2440192.0,1532.333,513.333,112.667,491.333
01-06 21:36:33,8.190,2.394,58.463,30.743,0.042,0.168,17.220,11.490,7.680,25355898880.0,97181696.0,42881024.0,6041448448.0,25552213.333,2471253.333,1587.333,525.333,204.667,491.333
01-06 21:36:36,8.774,2.561,57.683,30.772,0.0,0.210,17.370,11.610,7.740,25437753344.0,99942400.0,43601920.0,5956112384.0,26542080.0,2684586.667,1649.667,563.667,238.0,491.333
01-06 21:36:39,8.995,2.480,56.620,31.778,0.0,0.126,17.500,11.730,7.800,25515532288.0,102686720.0,44355584.0,5874835456.0,26367317.333,2943829.333,1640.667,571.667,316.667,491.333
01-06 21:36:42,8.543,2.429,57.831,30.946,0.042,0.209,17.500,11.730,7.800,25551310848.0,105357312.0,45240320.0,5835501568.0,25418410.667,5913258.667,1579.333,644.333,249.333,491.333
01-06 21:36:45,8.512,2.516,59.078,29.769,0.0,0.126,17.380,11.800,7.840,25564188672.0,106102784.0,46120960.0,5820997632.0,24775338.667,4251648.0,1541.333,609.667,155.333,491.333
01-06 21:36:48,8.435,2.392,58.246,30.760,0.042,0.126,17.380,11.800,7.840,25568493568.0,106819584.0,46563328.0,5815533568.0,24974677.333,5348181.333,1551.0,625.667,236.0,491.333
01-06 21:36:51,7.647,2.101,62.017,28.151,0.0,0.084,17.350,11.890,7.890,25568108544.0,107876352.0,48181248.0,5813243904.0,22634496.0,4389717.333,1397.0,586.667,417.0,491.333
Raw
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/
Raw
result.txt
########################################################################################################
### 20140601213239 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
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: 50000
other: 20000
total: 210000
transactions: 10000 (1082.18 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (20561.46 per sec.)
other operations: 20000 (2164.36 per sec.)
Test execution summary:
total time: 9.2406s
total number of events: 10000
total time taken by event execution: 147.7186
per-request statistics:
min: 6.97ms
avg: 14.77ms
max: 126.92ms
approx. 95 percentile: 21.01ms
Threads fairness:
events (avg/stddev): 625.0000/5.14
execution time (avg/stddev): 9.2324/0.00
########################################################################################################
### 20140601213249 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
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: 50000
other: 20000
total: 210000
transactions: 10000 (968.49 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (18401.33 per sec.)
other operations: 20000 (1936.98 per sec.)
Test execution summary:
total time: 10.3253s
total number of events: 10000
total time taken by event execution: 165.0665
per-request statistics:
min: 6.57ms
avg: 16.51ms
max: 151.11ms
approx. 95 percentile: 24.47ms
Threads fairness:
events (avg/stddev): 625.0000/6.73
execution time (avg/stddev): 10.3167/0.00
########################################################################################################
### 20140601213300 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
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: 50000
other: 20000
total: 210000
transactions: 10000 (102.32 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (1944.11 per sec.)
other operations: 20000 (204.64 per sec.)
Test execution summary:
total time: 97.7312s
total number of events: 10000
total time taken by event execution: 1562.5940
per-request statistics:
min: 39.37ms
avg: 156.26ms
max: 458.96ms
approx. 95 percentile: 237.53ms
Threads fairness:
events (avg/stddev): 625.0000/6.19
execution time (avg/stddev): 97.6621/0.04
########################################################################################################
### 20140601213438 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
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: 50000
other: 20000
total: 210000
transactions: 10000 (75.68 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (1437.88 per sec.)
other operations: 20000 (151.36 per sec.)
Test execution summary:
total time: 132.1393s
total number of events: 10000
total time taken by event execution: 2112.8799
per-request statistics:
min: 42.47ms
avg: 211.29ms
max: 1087.91ms
approx. 95 percentile: 482.29ms
Threads fairness:
events (avg/stddev): 625.0000/5.28
execution time (avg/stddev): 132.0550/0.04
Raw
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-dist-type=uniform \
--num-threads=16 --max-time=180 --oltp-test-mode=complex \
run >> $SYSBENCH_LOG
echo ""
done
kill $PID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment