Created
June 1, 2014 03:37
-
-
Save s-tajima/7f06821de83f6b096828 to your computer and use it in GitHub Desktop.
sysbench result at 2014/06/01 Case4
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
######################################################################################################## | |
### 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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