Last active
August 29, 2015 14:02
-
-
Save s-tajima/094d86c3cc1555ae7f4c to your computer and use it in GitHub Desktop.
sysbench result at 2014/06/01 Case6
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:","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 |
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 | |
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 |
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
######################################################################################################## | |
### 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 |
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