-- Conf file used from Zhai's environment bin/mysqld --defaults-file=./82213.cnf --initialize-insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.13 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.13/data bin/mysqld --defaults-file=./82213.cnf & sysbench/sysbench --test=sysbench/tests/db/oltp.lua --oltp-table-size=50000000 --mysql-table-engine=innodb --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock prepare sysbench/sysbench --test=sysbench/tests/db/oltp.lua --oltp-table-size=50000000 --oltp-test-mode=complex --oltp-read-only=off --num-threads=16 --max-requests=0 --report-interval=10 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock run bin/mysql -uroot -S /tmp/mysql.sock -e 'show engine innodb status\G' | awk ' BEGIN { } /Log sequence number/ {st=$4 } /Last checkpoint at/ { ed=$4; print (st-ed)/1024/1024 } ' -- Session 1 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.13: bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.13-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 test Database changed mysql> set global innodb_max_undo_log_size = 104857600; Query OK, 0 rows affected (0.00 sec) mysql> set global innodb_undo_log_truncate = ON; Query OK, 0 rows affected (0.00 sec) mysql> set session tx_isolation = 'REPEATABLE-READ'; Query OK, 0 rows affected (0.00 sec) -- Goto sysbench session, and make prepare is done before proceeding below steps mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select * from sbtest1 limit 1; -- keep the read view open +----+----------+-------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+ | id | k | c | pad | +----+----------+-------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+ | 1 | 24956885 | 08566691963-88624912351-16662227201-46648573979-64646226163-77505759394-75470094713-41097360717-15161106334-50535565977 | 63188288836-92351140030-06390587585-66802097351-49282961843 | +----+----------+-------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+ 1 row in set (0.00 sec) -- committed when History list length 6118853 mysql> commit; Query OK, 0 rows affected (0.00 sec) mysql> -- Session 2 - Run sysbench - prepare [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --test=sysbench/tests/db/oltp.lua --oltp-table-size=50000000 --mysql-table-engine=innodb --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock prepare - run [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --test=sysbench/tests/db/oltp.lua --oltp-table-size=50000000 --oltp-test-mode=complex --oltp-read-only=off --num-threads=16 --max-requests=0 --report-interval=10 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock run -- Session 3 - monitor history length [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.13: bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.13-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> pager grep History PAGER set to 'grep History' mysql> show engine innodb status\G History list length 24 1 row in set (0.00 sec) mysql> mysql> show engine innodb status\G History list length 24 1 row in set (0.00 sec) mysql> mysql> show engine innodb status\G History list length 64 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 70 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 25840 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 44471 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 55997 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 104327 1 row in set (0.01 sec) mysql> show engine innodb status\G History list length 1116088 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 1239331 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 1709331 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 2928015 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 3616052 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 3845545 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 3853050 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 6385943 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 6480877 1 row in set (0.00 sec) mysql> show engine innodb status\G History list length 6118853 1 row in set (0.00 sec) -- Goto sysbench session and kill the 'run' step mysql> -- Session 4 - monitor error log [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.13: tail -f log/alert.log 2016-07-14T12:35:10.604121Z 20 [Note] Aborted connection 20 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2016-07-14T12:35:10.604084Z 6 [Note] Aborted connection 6 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2016-07-14T12:35:10.604122Z 21 [Note] Aborted connection 21 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2016-07-14T12:35:10.604135Z 12 [Note] Aborted connection 12 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2016-07-14T12:35:10.604088Z 18 [Note] Aborted connection 18 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2016-07-14T12:35:52.129916Z 0 [Warning] InnoDB: Purge reached the head of the history list, but its length is still reported as 4986877! Make a detailed bug report, and submit it to http://bugs.mysql.com 2016-07-14T12:35:52.130144Z 0 [Warning] InnoDB: Purge reached the head of the history list, but its length is still reported as 4986877! Make a detailed bug report, and submit it to http://bugs.mysql.com 2016-07-14T12:35:52.130213Z 0 [Warning] InnoDB: Purge reached the head of the history list, but its length is still reported as 4986877! Make a detailed bug report, and submit it to http://bugs.mysql.com 2016-07-14T12:35:52.139922Z 0 [Warning] InnoDB: Purge reached the head of the history list, but its length is still reported as 4986590! Make a detailed bug report, and submit it to http://bugs.mysql.com 2016-07-14T12:35:52.139951Z 0 [Warning] InnoDB: Purge reached the head of the history list, but its length is still reported as 4986590! Make a detailed bug report, and submit it to http://bugs.mysql.com