PXC数据库性能测试对比

最新推荐文章于 2025-12-03 18:58:29 发布

原创最新推荐文章于 2025-12-03 18:58:29 发布 · 250 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

mysql 专栏收录该内容

7 篇文章

订阅专栏

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