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:
Threads started!
[ 60s ] thds: 256 tps: 2450.02 qps: 2450.02 (r/w/o: 2450.02/0.00/0.00) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 256 tps: 2542.00 qps: 2542.00 (r/w/o: 2542.00/0.00/0.00) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
[ 180s ] thds: 256 tps: 2531.40 qps: 2531.40 (r/w/o: 2531.40/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 240s ] thds: 256 tps: 2516.13 qps: 2516.13 (r/w/o: 2516.13/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 256 tps: 2532.38 qps: 2532.38 (r/w/o: 2532.38/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 754579
write: 0
other: 0
total: 754579
transactions: 754579 (2514.38 per sec.)
queries: 754579 (2514.38 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2514.3819
time elapsed: 300.1052s
total number of events: 754579
Latency (ms):
min: 16.93
avg: 101.80
max: 783.40
95th percentile: 130.13
sum: 76812874.02
Threads fairness:
events (avg/stddev): 2947.5742/10.26
execution time (avg/stddev): 300.0503/0.03
207:
Threads started!
[ 60s ] thds: 256 tps: 2455.21 qps: 2455.21 (r/w/o: 2455.21/0.00/0.00) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 256 tps: 2542.89 qps: 2542.89 (r/w/o: 2542.89/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 180s ] thds: 256 tps: 2531.83 qps: 2531.83 (r/w/o: 2531.83/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 240s ] thds: 256 tps: 2522.21 qps: 2522.21 (r/w/o: 2522.21/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 256 tps: 2574.49 qps: 2574.49 (r/w/o: 2574.49/0.00/0.00) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 757857
write: 0
other: 0
total: 757857
transactions: 757857 (2525.42 per sec.)
queries: 757857 (2525.42 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2525.4235
time elapsed: 300.0911s
total number of events: 757857
Latency (ms):
min: 16.23
avg: 101.35
max: 805.33
95th percentile: 130.13
sum: 76807891.32
Threads fairness:
events (avg/stddev): 2960.3789/22.88
execution time (avg/stddev): 300.0308/0.02
216:
Threads started!
[ 60s ] thds: 256 tps: 2440.70 qps: 2440.70 (r/w/o: 2440.70/0.00/0.00) lat (ms,95%): 132.49 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 256 tps: 2546.76 qps: 2546.76 (r/w/o: 2546.76/0.00/0.00) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
[ 180s ] thds: 256 tps: 2533.84 qps: 2533.84 (r/w/o: 2533.84/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 240s ] thds: 256 tps: 2519.65 qps: 2519.65 (r/w/o: 2519.65/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 256 tps: 2550.69 qps: 2550.69 (r/w/o: 2550.69/0.00/0.00) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 755778
write: 0
other: 0
total: 755778
transactions: 755778 (2518.96 per sec.)
queries: 755778 (2518.96 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2518.9579
time elapsed: 300.0360s
total number of events: 755778
Latency (ms):
min: 18.42
avg: 101.62
max: 798.80
95th percentile: 130.13
sum: 76802088.94
Threads fairness:
events (avg/stddev): 2952.2578/9.94
execution time (avg/stddev): 300.0082/0.01
