this is may latest compile: mariadb --version mariadb from 11.8.0-MariaDB, client 15.2 for Linux (x86_64) using EditLine wrapper root@vps:~/compile# uname -a Linux vps 6.12.12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.12-1 (2025-02-02) x86_64 GNU/Linux root@vps:~/compile# date Thu Feb 6 06:00:26 PM CET 2025 Version: '11.8.0-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 2025-02-06 17:05:23 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections. 2025-02-06 17:05:23 0 [Note] mariadbd: Event Scheduler: Loaded 0 events 2025-02-06 17:05:23 0 [Warning] 'proxies_priv' entry '@% mysql@vps' ignored in --skip-name-resolve mode. 2025-02-06 17:05:23 0 [Warning] 'user' entry '@vps' ignored in --skip-name-resolve mode. 2025-02-06 17:05:23 0 [Note] Server socket created on IP: '::'. 2025-02-06 17:05:23 0 [Note] Server socket created on IP: '0.0.0.0'. 2025-02-06 17:05:23 0 [Note] InnoDB: Buffer pool(s) load completed at 250206 17:05:23 2025-02-06 17:05:23 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2025-02-06 17:05:23 0 [Note] Plugin 'wsrep-provider' is disabled. 2025-02-06 17:05:23 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-02-06 17:05:23 0 [Note] InnoDB: log sequence number 73966525460; transaction id 369018591 2025-02-06 17:05:23 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-02-06 17:05:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-02-06 17:05:23 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. 2025-02-06 17:05:23 0 [Note] InnoDB: Opened 3 undo tablespaces 2025-02-06 17:05:23 0 [Note] InnoDB: End of log at LSN=73966525460 2025-02-06 17:05:23 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) 2025-02-06 17:05:23 0 [Note] InnoDB: Completed initialization of buffer pool 2025-02-06 17:05:23 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB 2025-02-06 17:05:23 0 [Note] InnoDB: Using liburing 2025-02-06 17:05:23 0 [Note] InnoDB: Using AVX512 instructions 2025-02-06 17:05:23 0 [Note] InnoDB: Number of transaction pools: 1 2025-02-06 17:05:23 0 [Note] InnoDB: Compressed tables use zlib 1.3.1 2025-02-06 17:05:23 0 [Note] Starting MariaDB 11.8.0-MariaDB source revision edd52b7fc7d6500fd6fcf377c54c8dc2ed365061 server_uid ZaNAImpF1d14bSNP5nqiBemsjaA= as process 32 ##############attention now comes 3 runs of benchmarks after than my old version with 3 runs again sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 75670 write: 0 other: 10810 total: 86480 transactions: 5405 (540.12 per sec.) queries: 86480 (8641.93 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0062s total number of events: 5405 Latency (ms): min: 0.15 avg: 3.70 max: 25.51 95th percentile: 11.87 sum: 19996.51 Threads fairness: events (avg/stddev): 2702.5000/66.50 execution time (avg/stddev): 9.9983/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 69622 write: 0 other: 9946 total: 79568 transactions: 4973 (496.78 per sec.) queries: 79568 (7948.48 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0095s total number of events: 4973 Latency (ms): min: 0.20 avg: 4.02 max: 33.06 95th percentile: 13.22 sum: 20001.26 Threads fairness: events (avg/stddev): 2486.5000/84.50 execution time (avg/stddev): 10.0006/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 379349 other: 288817 total: 668166 transactions: 111361 (11132.95 per sec.) queries: 668166 (66797.67 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0021s total number of events: 111361 Latency (ms): min: 0.05 avg: 0.18 max: 16.22 95th percentile: 0.34 sum: 19944.78 Threads fairness: events (avg/stddev): 55680.5000/796.50 execution time (avg/stddev): 9.9724/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 401360 other: 217570 total: 618930 transactions: 103155 (10312.82 per sec.) queries: 618930 (61876.94 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0020s total number of events: 103155 Latency (ms): min: 0.06 avg: 0.19 max: 8.34 95th percentile: 0.36 sum: 19946.90 Threads fairness: events (avg/stddev): 51577.5000/258.50 execution time (avg/stddev): 9.9735/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 622703 other: 21624 total: 644327 transactions: 644327 (64421.21 per sec.) queries: 644327 (64421.21 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0011s total number of events: 644327 Latency (ms): min: 0.01 avg: 0.03 max: 11.91 95th percentile: 0.10 sum: 19887.50 Threads fairness: events (avg/stddev): 322163.5000/336.50 execution time (avg/stddev): 9.9437/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 468488 other: 16302 total: 484790 transactions: 484790 (48468.60 per sec.) queries: 484790 (48468.60 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0011s total number of events: 484790 Latency (ms): min: 0.01 avg: 0.04 max: 14.43 95th percentile: 0.10 sum: 19890.27 Threads fairness: events (avg/stddev): 242395.0000/5088.00 execution time (avg/stddev): 9.9451/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 438106 other: 15399 total: 453505 transactions: 453505 (45343.00 per sec.) queries: 453505 (45343.00 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 453505 Latency (ms): min: 0.01 avg: 0.04 max: 17.07 95th percentile: 0.07 sum: 19892.89 Threads fairness: events (avg/stddev): 226752.5000/4408.50 execution time (avg/stddev): 9.9464/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 606778 other: 21423 total: 628201 transactions: 628201 (62799.89 per sec.) queries: 628201 (62799.89 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0026s total number of events: 628201 Latency (ms): min: 0.01 avg: 0.03 max: 9.97 95th percentile: 0.05 sum: 19876.30 Threads fairness: events (avg/stddev): 314100.5000/7753.50 execution time (avg/stddev): 9.9382/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 21154 write: 5892 other: 3171 total: 30217 transactions: 1510 (150.79 per sec.) queries: 30217 (3017.57 per sec.) ignored errors: 1 (0.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0118s total number of events: 1510 Latency (ms): min: 5.50 avg: 13.25 max: 80.50 95th percentile: 19.29 sum: 20008.70 Threads fairness: events (avg/stddev): 755.0000/5.00 execution time (avg/stddev): 10.0044/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 21966 write: 6131 other: 3279 total: 31376 transactions: 1568 (156.74 per sec.) queries: 31376 (3136.31 per sec.) ignored errors: 1 (0.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0031s total number of events: 1568 Latency (ms): min: 5.19 avg: 12.75 max: 31.83 95th percentile: 18.95 sum: 19992.37 Threads fairness: events (avg/stddev): 784.0000/1.00 execution time (avg/stddev): 9.9962/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1538851 write: 0 other: 0 total: 1538851 transactions: 1538851 (153866.85 per sec.) queries: 1538851 (153866.85 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 1538851 Latency (ms): min: 0.01 avg: 0.01 max: 5.70 95th percentile: 0.03 sum: 19780.98 Threads fairness: events (avg/stddev): 769425.5000/5560.50 execution time (avg/stddev): 9.8905/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 709729 write: 0 other: 0 total: 709729 transactions: 709729 (70964.93 per sec.) queries: 709729 (70964.93 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 709729 Latency (ms): min: 0.01 avg: 0.03 max: 4.16 95th percentile: 0.05 sum: 19852.72 Threads fairness: events (avg/stddev): 354864.5000/3487.50 execution time (avg/stddev): 9.9264/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 557167 other: 0 total: 557167 transactions: 557167 (55693.30 per sec.) queries: 557167 (55693.30 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0029s total number of events: 557167 Latency (ms): min: 0.01 avg: 0.04 max: 7.65 95th percentile: 0.08 sum: 19513.24 Threads fairness: events (avg/stddev): 278583.5000/4417.50 execution time (avg/stddev): 9.7566/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 465984 other: 0 total: 465984 transactions: 465984 (46592.20 per sec.) queries: 465984 (46592.20 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 465984 Latency (ms): min: 0.01 avg: 0.04 max: 24.66 95th percentile: 0.10 sum: 19588.12 Threads fairness: events (avg/stddev): 232992.0000/2807.00 execution time (avg/stddev): 9.7941/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 144258 other: 534457 total: 678715 transactions: 678715 (67859.17 per sec.) queries: 678715 (67859.17 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0012s total number of events: 678715 Latency (ms): min: 0.01 avg: 0.03 max: 5.06 95th percentile: 0.05 sum: 19855.60 Threads fairness: events (avg/stddev): 339357.5000/3362.50 execution time (avg/stddev): 9.9278/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 149161 other: 909681 total: 1058842 transactions: 1058842 (105870.39 per sec.) queries: 1058842 (105870.39 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0006s total number of events: 1058842 Latency (ms): min: 0.01 avg: 0.02 max: 5.47 95th percentile: 0.03 sum: 19798.83 Threads fairness: events (avg/stddev): 529421.0000/6778.00 execution time (avg/stddev): 9.8994/0.00 #############################################################bench run 2 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 71764 write: 0 other: 10252 total: 82016 transactions: 5126 (512.26 per sec.) queries: 82016 (8196.23 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0060s total number of events: 5126 Latency (ms): min: 0.16 avg: 3.90 max: 24.17 95th percentile: 12.98 sum: 19996.81 Threads fairness: events (avg/stddev): 2563.0000/15.00 execution time (avg/stddev): 9.9984/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 72044 write: 0 other: 10292 total: 82336 transactions: 5146 (514.40 per sec.) queries: 82336 (8230.39 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0033s total number of events: 5146 Latency (ms): min: 0.19 avg: 3.88 max: 26.06 95th percentile: 13.46 sum: 19990.43 Threads fairness: events (avg/stddev): 2573.0000/9.00 execution time (avg/stddev): 9.9952/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 630279 other: 495837 total: 1126116 transactions: 187684 (18762.92 per sec.) queries: 1126116 (112578.72 per sec.) ignored errors: 3 (0.30 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0022s total number of events: 187684 Latency (ms): min: 0.04 avg: 0.11 max: 9.72 95th percentile: 0.22 sum: 19925.27 Threads fairness: events (avg/stddev): 93842.0000/781.00 execution time (avg/stddev): 9.9626/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 557211 other: 354711 total: 911922 transactions: 151987 (15195.09 per sec.) queries: 911922 (91170.53 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0018s total number of events: 151987 Latency (ms): min: 0.06 avg: 0.13 max: 13.51 95th percentile: 0.24 sum: 19934.23 Threads fairness: events (avg/stddev): 75993.5000/869.50 execution time (avg/stddev): 9.9671/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 769864 other: 91693 total: 861557 transactions: 861557 (86136.68 per sec.) queries: 861557 (86136.68 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0015s total number of events: 861557 Latency (ms): min: 0.01 avg: 0.02 max: 8.34 95th percentile: 0.04 sum: 19839.40 Threads fairness: events (avg/stddev): 430778.5000/14145.50 execution time (avg/stddev): 9.9197/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 782895 other: 94106 total: 877001 transactions: 877001 (87678.05 per sec.) queries: 877001 (87678.05 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0018s total number of events: 877001 Latency (ms): min: 0.01 avg: 0.02 max: 10.74 95th percentile: 0.03 sum: 19835.78 Threads fairness: events (avg/stddev): 438500.5000/14107.50 execution time (avg/stddev): 9.9179/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 706260 other: 84754 total: 791014 transactions: 791014 (79090.71 per sec.) queries: 791014 (79090.71 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 791014 Latency (ms): min: 0.01 avg: 0.03 max: 13.52 95th percentile: 0.04 sum: 19855.30 Threads fairness: events (avg/stddev): 395507.0000/362.00 execution time (avg/stddev): 9.9276/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 498199 other: 60267 total: 558466 transactions: 558466 (55841.43 per sec.) queries: 558466 (55841.43 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 558466 Latency (ms): min: 0.01 avg: 0.04 max: 11.48 95th percentile: 0.06 sum: 19883.07 Threads fairness: events (avg/stddev): 279233.0000/6425.00 execution time (avg/stddev): 9.9415/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 26418 write: 6984 other: 4333 total: 37735 transactions: 1886 (188.52 per sec.) queries: 37735 (3771.95 per sec.) ignored errors: 1 (0.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0036s total number of events: 1886 Latency (ms): min: 4.63 avg: 10.60 max: 21.47 95th percentile: 15.27 sum: 19995.02 Threads fairness: events (avg/stddev): 943.0000/3.00 execution time (avg/stddev): 9.9975/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 23996 write: 6308 other: 3976 total: 34280 transactions: 1714 (171.18 per sec.) queries: 34280 (3423.59 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0117s total number of events: 1714 Latency (ms): min: 5.35 avg: 11.67 max: 27.26 95th percentile: 16.41 sum: 20006.51 Threads fairness: events (avg/stddev): 857.0000/1.00 execution time (avg/stddev): 10.0033/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1228131 write: 0 other: 0 total: 1228131 transactions: 1228131 (122796.34 per sec.) queries: 1228131 (122796.34 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 1228131 Latency (ms): min: 0.01 avg: 0.02 max: 4.58 95th percentile: 0.03 sum: 19798.85 Threads fairness: events (avg/stddev): 614065.5000/4169.50 execution time (avg/stddev): 9.8994/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1260990 write: 0 other: 0 total: 1260990 transactions: 1260990 (126084.34 per sec.) queries: 1260990 (126084.34 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 1260990 Latency (ms): min: 0.01 avg: 0.02 max: 6.46 95th percentile: 0.03 sum: 19815.67 Threads fairness: events (avg/stddev): 630495.0000/7889.00 execution time (avg/stddev): 9.9078/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 763321 other: 0 total: 763321 transactions: 763321 (76324.66 per sec.) queries: 763321 (76324.66 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 763321 Latency (ms): min: 0.01 avg: 0.03 max: 16.49 95th percentile: 0.06 sum: 19442.52 Threads fairness: events (avg/stddev): 381660.5000/925.50 execution time (avg/stddev): 9.7213/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 404877 other: 0 total: 404877 transactions: 404877 (40481.47 per sec.) queries: 404877 (40481.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0008s total number of events: 404877 Latency (ms): min: 0.01 avg: 0.05 max: 9.34 95th percentile: 0.13 sum: 19556.32 Threads fairness: events (avg/stddev): 202438.5000/3072.50 execution time (avg/stddev): 9.7782/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 112454 other: 679651 total: 792105 transactions: 792105 (79192.38 per sec.) queries: 792105 (79192.38 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0015s total number of events: 792105 Latency (ms): min: 0.01 avg: 0.03 max: 8.06 95th percentile: 0.05 sum: 19833.19 Threads fairness: events (avg/stddev): 396052.5000/7999.50 execution time (avg/stddev): 9.9166/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 80399 other: 785858 total: 866257 transactions: 866257 (86615.67 per sec.) queries: 866257 (86615.67 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 866257 Latency (ms): min: 0.01 avg: 0.02 max: 5.33 95th percentile: 0.05 sum: 19836.63 Threads fairness: events (avg/stddev): 433128.5000/2564.50 execution time (avg/stddev): 9.9183/0.00 ####################################################bench run 3 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 79730 write: 0 other: 11390 total: 91120 transactions: 5695 (568.79 per sec.) queries: 91120 (9100.58 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0118s total number of events: 5695 Latency (ms): min: 0.15 avg: 3.51 max: 20.89 95th percentile: 11.45 sum: 20008.20 Threads fairness: events (avg/stddev): 2847.5000/16.50 execution time (avg/stddev): 10.0041/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 78582 write: 0 other: 11226 total: 89808 transactions: 5613 (560.61 per sec.) queries: 89808 (8969.69 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0116s total number of events: 5613 Latency (ms): min: 0.19 avg: 3.56 max: 22.39 95th percentile: 11.65 sum: 20007.84 Threads fairness: events (avg/stddev): 2806.5000/24.50 execution time (avg/stddev): 10.0039/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 491015 other: 434171 total: 925186 transactions: 154197 (15416.70 per sec.) queries: 925186 (92500.60 per sec.) ignored errors: 1 (0.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0013s total number of events: 154197 Latency (ms): min: 0.04 avg: 0.13 max: 7.55 95th percentile: 0.25 sum: 19938.34 Threads fairness: events (avg/stddev): 77098.5000/1270.50 execution time (avg/stddev): 9.9692/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 550224 other: 376518 total: 926742 transactions: 154457 (15442.63 per sec.) queries: 926742 (92655.79 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0013s total number of events: 154457 Latency (ms): min: 0.06 avg: 0.13 max: 9.57 95th percentile: 0.24 sum: 19934.96 Threads fairness: events (avg/stddev): 77228.5000/2310.50 execution time (avg/stddev): 9.9675/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 551882 other: 90854 total: 642736 transactions: 642736 (64262.96 per sec.) queries: 642736 (64262.96 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0010s total number of events: 642736 Latency (ms): min: 0.01 avg: 0.03 max: 6.24 95th percentile: 0.07 sum: 19859.73 Threads fairness: events (avg/stddev): 321368.0000/930.00 execution time (avg/stddev): 9.9299/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 576060 other: 95159 total: 671219 transactions: 671219 (67108.71 per sec.) queries: 671219 (67108.71 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 671219 Latency (ms): min: 0.01 avg: 0.03 max: 8.15 95th percentile: 0.06 sum: 19872.02 Threads fairness: events (avg/stddev): 335609.5000/681.50 execution time (avg/stddev): 9.9360/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 574975 other: 94667 total: 669642 transactions: 669642 (66949.13 per sec.) queries: 669642 (66949.13 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0016s total number of events: 669642 Latency (ms): min: 0.01 avg: 0.03 max: 8.97 95th percentile: 0.05 sum: 19878.79 Threads fairness: events (avg/stddev): 334821.0000/10858.00 execution time (avg/stddev): 9.9394/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 437323 other: 71605 total: 508928 transactions: 508928 (50882.73 per sec.) queries: 508928 (50882.73 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0013s total number of events: 508928 Latency (ms): min: 0.01 avg: 0.04 max: 12.36 95th percentile: 0.07 sum: 19887.78 Threads fairness: events (avg/stddev): 254464.0000/13476.00 execution time (avg/stddev): 9.9439/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 21182 write: 5391 other: 3687 total: 30260 transactions: 1513 (151.07 per sec.) queries: 30260 (3021.50 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0127s total number of events: 1513 Latency (ms): min: 5.26 avg: 13.22 max: 46.97 95th percentile: 20.74 sum: 20008.77 Threads fairness: events (avg/stddev): 756.5000/4.50 execution time (avg/stddev): 10.0044/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 21000 write: 5369 other: 3631 total: 30000 transactions: 1500 (149.86 per sec.) queries: 30000 (2997.23 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0086s total number of events: 1500 Latency (ms): min: 4.98 avg: 13.34 max: 44.44 95th percentile: 21.11 sum: 20004.66 Threads fairness: events (avg/stddev): 750.0000/1.00 execution time (avg/stddev): 10.0023/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1516319 write: 0 other: 0 total: 1516319 transactions: 1516319 (151615.23 per sec.) queries: 1516319 (151615.23 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1516319 Latency (ms): min: 0.01 avg: 0.01 max: 5.93 95th percentile: 0.03 sum: 19794.21 Threads fairness: events (avg/stddev): 758159.5000/958.50 execution time (avg/stddev): 9.8971/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 997372 write: 0 other: 0 total: 997372 transactions: 997372 (99726.63 per sec.) queries: 997372 (99726.63 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 997372 Latency (ms): min: 0.01 avg: 0.02 max: 4.28 95th percentile: 0.04 sum: 19829.37 Threads fairness: events (avg/stddev): 498686.0000/2524.00 execution time (avg/stddev): 9.9147/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 599320 other: 0 total: 599320 transactions: 599320 (59925.64 per sec.) queries: 599320 (59925.64 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 599320 Latency (ms): min: 0.01 avg: 0.03 max: 6.48 95th percentile: 0.10 sum: 19524.17 Threads fairness: events (avg/stddev): 299660.0000/1865.00 execution time (avg/stddev): 9.7621/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 447009 other: 0 total: 447009 transactions: 447009 (44679.70 per sec.) queries: 447009 (44679.70 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0034s total number of events: 447009 Latency (ms): min: 0.01 avg: 0.04 max: 21.43 95th percentile: 0.12 sum: 19613.73 Threads fairness: events (avg/stddev): 223504.5000/93.50 execution time (avg/stddev): 9.8069/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 86626 other: 675742 total: 762368 transactions: 762368 (76120.95 per sec.) queries: 762368 (76120.95 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0145s total number of events: 762368 Latency (ms): min: 0.01 avg: 0.03 max: 28.77 95th percentile: 0.04 sum: 19867.82 Threads fairness: events (avg/stddev): 381184.0000/4301.00 execution time (avg/stddev): 9.9339/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 51602 other: 659605 total: 711207 transactions: 711207 (71108.54 per sec.) queries: 711207 (71108.54 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0011s total number of events: 711207 Latency (ms): min: 0.01 avg: 0.03 max: 7.06 95th percentile: 0.05 sum: 19847.64 Threads fairness: events (avg/stddev): 355603.5000/3057.50 execution time (avg/stddev): 9.9238/0.00 ############################################################ and here is my last performant version of mariadb ls -al mariadbbackup/ total 621260 drwxr-xr-x 2 root root 4096 Feb 6 16:39 . drwxr-xr-x 56 root root 4096 Feb 6 18:00 .. -rw-r--r-- 1 root root 157334028 Feb 6 14:26 mariadb-profile_06-02.2025.g3nowarning.deb -rw-r--r-- 1 root root 78816800 Dec 4 16:24 mariadb-profile_14-04-12-2024-git-1_amd64.deb -rw-r--r-- 1 root root 81487036 Feb 6 12:30 mariadb-profile_15-06-02-2025-git-1_amd64.deb -rw-r--r-- 1 root root 79253912 Dec 17 20:31 mariadb-profile_22-17-12-2024-git-1_amd64.deb -rw-r--r-- 1 root root 48372752 Feb 6 16:01 mariadb-use_06-02.2025.g3nowarning.deb -rw-r--r-- 1 root root 48380348 Feb 6 16:39 mariadb-use_27-06-02-2025-git-1_amd64.deb -rw-r--r-- 1 root root 45719324 Dec 4 16:52 mariadb-use_43-04-12-2024-git-1_amd64.deb -rw-r--r-- 1 root root 48372692 Feb 6 14:57 mariadb-use_45-06-02-2025-git-1_amd64.deb -rw-r--r-- 1 root root 48395000 Feb 6 13:08 mariadb-use_54-06-02-2025-git-1_amd64.deb mariadb-use_43-04-12-2024-git-1_amd64.deb <-- is compiled at 4.12.2024 on same machine first i remove my today compile dpkg --list|grep -oP 'mariadb.*git.*?\d'|cut -d ' ' -f1|xargs -i apt purge --remove -y {} REMOVING: mariadb-use* Summary: Upgrading: 0, Installing: 0, Removing: 1, Not Upgrading: 0 Freed space: 555 MB (Reading database ... 127035 files and directories currently installed.) Removing mariadb-use (16:27-06-02-2025-git-1) ... dpkg: warning: while removing mariadb-use, directory '/usr/local/mysql/lib/plugin/auth_pam_tool_dir' not empty so not removed dpkg: warning: while removing mariadb-use, directory '/usr/local/mysql/bin' not empty so not removed root@vps:~/compile# dpkg -i mariadbbackup/mariadb-use_43-04-12-2024-git-1_amd64.deb Selecting previously unselected package mariadb-use. (Reading database ... 106373 files and directories currently installed.) Preparing to unpack .../mariadb-use_43-04-12-2024-git-1_amd64.deb ... Unpacking mariadb-use (16:43-04-12-2024-git-1) ... Setting up mariadb-use (16:43-04-12-2024-git-1) ... mariadb --version /usr/local/mysql/bin/mariadb from 11.8.0-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1 Version: '11.8.0-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 2025-02-06 17:19:59 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections. 2025-02-06 17:19:59 0 [Note] mariadbd: Event Scheduler: Loaded 0 events 2025-02-06 17:19:59 0 [Warning] 'proxies_priv' entry '@% mysql@' ignored in --skip-name-resolve mode. 2025-02-06 17:19:59 0 [Warning] 'user' entry '@' ignored in --skip-name-resolve mode. 2025-02-06 17:19:59 0 [Note] Server socket created on IP: '::'. 2025-02-06 17:19:59 0 [Note] Server socket created on IP: '0.0.0.0'. 2025-02-06 17:19:59 0 [Note] InnoDB: Buffer pool(s) load completed at 250206 17:19:59 2025-02-06 17:19:59 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2025-02-06 17:19:59 0 [Note] Plugin 'wsrep-provider' is disabled. 2025-02-06 17:19:59 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-02-06 17:19:59 0 [Note] InnoDB: log sequence number 75323975145; transaction id 378423824 2025-02-06 17:19:59 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-02-06 17:19:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-02-06 17:19:59 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. 2025-02-06 17:19:59 0 [Note] InnoDB: Opened 3 undo tablespaces 2025-02-06 17:19:59 0 [Note] InnoDB: End of log at LSN=75323975145 2025-02-06 17:19:59 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) 2025-02-06 17:19:59 0 [Note] InnoDB: Completed initialization of buffer pool 2025-02-06 17:19:59 0 [Note] InnoDB: Initializing buffer pool, total size = 1.000GiB, chunk size = 16.000MiB 2025-02-06 17:19:59 0 [Note] InnoDB: Using liburing 2025-02-06 17:19:59 0 [Note] InnoDB: Using AVX512 instructions 2025-02-06 17:19:59 0 [Note] InnoDB: Number of transaction pools: 1 2025-02-06 17:19:59 0 [Note] InnoDB: Compressed tables use zlib 1.3.1 2025-02-06 17:19:59 0 [Note] Starting MariaDB 11.8.0-MariaDB source revision f5821aaf7731e1f74b970fdaf186b945ae012c9d server_uid Ic9C7wpEED7K/Xqzl3GNA8r9FIs= as process 32 ##############################here is my benchmark again - 3 runs again - sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1134770 write: 0 other: 162110 total: 1296880 transactions: 81055 (8104.41 per sec.) queries: 1296880 (129670.58 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0008s total number of events: 81055 Latency (ms): min: 0.13 avg: 0.25 max: 11.30 95th percentile: 0.37 sum: 19969.20 Threads fairness: events (avg/stddev): 40527.5000/618.50 execution time (avg/stddev): 9.9846/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1076488 write: 0 other: 153784 total: 1230272 transactions: 76892 (7688.09 per sec.) queries: 1230272 (123009.48 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0009s total number of events: 76892 Latency (ms): min: 0.16 avg: 0.26 max: 12.30 95th percentile: 0.36 sum: 19972.62 Threads fairness: events (avg/stddev): 38446.0000/130.00 execution time (avg/stddev): 9.9863/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 441194 other: 315510 total: 756704 transactions: 126116 (12609.23 per sec.) queries: 756704 (75656.21 per sec.) ignored errors: 2 (0.20 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0013s total number of events: 126116 Latency (ms): min: 0.05 avg: 0.16 max: 7.39 95th percentile: 0.23 sum: 19958.11 Threads fairness: events (avg/stddev): 63058.0000/3009.00 execution time (avg/stddev): 9.9791/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 439925 other: 232111 total: 672036 transactions: 112006 (11198.31 per sec.) queries: 672036 (67189.87 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0014s total number of events: 112006 Latency (ms): min: 0.06 avg: 0.18 max: 8.37 95th percentile: 0.26 sum: 19964.48 Threads fairness: events (avg/stddev): 56003.0000/1978.00 execution time (avg/stddev): 9.9822/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 649822 other: 15279 total: 665101 transactions: 665101 (66502.74 per sec.) queries: 665101 (66502.74 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 665101 Latency (ms): min: 0.01 avg: 0.03 max: 8.27 95th percentile: 0.07 sum: 19901.43 Threads fairness: events (avg/stddev): 332550.5000/8580.50 execution time (avg/stddev): 9.9507/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 934515 other: 21881 total: 956396 transactions: 956396 (95626.50 per sec.) queries: 956396 (95626.50 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 956396 Latency (ms): min: 0.01 avg: 0.02 max: 16.71 95th percentile: 0.03 sum: 19888.40 Threads fairness: events (avg/stddev): 478198.0000/6173.00 execution time (avg/stddev): 9.9442/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 566401 other: 13299 total: 579700 transactions: 579700 (57961.66 per sec.) queries: 579700 (57961.66 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0009s total number of events: 579700 Latency (ms): min: 0.01 avg: 0.03 max: 8.48 95th percentile: 0.05 sum: 19919.02 Threads fairness: events (avg/stddev): 289850.0000/24703.00 execution time (avg/stddev): 9.9595/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 608850 other: 14277 total: 623127 transactions: 623127 (62288.36 per sec.) queries: 623127 (62288.36 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0033s total number of events: 623127 Latency (ms): min: 0.01 avg: 0.03 max: 5.55 95th percentile: 0.05 sum: 19912.89 Threads fairness: events (avg/stddev): 311563.5000/22297.50 execution time (avg/stddev): 9.9564/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 380688 write: 106915 other: 56203 total: 543806 transactions: 27183 (2717.77 per sec.) queries: 543806 (54369.93 per sec.) ignored errors: 9 (0.90 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0014s total number of events: 27183 Latency (ms): min: 0.37 avg: 0.74 max: 9.33 95th percentile: 1.03 sum: 19989.60 Threads fairness: events (avg/stddev): 13591.5000/210.50 execution time (avg/stddev): 9.9948/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 528668 write: 148406 other: 78122 total: 755196 transactions: 37751 (3773.76 per sec.) queries: 755196 (75492.79 per sec.) ignored errors: 11 (1.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0030s total number of events: 37751 Latency (ms): min: 0.41 avg: 0.53 max: 10.70 95th percentile: 0.60 sum: 19983.11 Threads fairness: events (avg/stddev): 18875.5000/118.50 execution time (avg/stddev): 9.9916/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1456515 write: 0 other: 0 total: 1456515 transactions: 1456515 (145636.40 per sec.) queries: 1456515 (145636.40 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1456515 Latency (ms): min: 0.01 avg: 0.01 max: 2.57 95th percentile: 0.02 sum: 19762.54 Threads fairness: events (avg/stddev): 728257.5000/10430.50 execution time (avg/stddev): 9.8813/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1415980 write: 0 other: 0 total: 1415980 transactions: 1415980 (141582.37 per sec.) queries: 1415980 (141582.37 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 1415980 Latency (ms): min: 0.01 avg: 0.01 max: 2.68 95th percentile: 0.02 sum: 19767.56 Threads fairness: events (avg/stddev): 707990.0000/8536.00 execution time (avg/stddev): 9.8838/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 652266 other: 0 total: 652266 transactions: 652266 (65218.29 per sec.) queries: 652266 (65218.29 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0006s total number of events: 652266 Latency (ms): min: 0.01 avg: 0.03 max: 11.13 95th percentile: 0.05 sum: 19700.88 Threads fairness: events (avg/stddev): 326133.0000/2625.00 execution time (avg/stddev): 9.8504/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 685940 other: 0 total: 685940 transactions: 685940 (68582.95 per sec.) queries: 685940 (68582.95 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0007s total number of events: 685940 Latency (ms): min: 0.01 avg: 0.03 max: 17.84 95th percentile: 0.04 sum: 19691.02 Threads fairness: events (avg/stddev): 342970.0000/5991.00 execution time (avg/stddev): 9.8455/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 233991 other: 965305 total: 1199296 transactions: 1199296 (119889.70 per sec.) queries: 1199296 (119889.70 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0027s total number of events: 1199296 Latency (ms): min: 0.01 avg: 0.02 max: 5.44 95th percentile: 0.02 sum: 19806.91 Threads fairness: events (avg/stddev): 599648.0000/14446.00 execution time (avg/stddev): 9.9035/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 130262 other: 904608 total: 1034870 transactions: 1034870 (103476.52 per sec.) queries: 1034870 (103476.52 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1034870 Latency (ms): min: 0.01 avg: 0.02 max: 4.36 95th percentile: 0.03 sum: 19846.31 Threads fairness: events (avg/stddev): 517435.0000/17610.00 execution time (avg/stddev): 9.9232/0.00 ######################################run 2 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1231510 write: 0 other: 175930 total: 1407440 transactions: 87965 (8795.24 per sec.) queries: 1407440 (140723.90 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0008s total number of events: 87965 Latency (ms): min: 0.13 avg: 0.23 max: 4.04 95th percentile: 0.34 sum: 19968.25 Threads fairness: events (avg/stddev): 43982.5000/208.50 execution time (avg/stddev): 9.9841/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1001322 write: 0 other: 143046 total: 1144368 transactions: 71523 (7151.25 per sec.) queries: 1144368 (114420.03 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0009s total number of events: 71523 Latency (ms): min: 0.16 avg: 0.28 max: 9.81 95th percentile: 0.56 sum: 19973.96 Threads fairness: events (avg/stddev): 35761.5000/155.50 execution time (avg/stddev): 9.9870/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 614048 other: 493858 total: 1107906 transactions: 184651 (18461.84 per sec.) queries: 1107906 (110771.06 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0012s total number of events: 184651 Latency (ms): min: 0.05 avg: 0.11 max: 13.30 95th percentile: 0.19 sum: 19947.04 Threads fairness: events (avg/stddev): 92325.5000/842.50 execution time (avg/stddev): 9.9735/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 563658 other: 366984 total: 930642 transactions: 155107 (15507.46 per sec.) queries: 930642 (93044.78 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0014s total number of events: 155107 Latency (ms): min: 0.06 avg: 0.13 max: 12.99 95th percentile: 0.23 sum: 19944.23 Threads fairness: events (avg/stddev): 77553.5000/6960.50 execution time (avg/stddev): 9.9721/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 750733 other: 99787 total: 850520 transactions: 850520 (85042.23 per sec.) queries: 850520 (85042.23 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 850520 Latency (ms): min: 0.01 avg: 0.02 max: 9.73 95th percentile: 0.04 sum: 19870.83 Threads fairness: events (avg/stddev): 425260.0000/10546.00 execution time (avg/stddev): 9.9354/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 716523 other: 95263 total: 811786 transactions: 811786 (81169.61 per sec.) queries: 811786 (81169.61 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 811786 Latency (ms): min: 0.01 avg: 0.02 max: 7.59 95th percentile: 0.04 sum: 19871.05 Threads fairness: events (avg/stddev): 405893.0000/8581.00 execution time (avg/stddev): 9.9355/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 598838 other: 79402 total: 678240 transactions: 678240 (67815.33 per sec.) queries: 678240 (67815.33 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0006s total number of events: 678240 Latency (ms): min: 0.01 avg: 0.03 max: 6.24 95th percentile: 0.05 sum: 19898.85 Threads fairness: events (avg/stddev): 339120.0000/9206.00 execution time (avg/stddev): 9.9494/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 609827 other: 80815 total: 690642 transactions: 690642 (69034.42 per sec.) queries: 690642 (69034.42 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0037s total number of events: 690642 Latency (ms): min: 0.01 avg: 0.03 max: 7.90 95th percentile: 0.05 sum: 19899.32 Threads fairness: events (avg/stddev): 345321.0000/6189.00 execution time (avg/stddev): 9.9497/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 542388 write: 141567 other: 90841 total: 774796 transactions: 38731 (3872.46 per sec.) queries: 774796 (77466.74 per sec.) ignored errors: 11 (1.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0011s total number of events: 38731 Latency (ms): min: 0.30 avg: 0.52 max: 9.01 95th percentile: 0.80 sum: 19984.91 Threads fairness: events (avg/stddev): 19365.5000/597.50 execution time (avg/stddev): 9.9925/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 495278 write: 129546 other: 82688 total: 707512 transactions: 35371 (3536.49 per sec.) queries: 707512 (70738.97 per sec.) ignored errors: 6 (0.60 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0012s total number of events: 35371 Latency (ms): min: 0.36 avg: 0.56 max: 8.05 95th percentile: 0.97 sum: 19981.02 Threads fairness: events (avg/stddev): 17685.5000/116.50 execution time (avg/stddev): 9.9905/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 865066 write: 0 other: 0 total: 865066 transactions: 865066 (86497.84 per sec.) queries: 865066 (86497.84 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 865066 Latency (ms): min: 0.01 avg: 0.02 max: 5.34 95th percentile: 0.03 sum: 19868.96 Threads fairness: events (avg/stddev): 432533.0000/24541.00 execution time (avg/stddev): 9.9345/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1306452 write: 0 other: 0 total: 1306452 transactions: 1306452 (130632.50 per sec.) queries: 1306452 (130632.50 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1306452 Latency (ms): min: 0.01 avg: 0.02 max: 3.29 95th percentile: 0.03 sum: 19785.22 Threads fairness: events (avg/stddev): 653226.0000/19830.00 execution time (avg/stddev): 9.8926/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 709136 other: 0 total: 709136 transactions: 709136 (70906.69 per sec.) queries: 709136 (70906.69 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 709136 Latency (ms): min: 0.01 avg: 0.03 max: 13.31 95th percentile: 0.04 sum: 19686.21 Threads fairness: events (avg/stddev): 354568.0000/3912.00 execution time (avg/stddev): 9.8431/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 630565 other: 0 total: 630565 transactions: 630565 (63049.55 per sec.) queries: 630565 (63049.55 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 630565 Latency (ms): min: 0.01 avg: 0.03 max: 14.03 95th percentile: 0.05 sum: 19726.91 Threads fairness: events (avg/stddev): 315282.5000/31185.50 execution time (avg/stddev): 9.8635/0.02 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 136936 other: 962908 total: 1099844 transactions: 1099844 (109973.24 per sec.) queries: 1099844 (109973.24 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1099844 Latency (ms): min: 0.01 avg: 0.02 max: 4.98 95th percentile: 0.03 sum: 19807.94 Threads fairness: events (avg/stddev): 549922.0000/48989.00 execution time (avg/stddev): 9.9040/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 93243 other: 1104344 total: 1197587 transactions: 1197587 (119744.41 per sec.) queries: 1197587 (119744.41 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0006s total number of events: 1197587 Latency (ms): min: 0.01 avg: 0.02 max: 5.90 95th percentile: 0.02 sum: 19806.86 Threads fairness: events (avg/stddev): 598793.5000/5677.50 execution time (avg/stddev): 9.9034/0.00 #######################################################################run 3 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_only.lua run oltp_read_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1664264 write: 0 other: 237752 total: 1902016 transactions: 118876 (11885.97 per sec.) queries: 1902016 (190175.51 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0008s total number of events: 118876 Latency (ms): min: 0.13 avg: 0.17 max: 4.00 95th percentile: 0.22 sum: 19965.51 Threads fairness: events (avg/stddev): 59438.0000/504.00 execution time (avg/stddev): 9.9828/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_only.lua run oltp_read_only with 3306 tcp sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1113896 write: 0 other: 159128 total: 1273024 transactions: 79564 (7955.30 per sec.) queries: 1273024 (127284.84 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0008s total number of events: 79564 Latency (ms): min: 0.16 avg: 0.25 max: 4.20 95th percentile: 0.52 sum: 19969.29 Threads fairness: events (avg/stddev): 39782.0000/2138.00 execution time (avg/stddev): 9.9846/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_write_only.lua run oltp_write_only sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 686604 other: 619200 total: 1305804 transactions: 217634 (21759.35 per sec.) queries: 1305804 (130556.08 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0013s total number of events: 217634 Latency (ms): min: 0.05 avg: 0.09 max: 5.57 95th percentile: 0.19 sum: 19935.99 Threads fairness: events (avg/stddev): 108817.0000/924.00 execution time (avg/stddev): 9.9680/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_write_only.lua run oltp_write_only with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 800339 other: 591241 total: 1391580 transactions: 231930 (23184.90 per sec.) queries: 1391580 (139109.39 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0029s total number of events: 231930 Latency (ms): min: 0.06 avg: 0.09 max: 10.73 95th percentile: 0.11 sum: 19944.26 Threads fairness: events (avg/stddev): 115965.0000/162.00 execution time (avg/stddev): 9.9721/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 775951 other: 164840 total: 940791 transactions: 940791 (94067.02 per sec.) queries: 940791 (94067.02 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0005s total number of events: 940791 Latency (ms): min: 0.01 avg: 0.02 max: 15.94 95th percentile: 0.03 sum: 19849.93 Threads fairness: events (avg/stddev): 470395.5000/565.50 execution time (avg/stddev): 9.9250/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_non_index.lua run oltp_update_non_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 684206 other: 145730 total: 829936 transactions: 829936 (82927.84 per sec.) queries: 829936 (82927.84 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0070s total number of events: 829936 Latency (ms): min: 0.01 avg: 0.02 max: 10.23 95th percentile: 0.03 sum: 19861.76 Threads fairness: events (avg/stddev): 414968.0000/213.00 execution time (avg/stddev): 9.9309/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/ oltp_update_index.lua run oltp_update_index sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 511047 other: 108577 total: 619624 transactions: 619624 (61943.63 per sec.) queries: 619624 (61943.63 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0024s total number of events: 619624 Latency (ms): min: 0.01 avg: 0.03 max: 5.14 95th percentile: 0.05 sum: 19912.73 Threads fairness: events (avg/stddev): 309812.0000/3575.00 execution time (avg/stddev): 9.9564/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_update_index.lua run oltp_update_index with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 473103 other: 100284 total: 573387 transactions: 573387 (57331.86 per sec.) queries: 573387 (57331.86 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 573387 Latency (ms): min: 0.01 avg: 0.03 max: 6.98 95th percentile: 0.06 sum: 19913.47 Threads fairness: events (avg/stddev): 286693.5000/4621.50 execution time (avg/stddev): 9.9567/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_read_write.lua run oltp_read_write sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 568134 write: 141193 other: 102252 total: 811579 transactions: 40570 (4056.08 per sec.) queries: 811579 (81139.42 per sec.) ignored errors: 11 (1.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0017s total number of events: 40570 Latency (ms): min: 0.25 avg: 0.49 max: 7.12 95th percentile: 0.77 sum: 19982.45 Threads fairness: events (avg/stddev): 20285.0000/514.00 execution time (avg/stddev): 9.9912/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_read_write.lua run oltp_read_write with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 545902 write: 135910 other: 98008 total: 779820 transactions: 38983 (3897.37 per sec.) queries: 779820 (77963.30 per sec.) ignored errors: 10 (1.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0018s total number of events: 38983 Latency (ms): min: 0.31 avg: 0.51 max: 7.07 95th percentile: 0.89 sum: 19983.55 Threads fairness: events (avg/stddev): 19491.5000/167.50 execution time (avg/stddev): 9.9918/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_point_select.lua run oltp_point_select sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1477957 write: 0 other: 0 total: 1477957 transactions: 1477957 (147780.84 per sec.) queries: 1477957 (147780.84 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1477957 Latency (ms): min: 0.01 avg: 0.01 max: 2.51 95th percentile: 0.02 sum: 19756.90 Threads fairness: events (avg/stddev): 738978.5000/6304.50 execution time (avg/stddev): 9.8785/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_point_select.lua run oltp_point_select with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 1457298 write: 0 other: 0 total: 1457298 transactions: 1457298 (145715.34 per sec.) queries: 1457298 (145715.34 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1457298 Latency (ms): min: 0.01 avg: 0.01 max: 2.56 95th percentile: 0.02 sum: 19763.95 Threads fairness: events (avg/stddev): 728649.0000/17591.00 execution time (avg/stddev): 9.8820/0.01 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_insert.lua run oltp_insert sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 702950 other: 0 total: 702950 transactions: 702950 (70287.92 per sec.) queries: 702950 (70287.92 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 702950 Latency (ms): min: 0.01 avg: 0.03 max: 6.14 95th percentile: 0.04 sum: 19691.19 Threads fairness: events (avg/stddev): 351475.0000/3159.00 execution time (avg/stddev): 9.8456/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_insert.lua run oltp_insert with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 751773 other: 0 total: 751773 transactions: 751773 (75170.59 per sec.) queries: 751773 (75170.59 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 751773 Latency (ms): min: 0.01 avg: 0.03 max: 16.91 95th percentile: 0.04 sum: 19682.95 Threads fairness: events (avg/stddev): 375886.5000/7072.50 execution time (avg/stddev): 9.8415/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2 --mysql-socket=/tmp/mysql.sock --mysql-user=user --mysql-password=pass--mysql-db=dbname/usr/share/sysbench/oltp_delete.lua run oltp_delete sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 91418 other: 1172340 total: 1263758 transactions: 1263758 (126362.59 per sec.) queries: 1263758 (126362.59 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0004s total number of events: 1263758 Latency (ms): min: 0.01 avg: 0.02 max: 5.19 95th percentile: 0.02 sum: 19792.77 Threads fairness: events (avg/stddev): 631879.0000/5169.00 execution time (avg/stddev): 9.8964/0.00 sysbench --db-driver=mysql --table-size=100000 --tables=24 --threads=2--mysql-user=user --mysql-password=pass--mysql-db=dbname--mysql-host=10.10.20.55 --mysql-port=3306 /usr/share/sysbench/oltp_delete.lua run oltp_delete with 3306 sysbench 1.0.20 (using system LuaJIT 2.1.1700206165) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 51210 other: 1225214 total: 1276424 transactions: 1276424 (127630.32 per sec.) queries: 1276424 (127630.32 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0003s total number of events: 1276424 Latency (ms): min: 0.01 avg: 0.02 max: 5.70 95th percentile: 0.02 sum: 19798.66 Threads fairness: events (avg/stddev): 638212.0000/2797.00 execution time (avg/stddev): 9.8993/0.00