-- COmmunity build rm -rf 79533 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.30 --datadir=/export/umesh/server/binaries/mysql-5.6.30/79533 bin/mysqld --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.6.30 --datadir=/export/umesh/server/binaries/mysql-5.6.30/79533 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-5.6.30/79533/log.err 2>&1 & -- sysbench [umshastr@hod03]~/bugs/sysbench: bin/sysbench --debug=off --oltp-tables-count=1 --oltp-point-selects=0 --oltp-table-size=100000 --num-threads=100 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock --test=sysbench/tests/db/oltp.lua prepare sysbench 0.5: multi-threaded system evaluation benchmark Creating table 'sbtest1'... Inserting 100000 records into 'sbtest1' [umshastr@hod03]~/bugs/sysbench: bin/sysbench --debug=off --oltp-tables-count=1 --oltp-point-selects=0 --oltp-table-size=100000 --num-threads=100 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock --test=sysbench/tests/db/oltp.lua run sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 100 Random number generator seed is 0 and will be ignored Threads started! OLTP test statistics: queries performed: read: 40012 write: 40009 other: 20005 total: 100026 transactions: 10002 (8745.58 per sec.) deadlocks: 1 (0.87 per sec.) read/write requests: 80021 (69969.04 per sec.) other operations: 20005 (17492.04 per sec.) General statistics: total time: 1.1437s total number of events: 10002 total time taken by event execution: 113.4000s response time: min: 1.97ms avg: 11.34ms max: 121.99ms approx. 95 percentile: 24.37ms Threads fairness: events (avg/stddev): 100.0200/5.85 execution time (avg/stddev): 1.1340/0.01 -- MySQL CLI session [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.30: bin/mysql -uroot -S/tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.30 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use performance_schema Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select DIGEST, SCHEMA_NAME, COUNT(*), DIGEST_TEXT FROM events_statements_summary_by_digest group by DIGEST, SCHEMA_NAME HAVING COUNT(*) > 1; +----------------------------------+-------------+----------+-----------------------------------------------------------+ | DIGEST | SCHEMA_NAME | COUNT(*) | DIGEST_TEXT | +----------------------------------+-------------+----------+-----------------------------------------------------------+ | 1f552eec82470bfe60bf02de41096c2c | test | 9 | SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? | | 7519b14a899fd514365211a895f5e833 | test | 6 | BEGIN | +----------------------------------+-------------+----------+-----------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> select * from events_statements_summary_by_digest where digest ='1f552eec82470bfe60bf02de41096c2c'\G *************************** 1. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 9985 SUM_TIMER_WAIT: 16881678931000 MIN_TIMER_WAIT: 149650000 AVG_TIMER_WAIT: 1690703000 MAX_TIMER_WAIT: 82447786000 SUM_LOCK_TIME: 741394000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 998400 SUM_ROWS_EXAMINED: 998400 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 9977 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:27 *************************** 2. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 3. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 4. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 5. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 6. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 7. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 8. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 *************************** 9. row *************************** SCHEMA_NAME: test DIGEST: 1f552eec82470bfe60bf02de41096c2c DIGEST_TEXT: SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2016-05-19 08:11:25 LAST_SEEN: 2016-05-19 08:11:25 9 rows in set (0.00 sec) mysql>