MySQL sysbench用法

狼狼

option = {　　
    title : {
　　
        text: 'MySQL压力测试',
　　
        subtext: 'only write  55 threads '
　　
    },
　　
    tooltip : {
　　
        trigger: 'axis'
　　
    },
　　
    legend: {
　　
        data:['TPS','QPS']
　　
    },
　　
    toolbox: {
　　
        show : true,
　　
        feature : {
　　
            mark : {show: true},
　　
            dataView : {show: true, readOnly: false},
　　
            magicType : {show: true, type: ['line', 'bar']},
　　
            restore : {show: true},
　　
            saveAsImage : {show: true}
　　
        }
　　
    },
　　
    calculable : true,
　　
    xAxis : [
　　
        {
　　
            type : 'category',
　　
            boundaryGap : false,
　　
            data : ['0s','3s','6s','9s','12s','15s','18s','21s','24s','27s','30s','33s','36s','39s','42s','45s','48s','51s','54s','57s','60s','63s','66s','69s','72s','75s','78s','81s','84s','87s','90s','93s','96s','99s','102s','105s','108s','111s','114s','117s','120s','123s','126s','129s','132s','135s','138s','141s','144s','147s','150s','153s','156s','159s','162s','165s','168s','171s','174s','177s','180s','183s','186s','189s','192s','195s','198s','201s','204s','207s','210s','213s','216s','219s','222s','225s','228s','231s','234s','237s','240s','243s','246s','249s','252s','255s','258s','261s','264s','267s','270s','273s','276s','279s','282s','285s','288s','291s','294s','297s','300s']
　　
        }
　　
    ],
　　
    yAxis : [
　　
        {
　　
            type : 'value',
　　
            axisLabel : {
　　
                formatter: '{value} '
　　
            }
　　
        }
　　
    ],
　　
    series : [
　　
        {
　　
            name:'TPS',
　　
            type:'line',
　　
            data:[35.63,38.69,52.31,40.33,51.33,40.67,50.67,41.67,48.67,43.35,48.97,43.02,48.98,41.66,48.34,43.66,39.67,49.67,51.33,43.00,41.02,47.64,42.67,48.68,42.66,49.69,41.66,49.33,42.68,49.32,42.33,49.01,42.65,47.66,44.34,48.66,43.35,46.33,45.99,45.04,46.33,45.33,47.65,45.33,43.99,46.67,45.33,45.01,48.69,37.31,36.34,37.66,54.01,37.66,53.66,39.01,51.33,40.32,52.01,39.66,51.67,40.03,51.29,40.01,51.32,41.01,39.00,52.34,39.68,51.33,40.65,51.01,41.00,49.99,42.68,49.32,42.34,48.01,42.99,49.68,42.33,49.68,42.65,47.34,45.01,46.65,45.67,46.35,45.01,47.65,44.99,46.01,44.66,46.36,44.65,47.67,41.00,44.99,46.66,45.67],
　　
            markPoint : {
　　
                data : [
　　
                    {type : 'max', name: '最大值'},
　　
                    {type : 'min', name: '最小值'}
　　
                ]
　　
            },
　　
            markLine : {
　　
                data : [
　　
                    {type : 'average', name: '平均值'}
　　
                ]
　　
            }
　　
        },
　　
      {
　　
            name:'QPS',
　　
            type:'line',
　　
            data:[270.03,254.81,274.86,277.00,273.67,275.00,275.67,272.67,268.01,274.12,273.86,273.49,269.22,269.61,273.36,277.64,267.05,281.01,276.31,274.98,267.44,272.83,271.35,273.39,274.93,276.80,270.95,269.66,279.08,276.94,272.66,274.74,273.22,273.62,277.70,276.32,272.41,274.96,270.28,270.23,278.31,274.95,272.59,276.66,268.63,278.33,274.31,273.05,276.49,259.48,185.02,271.97,274.39,273.97,276.66,274.71,265.33,272.27,274.37,274.65,272.67,266.51,272.44,274.41,276.27,275.38,263.67,285.02,262.09,283.67,267.56,271.71,274.99,273.59,275.76,269.25,281.03,277.70,275.96,273.73,266.31,277.08,275.55,274.69,273.03,268.55,284.38,269.08,272.72,277.93,270.60,275.75,273.60,275.47,271.91,278.69,271.00,270.63,274.31,275.68],
　　
            markPoint : {
　　
                data : [
　　
                    {type : 'max', name: '最大值'},
　　
                    {type : 'min', name: '最小值'}
　　
                ]
　　
            },
　　
            markLine : {
　　
                data : [
　　
                    {type : 'average', name: '平均值'}
　　
                ]
　　
            }
　　
        }
　　
    ]
　　
};