Skip to content

Instantly share code, notes, and snippets.

@s-tajima

s-tajima/dstat_sysbench.csv

Created May 31, 2014 13:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save s-tajima/3c99ba739471e71071ab to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save s-tajima/3c99ba739471e71071ab to your computer and use it in GitHub Desktop.
Download ZIP
sysbench result at 2014/05/31 Case1
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 <[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 05:42:09 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 05:42:09,1.817,0.557,97.419,0.184,0.004,0.019,2.090,2.030,2.010,2887806976.0,202784768.0,12348837888.0,16097980416.0,198036.477,4464182.055,15.400,289.822,0.0,0.0
01-06 05:42:12,21.235,12.015,61.452,4.631,0.292,0.375,2.090,2.030,2.010,2528866304.0,1417216.0,24043520.0,28983083008.0,149090304.0,45397.333,9045.0,7.0,546.0,788.667
01-06 05:42:15,57.952,15.233,2.770,22.157,0.881,1.007,3.360,2.290,2.090,2528804864.0,1466368.0,24047616.0,28983091200.0,402731008.0,64170.667,24578.333,8.333,238.667,491.333
01-06 05:42:18,60.620,15.417,1.676,20.486,0.880,0.922,4.210,2.490,2.160,2528731136.0,1531904.0,24047616.0,28983099392.0,406530730.667,84650.667,24812.667,9.667,564.667,491.333
01-06 05:42:21,65.844,17.475,2.299,12.458,0.836,1.087,4.210,2.490,2.160,2528661504.0,1589248.0,24051712.0,28983107584.0,482400938.667,66901.333,29441.333,9.0,193.333,491.333
01-06 05:42:24,52.605,13.950,15.756,16.092,0.630,0.966,5.160,2.710,2.230,2532302848.0,569344.0,22900736.0,28981637120.0,346331818.667,105813.333,21073.667,17.667,294.0,530.667
01-06 05:42:27,65.294,16.471,1.303,15.0,0.924,1.008,5.160,2.710,2.230,2532659200.0,577536.0,22917120.0,28981256192.0,453345280.0,51029.333,27663.0,9.667,155.333,491.333
01-06 05:42:30,68.622,17.847,1.508,10.054,0.964,1.005,5.780,2.880,2.290,2532651008.0,585728.0,22917120.0,28981256192.0,514157226.667,60928.0,31386.0,10.333,134.0,491.333
01-06 05:42:33,58.895,14.292,2.192,22.850,0.843,0.927,6.520,3.080,2.360,2532642816.0,585728.0,22917120.0,28981264384.0,397672448.0,45397.333,24269.667,8.667,112.667,491.333
01-06 05:42:36,53.898,14.040,12.028,18.399,0.754,0.880,6.520,3.080,2.360,2530439168.0,548864.0,22605824.0,28983816192.0,353072469.333,70314.667,21484.333,14.667,450.667,554.0
01-06 05:42:39,4.732,1.340,74.581,19.263,0.0,0.084,7.440,3.330,2.440,2535870464.0,581632.0,22900736.0,28978057216.0,30040064.0,30378.667,1835.333,5.0,372.667,486.0
01-06 05:42:42,5.567,1.423,73.336,19.590,0.0,0.084,7.440,3.330,2.440,2537238528.0,1298432.0,23371776.0,28975501312.0,33473877.333,31402.667,2041.0,4.0,1037.667,1299.667
01-06 05:42:45,5.365,1.551,72.255,20.704,0.042,0.084,8.370,3.590,2.530,2538639360.0,1585152.0,23764992.0,28973420544.0,33305941.333,0.0,2034.0,0.0,410.667,669.667
01-06 05:42:48,5.446,2.304,69.711,22.413,0.0,0.126,9.140,3.830,2.610,2539581440.0,2424832.0,25223168.0,28970180608.0,32579584.0,38229.333,1975.333,5.0,748.0,1124.667
01-06 05:42:51,5.056,1.421,72.628,20.769,0.0,0.125,9.140,3.830,2.610,2539991040.0,2727936.0,25620480.0,28969070592.0,30991701.333,20650.667,1886.667,3.333,592.0,1023.333
01-06 05:42:54,5.235,1.801,70.771,22.069,0.042,0.084,9.770,4.050,2.690,2540285952.0,2883584.0,25812992.0,28968427520.0,32441685.333,24576.0,1978.333,5.0,774.0,4346.0
01-06 05:42:57,5.153,1.382,73.356,20.025,0.0,0.084,9.770,4.050,2.690,2540347392.0,3035136.0,25821184.0,28968206336.0,32010240.0,19114.667,1955.333,2.667,229.333,4008.0
01-06 05:43:00,5.274,1.591,72.959,20.092,0.0,0.084,10.430,4.280,2.770,2540306432.0,3067904.0,25812992.0,28968222720.0,32997376.0,40106.667,2013.667,6.333,626.667,1316.667
01-06 05:43:03,5.113,1.551,71.375,21.836,0.0,0.126,11.110,4.520,2.860,2540154880.0,3084288.0,25821184.0,28968349696.0,32718848.0,20480.0,1997.0,3.0,508.0,4015.333
01-06 05:43:06,5.365,1.886,72.590,20.034,0.0,0.126,11.110,4.520,2.860,2540167168.0,3092480.0,25817088.0,28968333312.0,33144832.0,5461.333,2023.667,1.0,2153.0,5590.0
01-06 05:43:09,5.170,1.387,72.509,20.849,0.0,0.084,11.660,4.750,2.940,2540138496.0,3117056.0,25821184.0,28968333312.0,33554432.0,25941.333,2047.667,4.333,394.0,4036.667
01-06 05:43:12,5.237,1.676,72.560,20.444,0.0,0.084,11.660,4.750,2.940,2540105728.0,3145728.0,25817088.0,28968341504.0,33435648.0,35498.667,2041.0,5.0,402.0,593.333
01-06 05:43:15,5.549,1.752,71.923,20.734,0.0,0.042,12.330,5.0,3.030,2540089344.0,3162112.0,25817088.0,28968341504.0,32784384.0,10922.667,2000.667,2.667,504.0,7464.0
01-06 05:43:18,5.029,1.467,72.674,20.662,0.042,0.126,12.870,5.230,3.120,2540060672.0,3178496.0,25821184.0,28968349696.0,32462165.333,47786.667,1982.333,7.333,412.667,4031.333
01-06 05:43:21,5.448,1.467,72.883,20.075,0.0,0.126,12.870,5.230,3.120,2539913216.0,3203072.0,25817088.0,28968476672.0,33680042.667,27306.667,2055.333,4.667,480.667,1398.667
01-06 05:43:24,5.199,1.635,72.285,20.755,0.0,0.126,13.280,5.440,3.200,2540027904.0,3227648.0,25821184.0,28968333312.0,33062912.0,24576.0,2018.0,4.0,428.0,1354.0
01-06 05:43:27,5.155,1.551,73.806,19.405,0.0,0.084,13.280,5.440,3.200,2540023808.0,3235840.0,25817088.0,28968333312.0,33183061.333,5461.333,2024.667,1.333,254.667,4004.667
01-06 05:43:30,5.395,1.673,71.811,21.037,0.0,0.084,13.810,5.680,3.290,2539991040.0,3260416.0,25825280.0,28968333312.0,33412437.333,25088.0,2040.333,4.667,292.0,4015.333
01-06 05:43:33,5.347,1.796,72.556,20.175,0.042,0.084,14.310,5.920,3.370,2539966464.0,3276800.0,25825280.0,28968341504.0,33232213.333,20480.0,2027.333,3.0,474.0,4026.0
01-06 05:43:36,5.307,1.713,71.500,21.396,0.0,0.084,14.310,5.920,3.370,2539933696.0,3301376.0,25825280.0,28968349696.0,32877226.667,25941.333,2007.0,4.333,562.0,4049.333
01-06 05:43:39,5.325,1.551,71.824,21.174,0.0,0.126,14.680,6.140,3.460,2539933696.0,3309568.0,25817088.0,28968349696.0,33587200.0,5461.333,2050.0,1.333,849.0,3981.333
01-06 05:43:42,5.303,1.545,72.526,20.459,0.042,0.125,14.680,6.140,3.460,2539782144.0,3334144.0,25817088.0,28968476672.0,32658773.333,24576.0,1993.333,4.0,294.0,1364.667
01-06 05:43:45,5.367,1.593,72.704,20.294,0.0,0.042,14.950,6.340,3.540,2539900928.0,3350528.0,25825280.0,28968333312.0,33335978.667,20480.0,2034.667,3.0,452.667,4031.333
01-06 05:43:48,5.309,1.589,72.450,20.569,0.0,0.084,15.270,6.550,3.620,2539868160.0,3383296.0,25825280.0,28968333312.0,32729770.667,34133.333,1997.333,5.667,519.0,4015.333
01-06 05:43:51,5.102,1.338,72.982,20.494,0.0,0.084,15.270,6.550,3.620,2539851776.0,3391488.0,25825280.0,28968341504.0,30818304.0,13653.333,1881.667,3.0,424.667,3992.0
01-06 05:43:54,5.397,1.381,72.929,20.209,0.0,0.084,15.490,6.740,3.700,2539819008.0,3424256.0,25825280.0,28968341504.0,32445781.333,30037.333,1980.333,5.0,295.333,3992.0
01-06 05:43:57,5.151,1.591,71.817,21.315,0.0,0.126,15.490,6.740,3.700,2539786240.0,3448832.0,25825280.0,28968349696.0,32609621.333,25941.333,1989.667,4.333,266.0,1354.0
01-06 05:44:00,5.159,1.594,72.819,20.344,0.0,0.084,15.690,6.920,3.770,2539782144.0,3465216.0,25812992.0,28968349696.0,33232213.333,12800.0,2029.333,3.0,223.333,1393.333
01-06 05:44:03,5.474,1.546,71.918,20.978,0.042,0.042,15.880,7.110,3.850,2539757568.0,3481600.0,25821184.0,28968349696.0,32860842.667,20480.0,2005.0,3.0,593.0,1683.333
01-06 05:44:06,5.595,1.879,72.234,20.167,0.0,0.125,15.880,7.110,3.850,2539884544.0,3506176.0,25821184.0,28968198144.0,33898496.0,25941.333,2068.667,4.0,2107.667,5435.333
01-06 05:44:09,5.451,1.426,72.243,20.755,0.0,0.126,16.050,7.290,3.920,2539991040.0,3522560.0,25825280.0,28968071168.0,33740117.333,20480.0,2060.667,3.0,415.333,4031.333
01-06 05:44:12,5.362,1.550,71.345,21.617,0.0,0.126,16.050,7.290,3.920,2539958272.0,3547136.0,25817088.0,28968087552.0,33893034.667,16384.0,2067.333,3.667,618.667,4026.0
01-06 05:44:15,5.206,1.469,71.411,21.788,0.0,0.126,16.200,7.460,4.0,2539933696.0,3563520.0,25825280.0,28968087552.0,33221290.667,19114.667,2027.667,2.667,318.667,3992.0
01-06 05:44:18,5.486,1.591,71.106,21.692,0.042,0.084,16.510,7.670,4.090,2540019712.0,3596288.0,25825280.0,28967968768.0,34319018.667,31402.667,2094.667,5.667,186.667,3992.0
01-06 05:44:21,5.477,1.672,72.784,19.983,0.0,0.084,16.510,7.670,4.090,2540130304.0,3612672.0,25825280.0,28967841792.0,33516202.667,21845.333,2046.667,3.333,493.333,3986.667
01-06 05:44:24,5.855,1.715,70.389,21.957,0.0,0.084,16.630,7.840,4.160,2540126208.0,3645440.0,25812992.0,28967825408.0,34357248.0,31402.667,2096.333,5.333,385.333,1388.0
01-06 05:44:27,5.327,1.594,71.644,21.351,0.0,0.084,16.630,7.840,4.160,2540109824.0,3645440.0,25829376.0,28967825408.0,34056874.667,1365.333,2078.333,0.333,356.0,4010.0
01-06 05:44:30,5.521,1.673,71.644,21.037,0.0,0.125,16.740,8.010,4.230,2540077056.0,3678208.0,25829376.0,28967825408.0,34379093.333,30037.333,2099.0,5.0,244.667,1960.667
01-06 05:44:33,5.320,1.508,71.638,21.408,0.042,0.084,16.920,8.190,4.310,2539917312.0,3702784.0,25829376.0,28967960576.0,33204906.667,25941.333,2026.0,4.333,208.0,3456.667
01-06 05:44:36,5.488,1.550,71.973,20.947,0.0,0.042,16.920,8.190,4.310,2539888640.0,3727360.0,25825280.0,28967968768.0,33931264.0,24576.0,2072.0,4.0,478.0,3981.333
01-06 05:44:39,5.314,1.757,73.054,19.791,0.0,0.084,17.0,8.360,4.390,2539876352.0,3735552.0,25829376.0,28967968768.0,33882112.0,5461.333,2067.333,1.333,440.0,3981.333
01-06 05:44:42,5.444,1.549,72.529,20.394,0.0,0.084,17.0,8.360,4.390,2539843584.0,3768320.0,25829376.0,28967968768.0,33565354.667,28672.0,2048.667,5.0,346.667,3419.333
01-06 05:44:45,5.479,1.715,71.602,21.079,0.0,0.125,17.0,8.500,4.450,2539843584.0,3784704.0,25829376.0,28967952384.0,33532586.667,20480.0,2046.333,3.0,505.333,4049.333
01-06 05:44:48,5.232,1.591,71.118,21.976,0.0,0.084,17.240,8.690,4.540,2539810816.0,3817472.0,25829376.0,28967952384.0,33237674.667,30037.333,2029.333,5.333,482.667,3992.0
01-06 05:44:51,5.025,1.424,72.655,20.854,0.0,0.042,17.240,8.690,4.540,2539802624.0,3817472.0,25829376.0,28967960576.0,31053141.333,1365.333,1895.0,0.333,399.0,3981.333
01-06 05:44:54,5.312,1.673,72.020,20.828,0.042,0.125,17.460,8.880,4.620,2539782144.0,3842048.0,25825280.0,28967960576.0,33472512.0,30037.333,2043.0,4.333,377.667,3986.667
01-06 05:44:57,5.071,1.593,71.417,21.836,0.0,0.084,17.460,8.880,4.620,2539880448.0,3858432.0,25829376.0,28967841792.0,32795306.667,20480.0,2002.0,3.0,446.0,4020.667
01-06 05:45:00,5.069,1.508,71.931,21.450,0.0,0.042,17.510,9.030,4.690,2539864064.0,3874816.0,25829376.0,28967841792.0,31926954.667,12288.0,1948.667,2.333,232.0,1348.667
01-06 05:45:03,5.342,1.628,71.619,21.244,0.042,0.125,17.550,9.180,4.760,2539839488.0,3899392.0,25829376.0,28967841792.0,32489472.0,28672.0,1982.667,5.0,566.667,4072.667
01-06 05:45:06,5.327,1.594,72.567,20.428,0.0,0.084,17.550,9.180,4.760,2539954176.0,3932160.0,25825280.0,28967698432.0,33363285.333,30037.333,2036.667,5.0,2103.667,5382.0
01-06 05:45:09,5.318,1.633,70.980,21.985,0.0,0.084,17.660,9.340,4.840,2540052480.0,3956736.0,25829376.0,28967571456.0,33636352.0,25941.333,2052.333,4.333,530.0,2298.667
01-06 05:45:12,5.483,1.591,71.620,21.222,0.0,0.084,17.660,9.340,4.840,2540036096.0,3964928.0,25829376.0,28967579648.0,33598122.667,5461.333,2051.667,1.0,512.667,3981.333
01-06 05:45:15,5.281,1.383,71.668,21.584,0.0,0.084,17.690,9.480,4.910,2540011520.0,3989504.0,25829376.0,28967579648.0,32997376.0,25941.333,2013.0,4.333,493.333,3992.0
01-06 05:45:18,3.936,1.340,76.089,18.509,0.042,0.084,18.030,9.690,5.0,2542419968.0,1302528.0,22966272.0,28970721280.0,26121557.333,29354.667,1533.333,6.667,497.333,4070.667
01-06 05:45:21,5.063,1.548,73.222,20.084,0.0,0.084,18.030,9.690,5.0,2542534656.0,1310720.0,22970368.0,28970594304.0,31678464.0,12629.333,1935.333,1.667,488.0,4049.333
01-06 05:45:24,5.113,1.593,71.123,22.087,0.0,0.084,17.950,9.810,5.070,2542784512.0,1441792.0,22986752.0,28970196992.0,32062122.667,12970.667,1956.667,1.667,252.667,4031.333
01-06 05:45:27,5.025,1.424,72.236,21.231,0.0,0.084,17.950,9.810,5.070,2542776320.0,1449984.0,22986752.0,28970196992.0,31091370.667,20138.667,1897.0,3.333,653.333,4248.0
01-06 05:45:30,5.197,1.383,71.542,21.794,0.0,0.084,17.870,9.930,5.130,2542628864.0,1724416.0,22986752.0,28970070016.0,31881898.667,12970.667,1944.333,1.667,549.333,4015.333
01-06 05:45:33,5.230,1.423,72.552,20.753,0.0,0.042,17.960,10.080,5.200,2542612480.0,1732608.0,22986752.0,28970078208.0,31850496.0,6826.667,1944.667,1.0,480.667,4031.333
01-06 05:45:36,5.268,1.296,71.656,21.697,0.0,0.084,17.960,10.080,5.200,2542604288.0,1732608.0,22986752.0,28970086400.0,31195136.0,14677.333,1904.0,2.333,816.0,4054.667
01-06 05:45:39,4.941,1.382,72.571,20.980,0.042,0.084,17.890,10.200,5.270,2542469120.0,1740800.0,22986752.0,28970213376.0,31129600.0,18432.0,1899.667,2.667,683.333,2490.667
01-06 05:45:42,4.979,1.506,73.054,20.377,0.0,0.084,17.890,10.200,5.270,2542465024.0,1740800.0,22990848.0,28970213376.0,31238826.667,1706.667,1906.333,0.667,656.333,1564.0
01-06 05:45:45,5.268,1.630,70.819,22.241,0.0,0.042,17.900,10.330,5.330,2542473216.0,1748992.0,22990848.0,28970196992.0,31948800.0,17408.0,1951.0,3.0,315.333,4054.667
01-06 05:45:48,5.102,1.464,72.606,20.703,0.0,0.125,17.740,10.420,5.390,2542600192.0,1748992.0,22990848.0,28970070016.0,31457280.0,17920.0,1919.0,3.333,376.0,3986.667
01-06 05:45:51,4.776,1.382,72.266,21.491,0.0,0.084,17.740,10.420,5.390,2542706688.0,1761280.0,22990848.0,28969951232.0,30218922.667,10922.667,1845.667,1.333,210.0,3981.333
01-06 05:45:54,4.899,1.549,73.074,20.394,0.0,0.084,17.760,10.550,5.460,2542706688.0,1761280.0,22990848.0,28969951232.0,31206058.667,13312.0,1903.667,2.0,264.0,1364.667
01-06 05:45:57,5.054,1.504,73.684,19.716,0.0,0.042,17.760,10.550,5.460,2542690304.0,1773568.0,22986752.0,28969959424.0,31114581.333,29696.0,1899.667,5.0,358.0,1364.667
01-06 05:46:00,4.933,1.630,73.077,20.276,0.0,0.084,17.700,10.650,5.520,2542686208.0,1773568.0,22990848.0,28969959424.0,31500970.667,12970.667,1923.333,1.667,442.667,4026.0
01-06 05:46:03,5.226,1.463,72.115,21.070,0.042,0.084,17.730,10.770,5.590,2542686208.0,1781760.0,22982656.0,28969959424.0,31987029.333,7168.0,1952.0,1.667,440.0,3986.667
01-06 05:46:06,5.193,1.591,72.236,20.896,0.0,0.084,17.730,10.770,5.590,2542817280.0,1781760.0,22994944.0,28969816064.0,31546026.667,12970.667,1926.0,1.667,2214.333,5492.0
01-06 05:46:09,4.943,1.424,72.392,21.156,0.0,0.084,17.750,10.890,5.650,2543067136.0,1789952.0,22990848.0,28969562112.0,31353514.667,19797.333,1913.0,3.0,536.0,4042.0
01-06 05:46:12,5.272,1.506,72.720,20.377,0.0,0.126,17.750,10.890,5.650,2543054848.0,1789952.0,22994944.0,28969570304.0,32243712.0,0.0,1968.333,0.0,510.0,4216.667
01-06 05:46:15,5.184,1.505,72.157,21.070,0.0,0.084,17.770,11.010,5.720,2543054848.0,1798144.0,22986752.0,28969570304.0,31408128.0,18432.0,1917.0,2.667,473.333,4038.667
01-06 05:46:18,5.193,1.424,73.744,19.556,0.0,0.084,17.790,11.130,5.790,2543038464.0,1798144.0,22994944.0,28969578496.0,31905109.333,17920.0,1947.667,3.333,297.333,4031.333
01-06 05:46:21,4.816,1.466,72.906,20.687,0.042,0.084,17.790,11.130,5.790,2543030272.0,1806336.0,22994944.0,28969578496.0,30851072.0,5461.333,1882.333,1.333,376.667,1420.0
01-06 05:46:24,5.316,1.423,73.755,19.464,0.0,0.042,17.720,11.220,5.850,2543173632.0,1806336.0,22994944.0,28969435136.0,31664810.667,14677.333,1933.333,2.333,318.667,4031.333
01-06 05:46:27,5.061,1.631,72.564,20.619,0.0,0.125,17.720,11.220,5.850,2543169536.0,1814528.0,22990848.0,28969435136.0,32538624.0,18432.0,1986.0,2.667,252.667,4026.0
01-06 05:46:30,4.985,1.508,73.733,19.732,0.0,0.042,17.830,11.350,5.920,2543165440.0,1814528.0,22994944.0,28969435136.0,32058026.667,14336.0,1955.667,2.0,317.333,1420.0
01-06 05:46:33,5.105,1.590,73.347,19.874,0.0,0.084,17.840,11.460,5.980,2543022080.0,1822720.0,22994944.0,28969570304.0,32036181.333,6826.667,1956.0,1.333,272.0,3992.0
01-06 05:46:36,5.069,1.550,73.649,19.648,0.0,0.084,17.840,11.460,5.980,2543013888.0,1822720.0,22994944.0,28969578496.0,32445781.333,12970.667,1980.0,1.667,684.0,4044.0
01-06 05:46:39,5.151,1.549,74.204,19.012,0.0,0.084,17.770,11.560,6.040,2543009792.0,1830912.0,22990848.0,28969578496.0,32735232.0,20480.0,1997.667,3.667,344.667,1364.667
01-06 05:46:42,5.186,1.506,73.066,20.117,0.0,0.125,17.770,11.560,6.040,2543005696.0,1830912.0,22994944.0,28969578496.0,32232789.333,0.0,1968.0,0.0,622.667,3981.333
01-06 05:46:45,5.219,1.628,73.027,20.0,0.042,0.084,17.710,11.650,6.100,2543013888.0,1839104.0,22994944.0,28969562112.0,31905109.333,20480.0,1946.667,3.667,325.333,3275.333
01-06 05:46:48,5.184,1.547,73.119,20.067,0.0,0.084,17.730,11.750,6.160,2543013888.0,1839104.0,22994944.0,28969562112.0,32161792.0,16213.333,1963.0,2.667,510.667,2181.333
01-06 05:46:51,4.971,1.504,72.849,20.635,0.0,0.042,17.730,11.750,6.160,2542997504.0,1847296.0,22994944.0,28969570304.0,30747306.667,19797.333,1877.333,3.0,295.333,3981.333
01-06 05:46:54,4.977,1.631,73.066,20.243,0.0,0.084,17.830,11.870,6.230,2542993408.0,1847296.0,22999040.0,28969570304.0,31506432.0,0.0,1922.667,0.0,159.333,1306.0
01-06 05:46:57,5.096,1.587,72.348,20.886,0.0,0.084,17.830,11.870,6.230,2542981120.0,1855488.0,22994944.0,28969578496.0,31348053.333,22528.0,1914.0,3.0,386.0,4038.667
01-06 05:47:00,5.237,1.592,71.177,21.910,0.0,0.084,17.930,11.990,6.300,2542977024.0,1855488.0,22999040.0,28969578496.0,32855381.333,14677.333,2005.333,2.333,244.667,1478.667
01-06 05:47:03,5.228,1.547,72.606,20.535,0.0,0.084,17.930,12.090,6.360,2542972928.0,1863680.0,22994944.0,28969578496.0,32363861.333,5461.333,1974.667,1.0,767.333,4031.333
01-06 05:47:06,5.309,1.714,72.241,20.610,0.042,0.084,17.930,12.090,6.360,2543112192.0,1863680.0,22999040.0,28969435136.0,32298325.333,18773.333,1971.333,3.333,2236.333,5424.667
01-06 05:47:09,4.860,1.508,71.806,21.743,0.0,0.084,18.020,12.200,6.430,2543104000.0,1871872.0,22999040.0,28969435136.0,31462741.333,18432.0,1920.333,2.667,1015.0,4008.0
01-06 05:47:12,4.946,1.509,72.381,21.081,0.0,0.084,18.020,12.200,6.430,2543071232.0,1871872.0,22999040.0,28969467904.0,32194560.0,14336.0,1965.0,2.0,463.333,4020.667
01-06 05:47:15,5.061,1.673,73.484,19.699,0.0,0.084,18.100,12.320,6.500,2543071232.0,1880064.0,22999040.0,28969459712.0,31981568.0,5461.333,1952.0,1.0,806.0,4004.667
01-06 05:47:18,5.309,1.463,72.952,20.234,0.0,0.042,18.250,12.440,6.570,2543190016.0,1880064.0,22999040.0,28969340928.0,31730346.667,16213.333,1937.0,2.667,233.333,4031.333
01-06 05:47:21,5.102,1.506,72.647,20.661,0.0,0.084,18.250,12.440,6.570,2543181824.0,1888256.0,22999040.0,28969340928.0,31637504.0,20138.667,1931.0,3.333,480.667,1750.667
01-06 05:47:24,5.140,1.797,72.252,20.685,0.042,0.084,18.070,12.500,6.620,2543198208.0,1888256.0,22999040.0,28969324544.0,31954261.333,0.0,1950.0,0.0,360.0,1745.333
01-06 05:47:27,5.065,1.339,73.294,20.218,0.0,0.084,18.070,12.500,6.620,2543194112.0,1896448.0,22994944.0,28969324544.0,31610197.333,20480.0,1930.0,4.0,295.333,4026.0
01-06 05:47:30,5.261,1.545,72.777,20.376,0.0,0.042,17.980,12.580,6.680,2543190016.0,1896448.0,22999040.0,28969324544.0,31910570.667,12970.667,1946.667,1.667,434.0,4060.0
01-06 05:47:33,5.177,1.587,73.570,19.582,0.0,0.084,17.980,12.670,6.740,2543177728.0,1904640.0,22994944.0,28969332736.0,31653888.0,19797.333,1932.667,3.0,445.333,4078.0
01-06 05:47:36,4.943,1.550,74.403,19.062,0.0,0.042,17.980,12.670,6.740,2543300608.0,1904640.0,22999040.0,28969205760.0,31954261.333,0.0,1950.333,0.0,652.667,3360.667
01-06 05:47:39,5.268,1.589,72.617,20.443,0.0,0.084,17.980,12.750,6.800,2543288320.0,1912832.0,22994944.0,28969213952.0,32484010.667,18432.0,1982.333,2.667,374.0,3366.0
01-06 05:47:42,5.272,1.590,73.515,19.540,0.0,0.084,17.980,12.750,6.800,2543403008.0,1912832.0,22999040.0,28969095168.0,32762538.667,14677.333,1999.667,2.333,434.0,4031.333
01-06 05:47:45,5.356,1.674,71.841,21.046,0.0,0.084,17.910,12.820,6.850,2543415296.0,1921024.0,22994944.0,28969078784.0,32757077.333,5461.333,2000.333,1.0,389.333,3981.333
01-06 05:47:48,5.153,1.341,73.733,19.648,0.042,0.084,17.910,12.910,6.910,2543411200.0,1921024.0,22999040.0,28969078784.0,32079872.0,17920.0,1956.667,3.333,680.333,3992.0
01-06 05:47:51,4.927,1.545,73.403,20.042,0.0,0.084,17.910,12.910,6.910,2543403008.0,1929216.0,22990848.0,28969086976.0,30599850.667,18432.0,1867.667,2.667,356.0,4010.0
01-06 05:47:54,5.356,1.423,73.305,19.833,0.0,0.084,17.920,12.990,6.970,2543394816.0,1929216.0,22999040.0,28969086976.0,32107178.667,14336.0,1959.667,2.0,500.0,3981.333
01-06 05:47:57,4.929,1.378,72.682,20.927,0.0,0.084,17.920,12.990,6.970,2543378432.0,1937408.0,22999040.0,28969095168.0,29835264.0,6826.667,1821.667,1.0,724.333,4033.333
01-06 05:48:00,4.860,1.424,73.942,19.732,0.0,0.042,17.850,13.060,7.020,2543251456.0,1937408.0,22999040.0,28969222144.0,30889301.333,12970.667,1885.0,1.667,782.0,1311.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 = 1M
max_allowed_packet = 1M
table_open_cache = 1024
sort_buffer_size = 1M
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 1M
query_cache_size = 1M
thread_cache_size = 100
max_connections = 400
binlog_format = mixed
expire_logs_days = 2
# innodb
innodb_buffer_pool_size = 1M
innodb_log_file_size = 1M
innodb_log_buffer_size = 1M
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
[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
[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
[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
Raw
result.txt
########################################################################################################
### 20140601054210 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
Doing read-only 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: 0
other: 20000
total: 160000
transactions: 10000 (815.81 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 140000 (11421.39 per sec.)
other operations: 20000 (1631.63 per sec.)
Test execution summary:
total time: 12.2577s
total number of events: 10000
total time taken by event execution: 195.9567
per-request statistics:
min: 10.12ms
avg: 19.60ms
max: 136.68ms
approx. 95 percentile: 27.21ms
Threads fairness:
events (avg/stddev): 625.0000/4.21
execution time (avg/stddev): 12.2473/0.00
########################################################################################################
### 20140601054223 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
Doing read-only 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: 0
other: 20000
total: 160000
transactions: 10000 (837.19 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 140000 (11720.62 per sec.)
other operations: 20000 (1674.37 per sec.)
Test execution summary:
total time: 11.9448s
total number of events: 10000
total time taken by event execution: 190.9911
per-request statistics:
min: 8.83ms
avg: 19.10ms
max: 139.43ms
approx. 95 percentile: 26.58ms
Threads fairness:
events (avg/stddev): 625.0000/6.21
execution time (avg/stddev): 11.9369/0.00
########################################################################################################
### 20140601054236 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
Doing read-only 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: 0
other: 20000
total: 160000
transactions: 10000 (62.76 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 140000 (878.68 per sec.)
other operations: 20000 (125.53 per sec.)
Test execution summary:
total time: 159.3303s
total number of events: 10000
total time taken by event execution: 2547.6521
per-request statistics:
min: 114.37ms
avg: 254.77ms
max: 652.92ms
approx. 95 percentile: 344.70ms
Threads fairness:
events (avg/stddev): 625.0000/4.94
execution time (avg/stddev): 159.2283/0.06
########################################################################################################
### 20140601054515 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
Doing read-only 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: 0
other: 20000
total: 160000
transactions: 10000 (60.36 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 140000 (845.05 per sec.)
other operations: 20000 (120.72 per sec.)
Test execution summary:
total time: 165.6707s
total number of events: 10000
total time taken by event execution: 2649.5176
per-request statistics:
min: 117.15ms
avg: 264.95ms
max: 674.53ms
approx. 95 percentile: 361.07ms
Threads fairness:
events (avg/stddev): 625.0000/3.86
execution time (avg/stddev): 165.5949/0.04
[root@mysql-test0
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-read-only=on --oltp-dist-type=uniform \
--num-threads=16 --max-time=180 --oltp-test-mode=complex \
run >> $SYSBENCH_LOG
echo ""
done
kill $PID
Raw
sysbench_prepare.sh
#!/bin/bash
for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
sysbench \
--test=oltp \
--db-driver=mysql \
--oltp-table-size=50000000 \
--mysql-socket=/${DIR}/mysql/mysql.sock \
--mysql-user=sbtestuser \
--mysql-password=sbtestpass \
prepare
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment