Created
June 1, 2014 03:48
-
-
Save s-tajima/ad35aa30099b51f9bffc to your computer and use it in GitHub Desktop.
sysbench result at 2014/06/01 Case5
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: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 |
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
######################################################################################################## | |
### 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 |
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