// 5.6.30 rm -rf 79533 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/79533 bin/mysqld --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/79533 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-advanced-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: 40024 write: 40024 other: 20012 total: 100060 transactions: 10006 (8514.53 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 80048 (68116.24 per sec.) other operations: 20012 (17029.06 per sec.) General statistics: total time: 1.1752s total number of events: 10006 total time taken by event execution: 116.4839s response time: min: 1.94ms avg: 11.64ms max: 137.40ms approx. 95 percentile: 25.36ms Threads fairness: events (avg/stddev): 100.0600/5.17 execution time (avg/stddev): 1.1648/0.01 [umshastr@hod03]~/bugs/sysbench: -- MySQL CLI session [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-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-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) 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 | 6 | SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? | | 7519b14a899fd514365211a895f5e833 | test | 6 | BEGIN | | 91345c471a98e64dfb78078f91a7f075 | test | 4 | SELECT DISTINCTROW `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? ORDER BY `c` | | b7ea03061313c92048b20444b9b4c5b1 | test | 5 | SELECT SUM ( `K` ) FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? | +----------------------------------+-------------+----------+------------------------------------------------------------------------------------+ 4 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: 10001 SUM_TIMER_WAIT: 16953013738000 MIN_TIMER_WAIT: 142044000 AVG_TIMER_WAIT: 1695131000 MAX_TIMER_WAIT: 83103703000 SUM_LOCK_TIME: 720698000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 999700 SUM_ROWS_EXAMINED: 999900 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: 9981 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:56 *************************** 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:55 *************************** 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:55 *************************** 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:55 *************************** 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:55 *************************** 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-10 09:04:55 LAST_SEEN: 2016-05-10 09:04:55 6 rows in set (0.00 sec) mysql>