PXC数据库性能测试对比

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:                            482090write:                           137740other:                           68870total:                           688700transactions:                        34435  (114.73 per sec.)queries:                             688700 (2294.51 per sec.)ignored errors:                      0      (0.00