[root@oceanbase1 sysbench]# time bin/sysbench share/sysbench/oltp_read_write.lua   --mysql-host=10.20.148.118 --mysql-port=2881 --mysql-db=test --mysql-user='root@xcmysql' --mysql-password='hundsun1!' --table_size=1000000 --tables=300 --threads=10 --report-interval=20  prepare

 real    177m30.261s
user    8m37.781s
sys     0m26.147s
You have new mail in /var/spool/mail/root



bin/sysbench share/sysbench/oltp_read_only.lua --mysql-host=10.20.148.118 --mysql-port=2881 --mysql-db=test --mysql-user='root@xcmysql' --mysql-password='hundsun1!' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run >  ob_oltp_read_only.log &
 

SQL statistics:
    queries performed:
        read:                            19667326
        write:                           0
        other:                           2809618
        total:                           22476944
    transactions:                        1404809 (390.07 per sec.)
    queries:                             22476944 (6241.10 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3601.4390s
    total number of events:              1404809

Latency (ms):
         min:                                   64.72
         avg:                                  256.31
         max:                                 6516.21
         95th percentile:                      493.24
         sum:                            360060603.30

Threads fairness:
    events (avg/stddev):           14048.0900/77.02
    execution time (avg/stddev):   3600.6060/0.39


bin/sysbench share/sysbench/oltp_read_write.lua --mysql-host=10.20.148.118 --mysql-port=2881 --mysql-db=test --mysql-user='root@xcmysql' --mysql-password='hundsun1!' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > ob_read_wirte.log &

SQL statistics:
    queries performed:
        read:                            283248
        write:                           58829
        other:                           62563
        total:                           404640
    transactions:                        20232  (5.59 per sec.)
    queries:                             404640 (111.81 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3618.9957s
    total number of events:              20232

Latency (ms):
         min:                                  725.94
         avg:                                17848.28
         max:                                35521.95
         95th percentile:                    26382.13
         sum:                            361106445.77

Threads fairness:
    events (avg/stddev):           202.3200/2.41
    execution time (avg/stddev):   3611.0645/5.95



 

bin/sysbench share/sysbench/oltp_update_index.lua --mysql-host=10.20.148.118 --mysql-port=2881 --mysql-db=test --mysql-user='root@xcmysql' --mysql-password='hundsun1!' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > ob_update_index.log &
 
SQL statistics:
    queries performed:
        read:                            0
        write:                           153910
        other:                           87579
        total:                           241489
    transactions:                        241489 (67.05 per sec.)
    queries:                             241489 (67.05 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3601.8614s
    total number of events:              241489

Latency (ms):
         min:                                    0.89
         avg:                                 1491.12
         max:                                 5383.09
         95th percentile:                     2728.81
         sum:                            360090067.75

Threads fairness:
    events (avg/stddev):           2414.8900/22.65
    execution time (avg/stddev):   3600.9007/0.49




bin/sysbench share/sysbench/oltp_update_non_index.lua   --mysql-host=10.20.148.118 --mysql-port=2881 --mysql-db=test --mysql-user='root@xcmysql' --mysql-password='hundsun1!' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run  > ob_update_non_index.log &
SQL statistics:
    queries performed:
        read:                            0
        write:                           268173
        other:                           152679
        total:                           420852
    transactions:                        420852 (116.85 per sec.)
    queries:                             420852 (116.85 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3601.6853s
    total number of events:              420852

Latency (ms):
         min:                                    0.17
         avg:                                  855.58
         max:                                 3845.94
         95th percentile:                     1678.14
         sum:                            360073485.92

Threads fairness:
    events (avg/stddev):           4208.5200/27.68
    execution time (avg/stddev):   3600.7349/0.48

 


------------------------------------------
------------------------------------------
------------------------------------------


[root@oceanbase1 sysbench]# time bin/sysbench share/sysbench/oltp_read_write.lua   --mysql-host=10.20.148.118 --mysql-port=3306 --mysql-db=test --mysql-user='root' --mysql-password='123456' --table_size=1000000 --tables=300 --threads=10 --report-interval=20  prepare

real    25m25.405s
user    8m36.172s
sys     0m23.368s



bin/sysbench share/sysbench/oltp_read_only.lua --mysql-host=10.20.148.118 --mysql-port=3306 --mysql-db=test --mysql-user='root' --mysql-password='123456' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > mysql_oltp_read_only.log

SQL statistics:
    queries performed:
        read:                            13023458
        write:                           0
        other:                           1860494
        total:                           14883952
    transactions:                        930247 (258.36 per sec.)
    queries:                             14883952 (4133.81 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3600.5393s
    total number of events:              930247

Latency (ms):
         min:                                    2.17
         avg:                                  387.01
         max:                                 3238.68
         95th percentile:                      831.46
         sum:                            360012999.29

Threads fairness:
    events (avg/stddev):           9302.4700/63.33
    execution time (avg/stddev):   3600.1300/0.11






bin/sysbench share/sysbench/oltp_read_write.lua --mysql-host=10.20.148.118 --mysql-port=3306 --mysql-db=test --mysql-user='root' --mysql-password='123456' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > mysql_read_wirte.log


SQL statistics:
    queries performed:
        read:                            3759714
        write:                           1074204
        other:                           537102
        total:                           5371020
    transactions:                        268551 (74.54 per sec.)
    queries:                             5371020 (1490.77 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3602.8388s
    total number of events:              268551

Latency (ms):
         min:                                    4.34
         avg:                                 1340.87
         max:                                 9432.73
         95th percentile:                     2985.89
         sum:                            360091912.45

Threads fairness:
    events (avg/stddev):           2685.5100/27.42
    execution time (avg/stddev):   3600.9191/0.41




bin/sysbench share/sysbench/oltp_update_index.lua --mysql-host=10.20.148.118 --mysql-port=3306 --mysql-db=test --mysql-user='root' --mysql-password='123456' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > mysql_oltp_update_index.log &

SQL statistics:
    queries performed:
        read:                            0
        write:                           1315267
        other:                           0
        total:                           1315267
    transactions:                        1315267 (365.34 per sec.)
    queries:                             1315267 (365.34 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3600.1160s
    total number of events:              1315267

Latency (ms):
         min:                                    0.50
         avg:                                  273.71
         max:                                 5677.20
         95th percentile:                     1280.93
         sum:                            360002849.83

Threads fairness:
    events (avg/stddev):           13152.6700/174.34
    execution time (avg/stddev):   3600.0285/0.02





bin/sysbench share/sysbench/oltp_update_index.lua --mysql-host=10.20.148.118 --mysql-port=3306 --mysql-db=test --mysql-user='root' --mysql-password='123456' --table_size=1000000 --tables=300 --threads=100 --report-interval=100 --time=3600 run > mysql_oltp_update_non_index.log &

SQL statistics:
    queries performed:
        read:                            0
        write:                           1334627
        other:                           0
        total:                           1334627
    transactions:                        1334627 (370.20 per sec.)
    queries:                             1334627 (370.20 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          3605.1843s
    total number of events:              1334627

Latency (ms):
         min:                                    0.51
         avg:                                  269.75
         max:                                 7747.87
         95th percentile:                     1069.86
         sum:                            360019538.56

Threads fairness:
    events (avg/stddev):           13346.2700/115.81
    execution time (avg/stddev):   3600.1954/0.90