[smilivoj@local mysql-5.7.13]$ ./client/mysql -e "create database sbtest" [smilivoj@local mysql-5.7.13]$ find ../sysbench/ -name '*.lua' ../sysbench/usr/share/doc/sysbench/tests/db/common.lua ../sysbench/usr/share/doc/sysbench/tests/db/select_random_ranges.lua ../sysbench/usr/share/doc/sysbench/tests/db/select_random_points.lua ../sysbench/usr/share/doc/sysbench/tests/db/insert.lua ../sysbench/usr/share/doc/sysbench/tests/db/update_non_index.lua ../sysbench/usr/share/doc/sysbench/tests/db/oltp.lua ../sysbench/usr/share/doc/sysbench/tests/db/select.lua ../sysbench/usr/share/doc/sysbench/tests/db/oltp_simple.lua ../sysbench/usr/share/doc/sysbench/tests/db/delete.lua ../sysbench/usr/share/doc/sysbench/tests/db/update_index.lua ../sysbench/usr/share/doc/sysbench/tests/db/parallel_prepare.lua ../sysbench/usr/share/doc/sysbench/tests/db/bulk_insert.lua [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 prepare sysbench 0.5: multi-threaded system evaluation benchmark Creating table 'sbtest1'... Inserting 1000 records into 'sbtest1' [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global log_output='file'" [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=1" [smilivoj@local mysql-5.7.13]$ [smilivoj@local mysql-5.7.13]$ lsof -p 19862 | grep slow mysqld 19862 smilivoj 19u REG 0,38 35 91842720 /home/smilivoj/data/mysql/slow_log.CSM (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 20r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 21w REG 0,38 162 105111729 /home/smilivoj/data/hod05-slow.log (trostor01.no.oracle.com:/export/home/smilivoj) [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run & [1] 30513 [smilivoj@local mysql-5.7.13]$ sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Random number generator seed is 0 and will be ignored Initializing worker threads... Threads started! [smilivoj@local mysql-5.7.13]$ OLTP test statistics: queries performed: read: 14910 write: 4048 other: 2065 total: 21023 transactions: 1000 (61.97 per sec.) read/write requests: 18958 (1174.75 per sec.) other operations: 2065 (127.96 per sec.) ignored errors: 65 (4.03 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 16.1379s total number of events: 1000 total time taken by event execution: 128.9602s response time: min: 11.56ms avg: 128.96ms max: 448.40ms approx. 95 percentile: 255.53ms Threads fairness: events (avg/stddev): 125.0000/2.24 execution time (avg/stddev): 16.1200/0.02 [1]+ Done sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=0" [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=1" [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run & [1] 30537 [smilivoj@local mysql-5.7.13]$ sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Random number generator seed is 0 and will be ignored Initializing worker threads... Threads started! [smilivoj@local mysql-5.7.13]$ lsof -p 19862 | grep slow mysqld 19862 smilivoj 19u REG 0,38 35 91842720 /home/smilivoj/data/mysql/slow_log.CSM (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 20r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 21r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 22w REG 0,38 324 105111729 /home/smilivoj/data/hod05-slow.log (trostor01.no.oracle.com:/export/home/smilivoj) [smilivoj@local mysql-5.7.13]$ OLTP test statistics: queries performed: read: 14672 write: 4041 other: 2048 total: 20761 transactions: 1000 (66.57 per sec.) read/write requests: 18713 (1245.70 per sec.) other operations: 2048 (136.33 per sec.) ignored errors: 48 (3.20 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 15.0221s total number of events: 1000 total time taken by event execution: 120.0007s response time: min: 13.62ms avg: 120.00ms max: 448.10ms approx. 95 percentile: 229.29ms Threads fairness: events (avg/stddev): 125.0000/4.90 execution time (avg/stddev): 15.0001/0.02 [1]+ Done sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run & [1] 30556 [smilivoj@local mysql-5.7.13]$ sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Random number generator seed is 0 and will be ignored Initializing worker threads... Threads started! [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=0"[smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=1OLTP test statistics: queries performed: read: 14924 write: 4077 other: 2066 total: 21067 transactions: 1000 (63.55 per sec.) read/write requests: 19001 (1207.55 per sec.) other operations: 2066 (131.30 per sec.) ignored errors: 66 (4.19 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 15.7351s total number of events: 1000 total time taken by event execution: 125.7875s response time: min: 27.29ms avg: 125.79ms max: 427.07ms approx. 95 percentile: 250.01ms Threads fairness: events (avg/stddev): 125.0000/2.74 execution time (avg/stddev): 15.7234/0.01 " [1]+ Done sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run [smilivoj@local mysql-5.7.13]$ lsof -p 19862 | grep slow mysqld 19862 smilivoj 19u REG 0,38 35 91842720 /home/smilivoj/data/mysql/slow_log.CSM (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 20r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 21r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 22r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 23w REG 0,38 486 105111729 /home/smilivoj/data/hod05-slow.log (trostor01.no.oracle.com:/export/home/smilivoj) [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run & [1] 30572 [smilivoj@local mysql-5.7.13]$ sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Random number generator seed is 0 and will be ignored Initializing worker threads... Threads started! [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=0" [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=1" [smilivoj@local mysql-5.7.13]$ OLTP test statistics: queries performed: read: 14868 write: 4068 other: 2062 total: 20998 transactions: 1000 (61.69 per sec.) read/write requests: 18936 (1168.08 per sec.) other operations: 2062 (127.20 per sec.) ignored errors: 62 (3.82 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 16.2112s total number of events: 1000 total time taken by event execution: 129.4297s response time: min: 13.42ms avg: 129.43ms max: 403.34ms approx. 95 percentile: 247.62ms Threads fairness: events (avg/stddev): 125.0000/2.78 execution time (avg/stddev): 16.1787/0.03 [smilivoj@local mysql-5.7.13]$ lsof -p 19862 | grep slow mysqld 19862 smilivoj 19u REG 0,38 35 91842720 /home/smilivoj/data/mysql/slow_log.CSM (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 20r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 21r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 22r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 31r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 32w REG 0,38 648 105111729 /home/smilivoj/data/hod05-slow.log (trostor01.no.oracle.com:/export/home/smilivoj) [1]+ Done sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run [smilivoj@local mysql-5.7.13]$ sysbench --test=/home/smilivoj/sysbench/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp_table_size=1000 --oltp_tables_count=1 --mysql-host=127.0.0.1 --num-threads=8 --max-requests=1000 run & [1] 30592 [smilivoj@local mysql-5.7.13]$ sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Random number generator seed is 0 and will be ignored Initializing worker threads... Threads started! ./client/mysql -e "set global slow_query_log=0" [smilivoj@local mysql-5.7.13]$ ./client/mysql -e "set global slow_query_log=1" [smilivoj@local mysql-5.7.13]$ lsof -p 19862 | grep slow mysqld 19862 smilivoj 19u REG 0,38 35 91842720 /home/smilivoj/data/mysql/slow_log.CSM (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 20r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 21r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 22r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 31r REG 0,38 0 91842721 /home/smilivoj/data/mysql/slow_log.CSV (trostor01.no.oracle.com:/export/home/smilivoj) mysqld 19862 smilivoj 32w REG 0,38 810 105111729 /home/smilivoj/data/hod05-slow.log (trostor01.no.oracle.com:/export/home/smilivoj) [smilivoj@local mysql-5.7.13]$ OLTP test statistics: queries performed: read: 14588 write: 4048 other: 2042 total: 20678 transactions: 1000 (64.37 per sec.) read/write requests: 18636 (1199.54 per sec.) other operations: 2042 (131.44 per sec.) ignored errors: 42 (2.70 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 15.5360s total number of events: 1000 total time taken by event execution: 124.1750s response time: min: 11.51ms avg: 124.18ms max: 353.44ms approx. 95 percentile: 255.68ms Threads fairness: events (avg/stddev): 125.0000/4.53 execution time (avg/stddev): 15.5219/0.02