mysql单机
#初始化测试数据
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=xxx.xxx.xxx.xxx --mysql-db=test --mysql-user=hzhadmin --mysql-password=Admi --tables=10 --table-size=1000000 prepare
#运行性能测试
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=xxx.xxx.xxxx.xxx --mysql-db=test --mysql-user=hzhadmin --mysql-password=Admin --tables=10 --table-size=1000000 --threads=16 --time=300 run
result
SQL statistics:
queries performed:
read: 482090
write: 137740
other: 68870
total: 688700
transactions: 34435 (114.73 per sec.)
queries: 688700 (2294.51 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.1499s
total number of events: 34435
Latency (ms):
min: 11.98
avg: 139.42
max: 1393.27
95th percentile: 287.38
sum: 4801027.93
Threads fairness:
events (avg/stddev): 2152.1875/24.58
execution time (avg/stddev): 300.0642/0.04
pxc集群
#初始化测试数据
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=xxx.xxx.xxx.xxx --mysql-db=test --mysql-user=hzhadmin --mysql-password=Admin --tables=10 --table-size=1000000 prepare
#运行性能测试
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=xxx.xxx.xxx.xxx --mysql-db=test --mysql-user=hzhadmin --mysql-password=Admin --tables=10 --table-size=1000000 --threads=16 --time=300 run
418

被折叠的 条评论
为什么被折叠?



