Skip to content

Instantly share code, notes, and snippets.

@s-tajima

s-tajima/dstat_sysbench.csv

Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save s-tajima/094d86c3cc1555ae7f4c to your computer and use it in GitHub Desktop.
Save s-tajima/094d86c3cc1555ae7f4c to your computer and use it in GitHub Desktop.
Download ZIP
sysbench result at 2014/06/01 Case6
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:","02 Jun 2014 21:45:55 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"
02-06 21:45:55,1.084,0.410,98.231,0.260,0.003,0.012,2.0,2.0,2.0,18437144576.0,2654208.0,20963328.0,13076647936.0,510231.452,2617234.166,28.788,164.497,0.0,0.0
02-06 21:45:58,59.003,17.337,14.196,7.580,0.628,1.256,2.720,2.150,2.050,19183427584.0,29376512.0,29335552.0,12295270400.0,255862101.333,24465408.0,15827.0,4970.667,286.0,1100.0
02-06 21:46:01,63.321,18.235,3.722,12.882,0.544,1.297,2.720,2.150,2.050,19931938816.0,58503168.0,36749312.0,11510218752.0,248360960.0,27800917.333,15404.0,5361.0,672.0,678.667
02-06 21:46:04,68.417,18.606,3.444,7.518,0.630,1.386,3.620,2.350,2.110,20281298944.0,82706432.0,44834816.0,11128569856.0,260814165.333,47950506.667,16201.333,6486.667,396.0,653.333
02-06 21:46:07,54.663,16.395,18.904,8.114,0.669,1.255,4.130,2.470,2.150,20686360576.0,7389184.0,25985024.0,10817675264.0,212104533.333,137317034.667,13096.0,7442.667,2215.667,2004.0
02-06 21:46:10,69.670,21.569,0.751,5.549,0.876,1.585,4.130,2.470,2.150,21535064064.0,20013056.0,33873920.0,9948459008.0,280775338.667,228344149.333,17413.667,11093.0,259.333,680.0
02-06 21:46:13,71.620,20.804,0.963,4.311,0.753,1.549,4.600,2.600,2.200,22116290560.0,29417472.0,40259584.0,9351442432.0,268259328.0,184831488.0,16668.0,9612.333,530.667,486.0
02-06 21:46:16,41.475,11.269,32.090,13.951,0.419,0.796,4.600,2.600,2.200,22112387072.0,1503232.0,21876736.0,9401643008.0,142512128.0,102748160.0,8793.667,4944.333,242.667,530.667
02-06 21:46:19,11.322,4.924,38.426,44.655,0.126,0.547,5.200,2.750,2.250,22189793280.0,6017024.0,22941696.0,9318658048.0,26970794.667,144772266.667,1672.0,5257.333,176.667,491.333
02-06 21:46:22,12.135,5.074,35.349,46.808,0.127,0.507,6.140,2.990,2.330,22273171456.0,10768384.0,23650304.0,9229819904.0,28097194.667,160382293.333,1741.333,5864.667,469.0,491.333
02-06 21:46:25,10.509,4.372,46.448,38.125,0.126,0.420,6.140,2.990,2.330,22360211456.0,15482880.0,24498176.0,9137217536.0,27628885.333,104130218.667,1714.333,4004.0,283.333,491.333
02-06 21:46:28,8.190,2.436,57.035,32.171,0.0,0.168,6.850,3.190,2.400,22439661568.0,20324352.0,24977408.0,9052446720.0,28468565.333,3777024.0,1763.0,607.333,332.0,491.333
02-06 21:46:31,8.148,2.604,57.119,31.961,0.042,0.126,6.850,3.190,2.400,22530838528.0,25276416.0,25882624.0,8955412480.0,28190037.333,5259264.0,1750.333,620.0,300.667,491.333
02-06 21:46:34,8.225,2.686,56.148,32.732,0.042,0.168,7.740,3.430,2.480,22614859776.0,30330880.0,26398720.0,8865820672.0,28557312.0,3925333.333,1770.0,628.667,91.333,486.0
02-06 21:46:37,8.358,2.730,58.505,30.281,0.0,0.126,8.480,3.660,2.560,22698819584.0,35385344.0,27357184.0,8775847936.0,28265130.667,3945813.333,1755.333,632.333,505.667,491.333
02-06 21:46:40,8.508,2.682,56.035,32.565,0.042,0.168,8.480,3.660,2.560,22784131072.0,40488960.0,28385280.0,8684404736.0,28382549.333,3973120.0,1759.667,637.667,891.0,491.333
02-06 21:46:43,8.564,2.561,57.641,31.066,0.0,0.168,9.0,3.850,2.620,22866784256.0,45617152.0,28741632.0,8596267008.0,28140885.333,3989504.0,1746.667,639.333,661.333,491.333
02-06 21:46:46,8.878,2.806,55.905,32.161,0.042,0.209,9.0,3.850,2.620,22955651072.0,50810880.0,29126656.0,8501821440.0,28564138.667,4055040.0,1772.667,653.333,219.333,491.333
02-06 21:46:49,8.690,2.561,56.507,32.116,0.0,0.126,9.720,4.080,2.710,23039533056.0,56094720.0,30576640.0,8411205632.0,28158634.667,4107434.667,1748.0,656.667,415.333,491.333
02-06 21:46:52,8.092,2.767,55.472,33.501,0.0,0.168,10.550,4.350,2.800,23123632128.0,61059072.0,30978048.0,8321740800.0,26880682.667,3885738.667,1668.667,622.667,598.667,491.333
02-06 21:46:55,8.778,2.730,54.305,33.977,0.042,0.168,10.550,4.350,2.800,23209807872.0,66396160.0,32178176.0,8229027840.0,28614656.0,4164266.667,1775.333,670.0,274.667,653.333
02-06 21:46:58,8.843,2.724,56.035,32.188,0.042,0.168,11.220,4.590,2.890,23295631360.0,71770112.0,32542720.0,8137465856.0,28154538.667,4175701.333,1748.0,669.667,240.667,491.333
02-06 21:47:01,8.915,2.775,55.509,32.632,0.0,0.168,11.220,4.590,2.890,23378755584.0,77316096.0,33345536.0,8047992832.0,28431701.333,4295338.667,1765.0,689.0,471.333,491.333
02-06 21:47:04,9.338,2.931,54.397,33.166,0.042,0.126,11.770,4.810,2.970,23462068224.0,81801216.0,34635776.0,7958904832.0,28246016.0,4382720.0,1756.0,702.0,394.0,491.333
02-06 21:47:07,8.712,3.241,54.209,33.628,0.0,0.210,12.270,5.030,3.050,23551004672.0,83931136.0,35151872.0,7867322368.0,27903317.333,5756245.333,1735.333,701.333,2192.333,2130.0
02-06 21:47:10,9.091,2.946,52.862,34.891,0.042,0.168,12.270,5.030,3.050,23632183296.0,85901312.0,35983360.0,7783342080.0,28381184.0,4437333.333,1764.0,714.667,300.0,534.0
02-06 21:47:13,9.538,2.773,54.034,33.403,0.042,0.210,12.810,5.260,3.130,23715069952.0,88211456.0,36749312.0,7697379328.0,28730709.333,4524714.667,1785.0,727.667,575.333,658.667
02-06 21:47:16,9.374,2.816,51.955,35.687,0.0,0.168,12.810,5.260,3.130,23801769984.0,90767360.0,37273600.0,7607599104.0,28487680.0,4532906.667,1771.333,729.0,176.667,491.333
02-06 21:47:19,9.053,2.766,55.281,32.691,0.042,0.168,13.220,5.470,3.210,23844610048.0,93106176.0,38338560.0,7561355264.0,27227477.333,8978944.0,1690.667,851.0,134.0,491.333
02-06 21:47:22,9.320,2.939,53.149,34.425,0.042,0.126,13.520,5.660,3.290,23855022080.0,95490048.0,39202816.0,7547695104.0,27537408.0,7226709.333,1712.0,833.333,276.667,491.333
02-06 21:47:25,9.110,3.107,54.408,33.249,0.0,0.126,13.520,5.660,3.290,23859290112.0,98271232.0,40046592.0,7539802112.0,27454122.667,8140117.333,1708.333,867.333,397.333,653.333
02-06 21:47:28,9.480,2.894,52.978,34.438,0.042,0.168,13.960,5.890,3.370,23859421184.0,100646912.0,40841216.0,7536500736.0,27612501.333,7705088.0,1716.667,864.0,198.0,491.333
02-06 21:47:31,9.332,2.564,53.384,34.468,0.042,0.210,13.960,5.890,3.370,23859277824.0,102735872.0,41689088.0,7533707264.0,27530581.333,7562581.333,1712.333,846.0,712.0,491.333
02-06 21:47:34,9.324,2.688,53.213,34.565,0.042,0.168,14.200,6.070,3.440,23859273728.0,105488384.0,42487808.0,7530160128.0,27478698.667,7641770.667,1709.333,851.667,558.0,525.333
02-06 21:47:37,9.087,2.735,54.607,33.277,0.042,0.252,14.430,6.250,3.520,23861456896.0,107692032.0,43872256.0,7524388864.0,27364010.667,9183232.0,1701.0,859.333,535.333,514.667
02-06 21:47:40,8.621,2.565,54.626,34.104,0.0,0.084,14.430,6.250,3.520,23861600256.0,110227456.0,44367872.0,7521214464.0,25927680.0,7244458.667,1612.0,800.667,508.667,491.333
02-06 21:47:43,9.148,2.896,52.833,34.872,0.042,0.210,14.790,6.460,3.600,23861694464.0,113070080.0,44986368.0,7517659136.0,27293013.333,7413760.0,1699.0,841.333,219.333,491.333
02-06 21:47:46,6.717,2.687,65.617,24.727,0.042,0.210,14.790,6.460,3.600,23859314688.0,4198400.0,22130688.0,7651766272.0,17177258.667,63484928.0,1008.0,2657.0,518.0,530.667
02-06 21:47:49,8.386,3.329,54.741,33.038,0.042,0.464,15.050,6.650,3.680,23885275136.0,15740928.0,22446080.0,7613947904.0,15163392.0,162378069.333,941.0,6195.667,417.333,491.333
02-06 21:47:52,3.350,1.508,67.295,27.764,0.0,0.084,15.290,6.840,3.750,23913943040.0,19091456.0,22810624.0,7581564928.0,10152618.667,28960085.333,629.0,1231.333,379.333,491.333
02-06 21:47:55,3.220,1.464,70.263,24.927,0.042,0.084,15.290,6.840,3.750,23941308416.0,22466560.0,22806528.0,7550828544.0,9390762.667,31737173.333,581.667,1322.667,460.0,491.333
02-06 21:47:58,3.482,1.258,68.331,26.846,0.0,0.084,15.180,6.960,3.810,23972761600.0,25808896.0,23379968.0,7515459584.0,10395648.0,28423509.333,644.333,1216.333,334.667,491.333
02-06 21:48:01,3.639,1.380,69.051,25.847,0.0,0.084,15.180,6.960,3.810,24004108288.0,29388800.0,23752704.0,7480160256.0,10341034.667,32923648.0,640.667,1378.667,557.667,525.333
02-06 21:48:04,3.434,1.340,70.561,24.581,0.0,0.084,15.490,7.160,3.890,24038014976.0,32813056.0,23785472.0,7442796544.0,10169002.667,29010602.667,630.667,1243.0,236.0,736.667
02-06 21:48:07,3.595,1.589,68.395,26.296,0.0,0.125,15.610,7.320,3.960,24066056192.0,36405248.0,24002560.0,7410946048.0,9707520.0,31460010.667,601.333,1310.667,1692.0,1973.0
02-06 21:48:10,3.642,1.549,68.606,26.078,0.042,0.084,15.610,7.320,3.960,24093581312.0,40304640.0,24031232.0,7379492864.0,10366976.0,37898922.667,642.0,1562.333,663.667,579.0
02-06 21:48:13,2.887,1.297,69.665,26.067,0.0,0.084,15.720,7.480,4.030,24118423552.0,43655168.0,24616960.0,7350714368.0,7260842.667,36716544.0,450.333,1469.333,499.667,512.667
02-06 21:48:16,3.777,1.511,68.527,26.102,0.0,0.084,15.720,7.480,4.030,24158969856.0,47087616.0,24637440.0,7306715136.0,12416341.333,22609920.0,768.667,1049.0,219.333,491.333
02-06 21:48:19,3.988,1.343,69.270,25.357,0.0,0.042,15.900,7.660,4.100,24200581120.0,49717248.0,25505792.0,7261605888.0,15190698.667,2056704.0,942.0,330.0,240.667,491.333
02-06 21:48:22,4.658,1.511,66.849,26.899,0.0,0.084,16.230,7.860,4.190,24251052032.0,52699136.0,25358336.0,7208300544.0,16448170.667,2322432.0,1020.667,372.667,412.667,491.333
02-06 21:48:25,5.488,2.095,62.924,29.409,0.0,0.084,16.230,7.860,4.190,24308408320.0,56107008.0,26144768.0,7146749952.0,19439616.0,2635093.333,1204.667,422.0,400.667,658.667
02-06 21:48:28,5.393,1.923,64.339,28.261,0.0,0.084,16.690,8.100,4.280,24361619456.0,59408384.0,26320896.0,7090061312.0,18769237.333,2566826.667,1164.0,414.0,195.0,491.333
02-06 21:48:31,5.413,1.846,63.449,29.165,0.042,0.084,16.690,8.100,4.280,24426688512.0,62816256.0,26849280.0,7021056000.0,19371349.333,2643285.333,1201.0,423.333,306.0,491.333
02-06 21:48:34,6.134,2.143,63.109,28.529,0.0,0.084,16.960,8.290,4.370,24487911424.0,66740224.0,27676672.0,6955081728.0,21600938.667,3048789.333,1339.333,487.667,334.667,491.333
02-06 21:48:37,6.284,2.262,61.919,29.451,0.0,0.084,16.720,8.390,4.420,24553058304.0,70631424.0,27996160.0,6885724160.0,21549056.0,3009194.667,1337.667,481.667,517.333,491.333
02-06 21:48:40,6.544,2.265,65.185,25.881,0.0,0.126,16.720,8.390,4.420,24622604288.0,74850304.0,28774400.0,6811181056.0,22807893.333,3265877.333,1415.0,523.333,511.333,491.333
02-06 21:48:43,6.376,2.223,64.304,26.930,0.042,0.126,16.740,8.530,4.490,24689786880.0,78938112.0,28938240.0,6739746816.0,22373717.333,3167573.333,1388.0,507.667,313.333,491.333
02-06 21:48:46,7.056,2.520,62.243,28.055,0.0,0.126,16.740,8.530,4.490,24761266176.0,83329024.0,29986816.0,6662828032.0,23788202.667,3417429.333,1475.667,551.0,228.0,491.333
02-06 21:48:49,7.152,2.258,62.275,28.147,0.042,0.125,15.800,8.470,4.490,24831062016.0,87703552.0,30605312.0,6588039168.0,23113728.0,4795050.667,1435.0,546.667,302.0,653.333
02-06 21:48:52,6.846,2.226,61.865,28.895,0.0,0.168,16.060,8.650,4.570,24900833280.0,91979776.0,31281152.0,6513315840.0,22577152.0,3328682.667,1402.0,535.0,313.333,491.333
02-06 21:48:55,7.347,2.141,58.984,31.318,0.042,0.168,16.060,8.650,4.570,24969691136.0,96440320.0,31977472.0,6439301120.0,23851008.0,3525290.667,1480.0,562.333,134.0,491.333
02-06 21:48:58,7.392,2.436,59.135,30.911,0.042,0.084,16.450,8.850,4.650,25043230720.0,98164736.0,32522240.0,6363492352.0,24372565.333,3634517.333,1513.333,582.667,473.333,491.333
02-06 21:49:01,7.673,2.306,59.413,30.482,0.0,0.126,16.450,8.850,4.650,25116143616.0,99958784.0,33366016.0,6287941632.0,24253781.333,3661824.0,1506.333,588.333,315.333,658.667
02-06 21:49:04,7.424,2.349,58.557,31.460,0.042,0.168,16.900,9.070,4.750,25190105088.0,101470208.0,34222080.0,6211612672.0,23801856.0,3574442.667,1478.333,574.333,278.667,486.0
02-06 21:49:07,7.566,2.312,57.251,32.745,0.0,0.126,17.060,9.230,4.820,25261830144.0,102973440.0,34668544.0,6137937920.0,23909717.333,3646805.333,1485.0,582.667,1791.0,1980.667
02-06 21:49:10,7.763,2.392,58.456,31.263,0.0,0.126,17.060,9.230,4.820,25337516032.0,105017344.0,35254272.0,6059622400.0,24507733.333,3760128.0,1522.667,603.0,552.0,512.667
02-06 21:49:13,7.650,2.396,59.269,30.517,0.042,0.126,16.980,9.350,4.880,25413365760.0,107114496.0,36040704.0,5980889088.0,24787626.667,3779242.667,1540.0,606.333,236.0,491.333
02-06 21:49:16,7.780,2.439,58.537,31.077,0.0,0.168,16.980,9.350,4.880,25486618624.0,109359104.0,37134336.0,5904297984.0,24581461.333,3788800.0,1526.667,611.0,176.667,491.333
02-06 21:49:19,8.127,2.346,56.724,32.593,0.042,0.168,16.980,9.470,4.950,25556484096.0,111366144.0,37568512.0,5831991296.0,24322048.0,6102528.0,1512.0,692.667,334.667,491.333
02-06 21:49:22,8.131,2.515,57.167,32.062,0.0,0.126,17.220,9.650,5.030,25588457472.0,113631232.0,38133760.0,5797187584.0,24552789.333,6390784.0,1527.667,714.667,1055.333,491.333
02-06 21:49:25,8.106,2.520,57.455,31.751,0.042,0.126,17.220,9.650,5.030,25599258624.0,115503104.0,38969344.0,5783678976.0,24662016.0,6149802.667,1532.0,718.333,490.0,491.333
02-06 21:49:28,7.880,2.318,57.059,32.575,0.042,0.126,17.360,9.800,5.100,25603715072.0,117669888.0,39714816.0,5776310272.0,24365738.667,7344128.0,1514.667,755.0,453.0,496.667
02-06 21:49:31,8.277,2.311,56.849,32.395,0.0,0.168,17.360,9.800,5.100,25603641344.0,120217600.0,40796160.0,5772754944.0,24540501.333,6650538.667,1525.0,742.0,336.667,792.0
02-06 21:49:34,7.998,2.345,58.166,31.365,0.0,0.126,17.420,9.940,5.170,25603719168.0,121909248.0,41050112.0,5770731520.0,23622997.333,6537216.0,1469.0,713.0,397.333,687.333
02-06 21:49:37,7.928,2.475,57.215,32.215,0.042,0.126,17.380,10.060,5.230,25603563520.0,124354560.0,41799680.0,5767692288.0,23549269.333,6529024.0,1464.0,727.0,536.0,491.333
02-06 21:49:40,8.022,2.226,58.085,31.457,0.042,0.168,17.380,10.060,5.230,25603440640.0,126218240.0,42725376.0,5765025792.0,23707648.0,6621866.667,1473.667,727.333,257.333,491.333
02-06 21:49:43,8.333,2.303,58.208,30.988,0.042,0.126,17.430,10.190,5.300,25603694592.0,127729664.0,43372544.0,5762613248.0,24367104.0,6703786.667,1515.333,740.333,334.667,491.333
02-06 21:49:46,8.326,2.510,58.368,30.669,0.0,0.126,17.430,10.190,5.300,25603796992.0,129069056.0,44232704.0,5760311296.0,24098133.333,6486698.667,1498.0,725.667,194.667,514.667
02-06 21:49:49,5.954,1.845,65.535,26.541,0.042,0.084,17.400,10.300,5.370,25606483968.0,129605632.0,44756992.0,5756563456.0,17909077.333,6423893.333,1114.0,558.667,750.0,491.333
02-06 21:49:52,7.886,2.517,57.592,31.837,0.0,0.168,17.440,10.430,5.430,25606033408.0,130723840.0,45350912.0,5755301888.0,23542442.667,6425258.667,1464.0,721.0,219.333,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
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/
log-bin=/hdd1/fio1logs/mysqld-bin
[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/
log-bin=/hdd2/fio2logs/mysqld-bin
[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/
log-bin=/fio1/hdd1logs/mysqld-bin
[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/
log-bin=/fio1/hdd2logs/mysqld-bin
Raw
result.txt
########################################################################################################
### 20140602214555 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: 140014
write: 50005
other: 20002
total: 210021
transactions: 10001 (1046.33 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190019 (19880.34 per sec.)
other operations: 20002 (2092.67 per sec.)
Test execution summary:
total time: 9.5581s
total number of events: 10001
total time taken by event execution: 152.8123
per-request statistics:
min: 6.54ms
avg: 15.28ms
max: 129.83ms
approx. 95 percentile: 22.98ms
Threads fairness:
events (avg/stddev): 625.0625/5.27
execution time (avg/stddev): 9.5508/0.00
########################################################################################################
### 20140602214605 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 (1093.86 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (20783.34 per sec.)
other operations: 20000 (2187.72 per sec.)
Test execution summary:
total time: 9.1419s
total number of events: 10000
total time taken by event execution: 146.1508
per-request statistics:
min: 6.26ms
avg: 14.62ms
max: 148.94ms
approx. 95 percentile: 23.89ms
Threads fairness:
events (avg/stddev): 625.0000/9.53
execution time (avg/stddev): 9.1344/0.00
########################################################################################################
### 20140602214615 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 (111.90 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (2126.12 per sec.)
other operations: 20000 (223.80 per sec.)
Test execution summary:
total time: 89.3646s
total number of events: 10000
total time taken by event execution: 1428.8492
per-request statistics:
min: 33.81ms
avg: 142.88ms
max: 464.65ms
approx. 95 percentile: 219.09ms
Threads fairness:
events (avg/stddev): 625.0000/7.04
execution time (avg/stddev): 89.3031/0.03
########################################################################################################
### 20140602214745 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 (78.94 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (1499.84 per sec.)
other operations: 20000 (157.88 per sec.)
Test execution summary:
total time: 126.6799s
total number of events: 10000
total time taken by event execution: 2024.9371
per-request statistics:
min: 25.27ms
avg: 202.49ms
max: 1111.42ms
approx. 95 percentile: 455.35ms
Threads fairness:
events (avg/stddev): 625.0000/6.45
execution time (avg/stddev): 126.5586/0.05
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