尝试对GBase8a进行sysbench压力测试

  GBase8a MPP是一款分布式的分析型数据库，对它进行压力测试通常不选择sysbench这种偏事务的压测工具，在一些场景测试时，也会遇到一些sysbench测试用例。下面我搭建一套环境尝试使用sysbench对GBase8a进行测试。

    首先搭建了一套4节点的GBase8a MPP集群，分别是（192.102.53.205，192.102.53.206，192.102.53.207，192.102.53.216）。没有对集群进行优化，使用的默认参数，所以对测试结果不需要过分关注，注重过程即可。GBase8a客户端兼容mysql，因此驱动我们使用mysql的驱动。

  1.创建库：

    create database sbtest17；
    create database sbtest18；
    create database sbtest19；
    create database sbtest20；

2.创建表并装载数据，每张表装载10000000行：

sysbench --db-driver=mysql --mysql-host=192.102.53.205 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest17 /usr/local/share/sysbench/oltp_common.lua --rand-type=uniform --table-size=10000000 --tables=32 --threads=8 prepare
sysbench --db-driver=mysql --mysql-host=192.102.53.205 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest18 /usr/local/share/sysbench/oltp_common.lua --rand-type=uniform --table-size=10000000 --tables=32 --threads=8 prepare
sysbench --db-driver=mysql --mysql-host=192.102.53.205 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest19 /usr/local/share/sysbench/oltp_common.lua --rand-type=uniform --table-size=10000000 --tables=32 --threads=8 prepare
sysbench --db-driver=mysql --mysql-host=192.102.53.205 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest20 /usr/local/share/sysbench/oltp_common.lua --rand-type=uniform --table-size=10000000 --tables=32 --threads=8 prepare

3.oltp_point_select并发测试，分别在4个gcluster运行：
.sysbench --db-driver=mysql --mysql-host=192.102.53.205 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest17 /usr/local/share/sysbench/oltp_point_select.lua --table-size=10000000 --tables=32 --threads=256 --report-interval=60 --time=300 run
.sysbench --db-driver=mysql --mysql-host=192.102.53.206 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest18 /usr/local/share/sysbench/oltp_point_select.lua --table-size=10000000 --tables=32 --threads=256 --report-interval=60 --time=300 run
sysbench --db-driver=mysql --mysql-host=192.102.53.207 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest19 /usr/local/share/sysbench/oltp_point_select.lua --table-size=10000000 --tables=32 --threads=256 --report-interval=60 --time=300 run
sysbench --db-driver=mysql --mysql-host=192.102.53.216 --mysql-port=5258 --mysql-user=root --mysql-db=sbtest20 /usr/local/share/sysbench/oltp_point_select.lua --table-size=10000000 --tables=32 --threads=256 --report-interval=60 --time=300 run
4.查看结果：

205:
Threads started!

[ 60s ] thds: 256 tps: 2518.24 qps: 2518.24 (r/w/o: 2518.24/0.00/0.00) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 256 tps: 2569.65 qps: 2569.65 (r/w/o: 2569.65/0.00/0.00) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 180s ] thds: 256 tps: 2565.37 qps: 2565.37 (r/w/o: 2565.37/0.00/0.00) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 240s ] thds: 256 tps: 2545.80 qps: 2545.80 (r/w/o: 2545.80/0.00/0.00) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 256 tps: 2549.78 qps: 2549.78 (r/w/o: 2549.78/0.00/0.00) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 765193
write: 0
other: 0
total: 765193
transactions: 765193 (2549.76 per sec.)
queries: 765193 (2549.76 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

Throughput:
events/s (eps): 2549.7644
time elapsed: 300.1034s
total number of events: 765193

Latency (ms):
min: 11.28
avg: 100.38
max: 532.42
95th percentile: 127.81
sum: 76811774.41

Threads fairness:
events (avg/stddev): 2989.0352/25.46
execution time (avg/stddev): 300.0460/0.03

206: