// 5.7.12 rm -rf 79533 bin/mysqld --initialize-insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.12 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.12/79533 -v bin/mysqld --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.12 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.12/79533 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.12/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: 40684 write: 40231 other: 20178 total: 101093 transactions: 10007 (8187.28 per sec.) deadlocks: 164 (134.18 per sec.) read/write requests: 80915 (66201.04 per sec.) other operations: 20178 (16508.74 per sec.) General statistics: total time: 1.2223s total number of events: 10007 total time taken by event execution: 121.5537s response time: min: 1.58ms avg: 12.15ms max: 165.15ms approx. 95 percentile: 25.37ms Threads fairness: events (avg/stddev): 100.0700/17.58 execution time (avg/stddev): 1.2155/0.00 [umshastr@hod03]~/bugs/sysbench: -- MySQL CLI session [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.12: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.12-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> create database test; Query OK, 1 row affected (0.00 sec) 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; ERROR 1055 (42000): Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'performance_schema.events_statements_summary_by_digest.DIGEST_TEXT' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by mysql> set sql_mode=''; Query OK, 0 rows affected, 1 warning (0.00 sec) 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 | +----------------------------------+-------------+----------+-------------------------------------------------------------------+ | 3dc11c8c98e6e44ed2f765408a8b4ac2 | test | 4 | SELECT SUM ( `K` ) FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? | | 668813439a0f67600cfd3ed154271754 | test | 2 | INSERT INTO `sbtest1` ( `id` , `k` , `c` , `pad` ) VALUES (...) | | 67dcdcf330cc36c7222e5e899c9026a1 | test | 3 | SELECT `c` FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? | | 98bf18ef8a1606965a0f2ff85fa992a3 | test | 2 | COMMIT | | aa32559513ddef588f88b72e88d5eac0 | test | 2 | UPDATE `sbtest1` SET `k` = `k` + ? WHERE `id` = ? | | f57daa74a09445d1e1c496f28fe6d906 | test | 3 | BEGIN | +----------------------------------+-------------+----------+-------------------------------------------------------------------+ 6 rows in set (0.00 sec) mysql> select * from events_statements_summary_by_digest where digest = '3dc11c8c98e6e44ed2f765408a8b4ac2'\G *************************** 1. row *************************** SCHEMA_NAME: test DIGEST: 3dc11c8c98e6e44ed2f765408a8b4ac2 DIGEST_TEXT: SELECT SUM ( `K` ) FROM `sbtest1` WHERE `id` BETWEEN ? AND ? + ? COUNT_STAR: 10150 SUM_TIMER_WAIT: 14920499799000 MIN_TIMER_WAIT: 154509000 AVG_TIMER_WAIT: 1469999000 MAX_TIMER_WAIT: 84939528000 SUM_LOCK_TIME: 570099000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 10159 SUM_ROWS_EXAMINED: 1016100 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: 10151 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:20:44 LAST_SEEN: 2016-05-10 09:20:45 *************************** 2. row *************************** SCHEMA_NAME: test DIGEST: 3dc11c8c98e6e44ed2f765408a8b4ac2 DIGEST_TEXT: SELECT SUM ( `K` ) 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:20:44 LAST_SEEN: 2016-05-10 09:20:44 *************************** 3. row *************************** SCHEMA_NAME: test DIGEST: 3dc11c8c98e6e44ed2f765408a8b4ac2 DIGEST_TEXT: SELECT SUM ( `K` ) 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:20:44 LAST_SEEN: 2016-05-10 09:20:44 *************************** 4. row *************************** SCHEMA_NAME: test DIGEST: 3dc11c8c98e6e44ed2f765408a8b4ac2 DIGEST_TEXT: SELECT SUM ( `K` ) 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:20:44 LAST_SEEN: 2016-05-10 09:20:44 4 rows in set (0.00 sec) mysql>