Skip to content

Instantly share code, notes, and snippets.

@s-tajima

s-tajima/dstat_sysbench.csv

Created June 1, 2014 03:48
Show Gist options
  • Save s-tajima/ad35aa30099b51f9bffc to your computer and use it in GitHub Desktop.
Save s-tajima/ad35aa30099b51f9bffc to your computer and use it in GitHub Desktop.
Download ZIP
sysbench result at 2014/06/01 Case5
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 <dag@wieers.com>",,,,"URL:","http://dag.wieers.com/home-made/dstat/"
"Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root"
"Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:46:05 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:46:05,1.447,0.485,97.766,0.283,0.003,0.016,1.910,3.500,5.200,4435611648.0,1564672.0,697929728.0,26402304000.0,491903.746,3429070.843,31.376,220.633,0.0,0.0
01-06 21:46:08,46.205,16.722,22.686,12.886,0.542,0.959,1.910,3.500,5.200,5218349056.0,24522752.0,31113216.0,26263425024.0,267513856.0,19592533.333,16444.333,3278.333,667.333,3196.0
01-06 21:46:11,56.355,17.298,1.936,22.685,0.715,1.010,2.880,3.670,5.250,6063812608.0,48705536.0,36384768.0,25388507136.0,281077077.333,23334912.0,17360.333,3647.667,628.0,3692.0
01-06 21:46:14,65.923,21.329,1.641,9.087,0.841,1.178,2.880,3.670,5.250,7117316096.0,78704640.0,43950080.0,24297439232.0,349305514.667,31391744.0,21597.667,5012.667,479.333,491.333
01-06 21:46:17,54.914,18.235,15.726,9.703,0.586,0.836,3.530,3.800,5.280,7923257344.0,569344.0,23359488.0,23590223872.0,267722752.0,24170496.0,16508.333,4101.333,350.667,2100.0
01-06 21:46:20,65.565,22.510,1.004,8.368,1.213,1.339,4.210,3.930,5.310,8997691392.0,10125312.0,29806592.0,22499786752.0,355165525.333,174718293.333,21927.333,8963.667,246.667,687.333
01-06 21:46:23,61.442,21.509,1.542,13.005,1.000,1.501,4.210,3.930,5.310,9923833856.0,21741568.0,36093952.0,21555740672.0,307097600.0,211788458.667,18969.333,10028.667,278.667,491.333
01-06 21:46:26,67.238,21.590,0.753,8.117,1.046,1.255,4.590,4.020,5.330,10886983680.0,30777344.0,43229184.0,20576419840.0,319971328.0,162108245.333,19789.333,8730.333,134.0,491.333
01-06 21:46:29,36.910,10.772,34.405,16.910,0.418,0.585,4.590,4.020,5.330,11384631296.0,1302528.0,23408640.0,20128067584.0,165137066.667,6223360.0,10161.667,1912.333,157.333,530.667
01-06 21:46:32,10.839,4.892,46.774,36.778,0.169,0.548,5.750,4.260,5.410,11469197312.0,4288512.0,23797760.0,20040126464.0,26656768.0,190355797.333,1646.0,6870.333,134.0,491.333
01-06 21:46:35,10.433,4.670,46.950,37.274,0.126,0.547,6.650,4.470,5.470,11545624576.0,7385088.0,24350720.0,19960049664.0,26639018.667,171467434.667,1644.333,6251.333,322.667,491.333
01-06 21:46:38,9.688,4.212,52.443,32.940,0.211,0.505,6.650,4.470,5.470,11625472000.0,10563584.0,24817664.0,19876556800.0,27037696.0,145600170.667,1669.333,5427.333,402.0,491.333
01-06 21:46:41,6.077,1.928,69.363,22.590,0.0,0.042,7.230,4.630,5.510,11707244544.0,13611008.0,25341952.0,19791212544.0,26929834.667,2427562.667,1661.667,537.0,195.0,491.333
01-06 21:46:44,6.205,1.803,69.182,22.683,0.0,0.126,7.230,4.630,5.510,11791585280.0,16830464.0,25747456.0,19703246848.0,27155114.667,2544981.333,1675.667,565.667,198.0,491.333
01-06 21:46:47,5.848,2.130,67.377,24.478,0.042,0.125,8.180,4.870,5.580,11871981568.0,19869696.0,26337280.0,19619221504.0,25837568.0,2398890.667,1596.333,533.0,351.333,491.333
01-06 21:46:50,6.122,1.929,70.524,21.342,0.0,0.084,8.960,5.090,5.650,11953991680.0,23363584.0,26812416.0,19533242368.0,26996736.0,2520405.333,1663.667,563.0,228.0,491.333
01-06 21:46:53,5.818,1.884,70.364,21.850,0.0,0.084,8.960,5.090,5.650,12027117568.0,26361856.0,27254784.0,19456675840.0,25789781.333,2411178.667,1592.667,531.667,251.333,491.333
01-06 21:46:56,6.156,2.052,71.399,20.310,0.0,0.084,9.690,5.300,5.720,12111958016.0,29556736.0,27820032.0,19368075264.0,27058176.0,2534058.667,1669.667,561.333,289.333,491.333
01-06 21:46:59,6.198,2.052,69.389,22.236,0.0,0.126,9.690,5.300,5.720,12196282368.0,32817152.0,28303360.0,19280007168.0,27062272.0,2590549.333,1671.333,573.333,646.667,514.667
01-06 21:47:02,5.991,2.095,70.381,21.366,0.0,0.168,10.350,5.510,5.780,12273823744.0,36175872.0,28807168.0,19198603264.0,26959872.0,2646016.0,1665.0,588.333,394.0,491.333
01-06 21:47:05,5.850,2.020,69.024,23.022,0.0,0.084,11.040,5.740,5.850,12354895872.0,39616512.0,29286400.0,19113611264.0,26598058.667,2625536.0,1641.333,581.0,1846.667,1037.667
01-06 21:47:08,6.087,1.973,68.682,23.132,0.0,0.126,11.040,5.740,5.850,12434845696.0,42917888.0,29790208.0,19029856256.0,26966698.667,2606421.333,1664.333,576.667,566.333,1580.333
01-06 21:47:11,6.166,2.097,68.918,22.651,0.042,0.126,11.760,5.970,5.930,12518420480.0,46268416.0,30298112.0,18942423040.0,27247957.333,2658304.0,1682.667,590.333,257.333,534.0
01-06 21:47:14,6.211,1.930,67.898,23.877,0.0,0.084,11.760,5.970,5.930,12600639488.0,49606656.0,30846976.0,18856316928.0,26566656.0,4048213.333,1641.0,589.0,592.0,799.333
01-06 21:47:17,6.297,1.889,68.346,23.384,0.0,0.084,12.420,6.210,6.0,12680175616.0,53096448.0,31313920.0,18772824064.0,26852010.667,2738858.667,1658.667,610.0,70.0,491.333
01-06 21:47:20,6.216,1.890,69.677,22.092,0.0,0.126,12.550,6.330,6.050,12762079232.0,56406016.0,31952896.0,18686971904.0,26737322.667,2640554.667,1652.667,584.667,374.667,491.333
01-06 21:47:23,6.370,2.054,69.698,21.710,0.042,0.126,12.550,6.330,6.050,12839669760.0,59904000.0,32395264.0,18605441024.0,26678613.333,2756608.0,1648.0,612.667,300.0,491.333
01-06 21:47:26,6.415,2.264,67.086,24.193,0.0,0.042,12.820,6.500,6.100,12920139776.0,63418368.0,33009664.0,18520842240.0,26715477.333,2778453.333,1652.0,615.667,240.667,491.333
01-06 21:47:29,6.460,1.930,68.834,22.651,0.0,0.126,12.820,6.500,6.100,13002293248.0,66818048.0,33562624.0,18434736128.0,26513408.0,2710698.667,1637.667,600.0,270.667,491.333
01-06 21:47:32,6.538,1.928,69.656,21.752,0.0,0.126,13.480,6.740,6.180,13081780224.0,70242304.0,34144256.0,18351243264.0,26718208.0,2715648.0,1652.0,601.667,176.667,491.333
01-06 21:47:35,6.781,2.009,67.392,23.692,0.0,0.126,13.600,6.870,6.230,13162070016.0,73805824.0,34619392.0,18266914816.0,26776917.333,2820778.667,1655.667,627.333,389.333,525.333
01-06 21:47:38,6.420,1.930,66.345,25.136,0.042,0.126,13.600,6.870,6.230,13242142720.0,77262848.0,35217408.0,18182787072.0,26056021.333,4190208.0,1610.667,616.0,382.0,491.333
01-06 21:47:41,6.376,2.139,67.072,24.287,0.0,0.126,14.270,7.120,6.310,13321752576.0,80625664.0,35745792.0,18099286016.0,26507946.667,2805760.0,1638.667,618.0,155.333,512.667
01-06 21:47:44,6.745,1.927,66.318,24.843,0.0,0.168,14.270,7.120,6.310,13401473024.0,82169856.0,36331520.0,18017435648.0,26510677.333,2801664.0,1639.667,618.667,198.0,491.333
01-06 21:47:47,6.415,2.306,66.541,24.570,0.0,0.168,14.650,7.320,6.380,13481496576.0,83570688.0,36900864.0,17935441920.0,26353664.0,2846720.0,1629.667,633.0,455.333,491.333
01-06 21:47:50,6.664,2.137,66.639,24.476,0.0,0.084,15.0,7.510,6.450,13563469824.0,84963328.0,37482496.0,17851494400.0,26572117.333,2893141.333,1643.333,641.0,274.667,658.667
01-06 21:47:53,6.376,1.971,67.114,24.287,0.042,0.210,15.0,7.510,6.450,13634375680.0,86540288.0,38318080.0,17778176000.0,25395200.0,2827605.333,1569.333,628.333,352.0,682.667
01-06 21:47:56,7.017,1.933,68.445,22.521,0.0,0.084,15.400,7.720,6.520,13718200320.0,88256512.0,38940672.0,17692012544.0,27178325.333,3010560.0,1680.0,667.333,996.667,1936.667
01-06 21:47:59,6.868,2.261,64.782,25.921,0.0,0.168,15.400,7.720,6.520,13797953536.0,90042368.0,39505920.0,17609908224.0,26953045.333,3042474.667,1667.333,676.333,545.667,491.333
01-06 21:48:02,6.960,2.096,67.925,22.809,0.042,0.168,15.690,7.910,6.590,13882093568.0,91533312.0,40046592.0,17523736576.0,26917546.667,2988714.667,1665.0,662.333,351.333,491.333
01-06 21:48:05,7.238,2.259,66.151,24.184,0.0,0.167,16.030,8.110,6.660,13959991296.0,93401088.0,40685568.0,17443332096.0,26809685.333,3018752.0,1659.0,673.0,1559.333,1003.667
01-06 21:48:08,6.804,2.100,64.637,26.375,0.0,0.084,16.030,8.110,6.660,14039896064.0,95100928.0,41185280.0,17361227776.0,26502485.333,3076096.0,1640.333,684.333,606.0,1383.0
01-06 21:48:11,7.014,2.100,65.099,25.661,0.0,0.126,16.190,8.270,6.720,14123991040.0,96641024.0,41840640.0,17274937344.0,26827434.667,3100672.0,1659.333,684.333,690.667,512.667
01-06 21:48:14,6.891,2.101,65.0,25.756,0.042,0.210,16.190,8.270,6.720,14201692160.0,98525184.0,42389504.0,17194803200.0,26462890.667,3072000.0,1637.667,683.333,500.667,491.333
01-06 21:48:17,7.389,1.847,69.437,21.201,0.0,0.126,16.330,8.430,6.780,14281936896.0,100208640.0,43065344.0,17112199168.0,26494293.333,3193514.667,1640.333,710.333,176.667,491.333
01-06 21:48:20,7.257,2.097,66.779,23.700,0.0,0.168,16.310,8.560,6.830,14359756800.0,101842944.0,43753472.0,17032056832.0,26617173.333,3114325.333,1646.333,689.333,398.0,620.0
01-06 21:48:23,7.260,2.140,64.205,26.227,0.0,0.168,16.310,8.560,6.830,14443741184.0,104534016.0,44638208.0,16944496640.0,27067733.333,3265877.333,1667.667,724.0,538.0,1296.0
01-06 21:48:26,7.185,2.269,65.756,24.664,0.0,0.126,16.600,8.750,6.900,14519345152.0,106127360.0,45240320.0,16866697216.0,26233514.667,3158016.0,1624.333,701.333,950.667,1324.667
01-06 21:48:29,7.332,2.149,65.529,24.821,0.042,0.126,16.600,8.750,6.900,14599614464.0,107704320.0,45879296.0,16784211968.0,27164672.0,3347797.333,1682.667,742.667,1046.0,1136.0
01-06 21:48:32,7.254,2.264,63.270,27.044,0.0,0.168,16.710,8.900,6.960,14683467776.0,109322240.0,46571520.0,16698048512.0,26566656.0,3224917.333,1645.667,717.333,1011.333,1092.667
01-06 21:48:35,7.460,2.305,64.124,25.943,0.0,0.168,16.820,9.050,7.020,14763466752.0,110804992.0,47194112.0,16615944192.0,26424661.333,3325952.0,1637.667,741.0,585.333,966.667
01-06 21:48:38,6.471,2.143,65.672,25.588,0.0,0.126,16.820,9.050,7.020,14826483712.0,602112.0,20344832.0,16689979392.0,24211456.0,2986666.667,1465.667,661.333,423.333,491.333
01-06 21:48:41,8.880,3.914,47.896,38.721,0.042,0.547,16.910,9.200,7.080,14904025088.0,10133504.0,22761472.0,16600489984.0,21423445.333,164034901.333,1296.667,6384.667,297.333,530.667
01-06 21:48:44,4.355,1.843,64.824,28.769,0.0,0.209,16.910,9.200,7.080,14937436160.0,14245888.0,23109632.0,16562618368.0,11242154.667,70642688.0,693.333,2776.667,134.0,491.333
01-06 21:48:47,2.929,1.464,72.050,23.473,0.0,0.084,16.920,9.330,7.130,14969556992.0,15826944.0,23293952.0,16528732160.0,10618197.333,27104597.333,655.0,1114.0,278.667,491.333
01-06 21:48:50,2.919,1.293,72.185,23.520,0.0,0.083,17.330,9.540,7.210,14998929408.0,17805312.0,23461888.0,16497213440.0,9352533.333,31351125.333,577.0,1275.0,396.0,491.333
01-06 21:48:53,2.883,0.961,73.548,22.524,0.0,0.084,17.330,9.540,7.210,15026163712.0,19451904.0,23613440.0,16468180992.0,9349802.667,28181845.333,576.667,1149.333,478.333,491.333
01-06 21:48:56,3.142,1.382,73.230,22.162,0.0,0.084,17.300,9.660,7.260,15050895360.0,22122496.0,23662592.0,16440729600.0,9501354.667,45714090.667,586.667,1820.333,492.667,491.333
01-06 21:48:59,2.547,1.253,72.944,23.173,0.0,0.084,17.300,9.660,7.260,15082479616.0,24260608.0,23928832.0,16406740992.0,7666346.667,36506965.333,472.667,1447.333,176.667,491.333
01-06 21:49:02,2.592,1.087,70.903,25.376,0.0,0.042,17.590,9.850,7.340,15101476864.0,26275840.0,24076288.0,16385581056.0,7681365.333,34366634.667,474.667,1375.0,562.0,491.333
01-06 21:49:05,2.386,1.130,74.215,22.227,0.0,0.042,17.470,9.950,7.380,15118413824.0,28307456.0,24190976.0,16366497792.0,6646442.667,34747733.333,410.333,1372.0,1533.333,1037.667
01-06 21:49:08,2.463,1.127,74.697,21.670,0.0,0.042,17.470,9.950,7.380,15143718912.0,30199808.0,24317952.0,16339173376.0,7110656.0,32350890.667,439.0,1293.667,678.333,1507.667
01-06 21:49:11,2.715,0.961,70.343,25.898,0.042,0.042,17.190,10.020,7.420,15177134080.0,30879744.0,24530944.0,16304865280.0,11194368.0,11241813.333,691.333,526.667,330.0,512.667
01-06 21:49:14,2.920,1.043,74.301,21.694,0.0,0.042,17.190,10.020,7.420,15217184768.0,30887936.0,24764416.0,16264572928.0,12970666.667,432469.333,800.333,132.667,391.333,491.333
01-06 21:49:17,3.719,1.003,73.130,22.106,0.0,0.042,17.090,10.120,7.460,15265247232.0,30887936.0,25055232.0,16216219648.0,16322560.0,496810.667,1007.667,154.0,112.667,491.333
01-06 21:49:20,4.057,1.255,73.902,20.703,0.0,0.084,17.170,10.250,7.520,15319912448.0,30896128.0,25415680.0,16161185792.0,18453845.333,630954.667,1138.667,194.667,249.333,491.333
01-06 21:49:23,3.993,1.177,72.804,22.026,0.0,0.0,17.170,10.250,7.520,15379030016.0,30896128.0,25780224.0,16101703680.0,19240277.333,612181.333,1188.333,191.0,300.0,736.667
01-06 21:49:26,4.062,1.424,72.069,22.362,0.0,0.084,17.150,10.360,7.570,15431483392.0,30904320.0,26144768.0,16048877568.0,18707797.333,612352.0,1154.333,189.0,155.333,491.333
01-06 21:49:29,4.559,1.422,73.107,20.870,0.0,0.042,17.150,10.360,7.570,15496364032.0,30904320.0,26529792.0,15983611904.0,20384426.667,673792.0,1259.0,212.0,112.667,491.333
01-06 21:49:32,4.881,1.585,72.507,20.943,0.0,0.083,17.220,10.490,7.630,15563575296.0,30912512.0,26918912.0,15916003328.0,21525845.333,698026.667,1329.333,219.667,198.0,491.333
01-06 21:49:35,4.946,1.593,72.213,21.207,0.0,0.042,17.360,10.630,7.690,15628808192.0,30912512.0,27332608.0,15850356736.0,22260394.667,736256.0,1374.333,229.333,304.0,525.333
01-06 21:49:38,4.860,1.382,72.183,21.491,0.0,0.084,17.360,10.630,7.690,15691943936.0,30920704.0,27729920.0,15786815488.0,21555882.667,697856.0,1330.667,216.0,330.0,491.333
01-06 21:49:41,5.140,1.630,72.085,21.020,0.042,0.084,17.090,10.690,7.720,15759130624.0,30920704.0,28160000.0,15719198720.0,22601728.0,757760.0,1396.333,238.0,391.333,491.333
01-06 21:49:44,5.448,1.593,70.495,22.422,0.0,0.042,17.090,10.690,7.720,15830482944.0,30928896.0,28610560.0,15647387648.0,23647573.333,793429.333,1460.333,248.0,134.0,491.333
01-06 21:49:47,5.730,1.673,70.682,21.832,0.0,0.084,17.080,10.790,7.770,15902130176.0,30928896.0,29044736.0,15575306240.0,23954773.333,796330.667,1479.667,248.0,386.667,491.333
01-06 21:49:50,5.560,1.714,71.572,21.070,0.0,0.084,17.0,10.880,7.810,15973720064.0,30937088.0,29511680.0,15503241216.0,23573845.333,814762.667,1456.667,251.333,91.333,491.333
01-06 21:49:53,5.320,1.466,69.041,24.089,0.0,0.084,17.0,10.880,7.810,16047157248.0,30937088.0,29974528.0,15429341184.0,22805162.667,785408.0,1407.667,243.0,388.0,491.333
01-06 21:49:56,5.604,1.715,70.849,21.748,0.0,0.084,17.0,10.980,7.860,16114413568.0,30945280.0,30453760.0,15361597440.0,23538346.667,808277.333,1455.0,248.0,249.333,491.333
01-06 21:49:59,5.448,1.718,70.956,21.836,0.0,0.042,17.0,10.980,7.860,16185880576.0,30945280.0,30916608.0,15289667584.0,23691264.0,791893.333,1463.0,246.0,134.0,491.333
01-06 21:50:02,5.402,1.759,70.561,22.152,0.0,0.126,16.520,10.980,7.880,16255602688.0,30953472.0,31408128.0,15219445760.0,23562922.667,2212864.0,1456.333,253.333,195.0,491.333
01-06 21:50:05,5.663,1.762,68.163,24.329,0.0,0.084,16.560,11.080,7.930,16329363456.0,30953472.0,31940608.0,15145152512.0,23617536.0,857088.0,1459.0,259.333,1957.0,1194.0
01-06 21:50:08,5.668,1.427,69.605,23.132,0.042,0.126,16.560,11.080,7.930,16400711680.0,30961664.0,32411648.0,15073325056.0,23812778.667,843434.667,1472.667,260.333,686.667,1208.667
01-06 21:50:11,5.905,1.717,69.933,22.404,0.0,0.042,16.510,11.160,7.970,16474103808.0,30961664.0,32919552.0,14999425024.0,24397141.333,867669.333,1507.333,272.0,385.333,512.667
01-06 21:50:14,5.949,1.634,68.622,23.670,0.0,0.126,16.510,11.160,7.970,16545513472.0,30969856.0,33439744.0,14927486976.0,24260608.0,882688.0,1500.333,269.667,353.333,491.333
01-06 21:50:17,5.739,1.801,72.015,20.318,0.0,0.126,16.630,11.270,8.030,16621273088.0,30969856.0,33931264.0,14851235840.0,23851008.0,851797.333,1473.667,267.0,176.667,491.333
01-06 21:50:20,5.742,1.802,69.070,23.345,0.0,0.042,16.740,11.380,8.080,16690749440.0,30978048.0,34414592.0,14781267968.0,23774549.333,870570.667,1470.333,269.333,821.0,525.333
01-06 21:50:23,5.786,1.719,69.266,23.103,0.0,0.126,16.740,11.380,8.080,16759943168.0,30978048.0,34934784.0,14711554048.0,23852373.333,863744.0,1475.333,268.333,436.667,491.333
01-06 21:50:26,6.148,1.840,70.891,20.995,0.042,0.084,16.760,11.480,8.130,16835837952.0,30986240.0,35434496.0,14635151360.0,24061269.333,887466.667,1487.333,276.667,270.667,491.333
01-06 21:50:29,6.090,1.722,69.509,22.638,0.0,0.042,16.760,11.480,8.130,16907272192.0,30986240.0,35938304.0,14563213312.0,24693418.667,914090.667,1527.0,287.0,155.333,491.333
01-06 21:50:32,5.959,1.679,71.968,20.269,0.0,0.126,16.860,11.580,8.180,16980758528.0,31129600.0,36462592.0,14489059328.0,24197802.667,927402.667,1494.667,291.667,932.0,491.333
01-06 21:50:35,6.226,1.880,69.787,22.023,0.0,0.084,16.950,11.690,8.230,17056514048.0,31133696.0,36962304.0,14412800000.0,24177322.667,900437.333,1495.667,281.667,551.667,653.333
01-06 21:50:38,6.106,1.840,69.260,22.710,0.0,0.084,16.950,11.690,8.230,17125695488.0,31141888.0,37478400.0,14343094272.0,24058538.667,906410.667,1488.333,282.333,306.0,653.333
01-06 21:50:41,6.025,2.008,70.0,21.799,0.042,0.126,17.030,11.800,8.280,17197113344.0,31141888.0,37998592.0,14271156224.0,24252416.0,912725.333,1499.333,286.667,372.667,491.333
01-06 21:50:44,6.279,1.884,69.820,21.892,0.0,0.126,17.030,11.800,8.280,17270493184.0,31150080.0,38518784.0,14197248000.0,24544597.333,944128.0,1518.667,295.667,289.333,491.333
01-06 21:50:47,6.289,2.013,67.505,24.109,0.0,0.084,17.110,11.900,8.340,17348198400.0,31150080.0,39059456.0,14119002112.0,24791722.667,962901.333,1533.333,302.667,495.0,491.333
01-06 21:50:50,6.510,1.848,69.467,22.008,0.042,0.126,17.180,12.0,8.390,17423765504.0,31158272.0,39616512.0,14042869760.0,25426602.667,977066.667,1573.0,306.333,324.333,491.333
01-06 21:50:53,6.653,1.883,68.536,22.803,0.0,0.126,17.180,12.0,8.390,17497620480.0,31158272.0,40161280.0,13968470016.0,24772608.0,980650.667,1532.333,307.0,356.0,491.333
01-06 21:50:56,6.907,1.884,70.113,20.971,0.0,0.126,17.090,12.070,8.430,17572999168.0,31166464.0,40771584.0,13892472832.0,25462101.333,1061888.0,1577.0,327.333,468.667,491.333
01-06 21:50:59,6.664,2.096,67.687,23.470,0.0,0.084,17.090,12.070,8.430,17652748288.0,31166464.0,41349120.0,13812146176.0,25508522.667,1007957.333,1578.333,316.0,289.0,491.333
01-06 21:51:02,6.711,1.971,69.044,22.148,0.0,0.126,17.080,12.150,8.470,17726341120.0,31174656.0,41910272.0,13737984000.0,25395200.0,1012736.0,1571.0,316.0,155.333,491.333
01-06 21:51:05,7.035,1.926,67.672,23.199,0.042,0.126,16.990,12.210,8.510,17804128256.0,31174656.0,42479616.0,13659627520.0,25427968.0,1034581.333,1574.667,323.333,1886.333,1228.0
01-06 21:51:08,6.963,1.888,67.953,23.029,0.0,0.168,16.990,12.210,8.510,17886076928.0,31182848.0,43081728.0,13577068544.0,25647786.667,1055402.667,1587.333,328.0,701.333,1182.0
01-06 21:51:11,7.191,2.174,67.057,23.495,0.0,0.084,17.150,12.320,8.570,17959624704.0,31182848.0,43687936.0,13502914560.0,25776128.0,1080320.0,1595.667,339.0,372.667,512.667
01-06 21:51:14,6.804,1.932,67.577,23.562,0.0,0.126,17.150,12.320,8.570,18033176576.0,31191040.0,44281856.0,13428760576.0,25565866.667,1060181.333,1584.0,330.0,193.333,491.333
01-06 21:51:17,7.002,2.055,68.595,22.264,0.0,0.084,17.140,12.400,8.620,18115112960.0,31191040.0,44888064.0,13346217984.0,25445717.333,1069738.667,1575.667,335.667,194.667,514.667
01-06 21:51:20,7.245,2.052,65.494,25.084,0.042,0.084,17.130,12.480,8.660,18188644352.0,31199232.0,45510656.0,13272055808.0,25417045.333,1094826.667,1573.333,340.333,586.667,491.333
01-06 21:51:23,7.197,2.092,66.025,24.519,0.042,0.126,17.130,12.480,8.660,18264424448.0,31199232.0,46116864.0,13195669504.0,25242282.667,1084928.0,1564.333,340.667,330.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
########################################################################################################
### 20140601214605 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 (930.42 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (17677.96 per sec.)
other operations: 20000 (1860.84 per sec.)
Test execution summary:
total time: 10.7478s
total number of events: 10000
total time taken by event execution: 171.8298
per-request statistics:
min: 7.98ms
avg: 17.18ms
max: 126.65ms
approx. 95 percentile: 23.44ms
Threads fairness:
events (avg/stddev): 625.0000/3.39
execution time (avg/stddev): 10.7394/0.00
########################################################################################################
### 20140601214616 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 (925.90 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (17592.01 per sec.)
other operations: 20000 (1851.79 per sec.)
Test execution summary:
total time: 10.8004s
total number of events: 10000
total time taken by event execution: 172.6262
per-request statistics:
min: 7.70ms
avg: 17.26ms
max: 223.53ms
approx. 95 percentile: 24.16ms
Threads fairness:
events (avg/stddev): 625.0000/4.78
execution time (avg/stddev): 10.7891/0.00
########################################################################################################
### 20140601214628 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 (77.22 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (1467.19 per sec.)
other operations: 20000 (154.44 per sec.)
Test execution summary:
total time: 129.4991s
total number of events: 10000
total time taken by event execution: 2070.9633
per-request statistics:
min: 68.11ms
avg: 207.10ms
max: 579.12ms
approx. 95 percentile: 297.23ms
Threads fairness:
events (avg/stddev): 625.0000/4.91
execution time (avg/stddev): 129.4352/0.03
########################################################################################################
### 20140601214838 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 (60.23 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (1144.31 per sec.)
other operations: 20000 (120.45 per sec.)
Test execution summary:
total time: 166.0386s
total number of events: 10000
total time taken by event execution: 2655.7024
per-request statistics:
min: 58.86ms
avg: 265.57ms
max: 1567.16ms
approx. 95 percentile: 574.42ms
Threads fairness:
events (avg/stddev): 625.0000/5.12
execution time (avg/stddev): 165.9814/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