阿里云99元服务器Sysbench性能测试

配置：2C2G40G(2120IOPS)

操作系统：Debian 12.5
数据库：MariaDB 10.11.6
测试软件：Sysbench 1.0.20

测试内容一：
50个表，每表50W行数据，运行200秒，启用4个线程

结果：

SQL statistics:
    queries performed:
        read:                            248374
        write:                           70964
        other:                           35482
        total:                           354820
    transactions:                        17741  (88.67 per sec.)
    queries:                             354820 (1773.45 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          200.0721s
    total number of events:              17741

Latency (ms):
         min:                                    5.33
         avg:                                   45.10
         max:                                  841.74
         95th percentile:                      176.73
         sum:                               800116.40

Threads fairness:
    events (avg/stddev):           4435.2500/17.08
    execution time (avg/stddev):   200.0291/0.03

测试内容二：
20个表，每表10W行数据，运行180秒，启用4个线程

结果：

SQL statistics:
    queries performed:
        read:                            1010142
        write:                           288612
        other:                           144306
        total:                           1443060
    transactions:                        72153  (400.82 per sec.)
    queries:                             1443060 (8016.48 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          180.0102s
    total number of events:              72153

Latency (ms):
         min:                                    1.99
         avg:                                    9.98
         max:                                  386.12
         95th percentile:                       17.63
         sum:                               719833.49

Threads fairness:
    events (avg/stddev):           18038.2500/46.84
    execution time (avg/stddev):   179.9584/0.00

测试时间：2024年6月29日