-- 5.7.12(also, confirmed on 5.7.9) sysbench/sysbench --test=--test=sysbench/tests/db/oltp.lua --oltp-table-size=500000 --max-time=0 --oltp-read-only=off --max-requests=0 --num-threads=64 --rand-type=pareto --db-driver=mysql mysql-socket=/tmp/mysql_ushastry.sock --mysql-db=test prepare sysbench/sysbench --test=--test=sysbench/tests/db/oltp.lua --oltp-table-size=500000 --max-time=0 --oltp-read-only=off --max-requests=0 --num-threads=64 --rand-type=pareto --db-driver=mysql mysql-socket=/tmp/mysql_ushastry.sock --mysql-db=test run set global innodb_monitor_disable='%'; set global innodb_monitor_reset_all='%'; -- set global innodb_monitor_enable='trx_active_transactions'; set global innodb_monitor_enable='%'; mysql> select name,count from innodb_metrics where name like "trx_%"; +---------------------------+--------+ | name | count | +---------------------------+--------+ | trx_rw_commits | 243121 | | trx_ro_commits | 45 | | trx_nl_ro_commits | 0 | | trx_commits_insert_update | 210901 | | trx_rollbacks | 84133 | | trx_rollbacks_savepoint | 0 | | trx_rollback_active | 0 | | trx_active_transactions | -10851 | | trx_rseg_history_len | 524 | | trx_undo_slots_used | 0 | | trx_undo_slots_cached | -75 | | trx_rseg_current_size | 259 | +---------------------------+--------+ 12 rows in set (0.00 sec) mysql> select * from innodb_metrics where name='trx_active_transactions' \G *************************** 1. row *************************** NAME: trx_active_transactions SUBSYSTEM: transaction COUNT: -10997 MAX_COUNT: 62 MIN_COUNT: -11011 AVG_COUNT: -186.38983050847457 COUNT_RESET: -10997 MAX_COUNT_RESET: 62 MIN_COUNT_RESET: -11011 AVG_COUNT_RESET: NULL TIME_ENABLED: 2016-04-18 07:38:55 TIME_DISABLED: NULL TIME_ELAPSED: 59 TIME_RESET: NULL STATUS: enabled TYPE: counter COMMENT: Number of active transactions 1 row in set (0.00 sec) -- 5.6.30 mysql> select * from innodb_metrics where name='trx_active_transactions' \G *************************** 1. row *************************** NAME: trx_active_transactions SUBSYSTEM: transaction COUNT: -55 MAX_COUNT: 62 MIN_COUNT: -110 AVG_COUNT: -0.25 COUNT_RESET: -55 MAX_COUNT_RESET: 62 MIN_COUNT_RESET: -110 AVG_COUNT_RESET: NULL TIME_ENABLED: 2016-04-18 07:54:09 TIME_DISABLED: NULL TIME_ELAPSED: 220 TIME_RESET: NULL STATUS: enabled TYPE: counter COMMENT: Number of active transactions 1 row in set (0.00 sec) mysql> select name,count from innodb_metrics where name like "trx_%"; +---------------------------+--------+ | name | count | +---------------------------+--------+ | trx_rw_commits | 672258 | | trx_ro_commits | 0 | | trx_nl_ro_commits | 0 | | trx_commits_insert_update | 672238 | | trx_rollbacks | 11007 | | trx_rollbacks_savepoint | 0 | | trx_rollback_active | 0 | | trx_active_transactions | -60 | | trx_rseg_history_len | 377 | | trx_undo_slots_used | 167 | | trx_undo_slots_cached | 662 | | trx_rseg_current_size | 318 | +---------------------------+--------+ 12 rows in set (0.00 sec) -- 5.7.13 daily build [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.13: cat docs/INFO_SRC commit: 2c8714cecfc36e9eb329fd390efa3578f22ea9cb date: 2016-04-15 08:43:00 +0200 build-date: 2016-04-15 09:51:01 +0200 short: 2c8714c branch: mysql-5.7 MySQL source 5.7.13 mysql> select name,count from innodb_metrics where name like "trx_%"; +---------------------------+-------+ | name | count | +---------------------------+-------+ | trx_rw_commits | 49179 | | trx_ro_commits | 0 | | trx_nl_ro_commits | 0 | | trx_commits_insert_update | 42696 | | trx_rollbacks | 16794 | | trx_rollbacks_savepoint | 0 | | trx_rollback_active | 0 | | trx_active_transactions | -505 | | trx_rseg_history_len | 304 | | trx_undo_slots_used | 77 | | trx_undo_slots_cached | 56 | | trx_rseg_current_size | 261 | +---------------------------+-------+ 12 rows in set (0.01 sec) mysql> select * from innodb_metrics where name='trx_active_transactions' \G *************************** 1. row *************************** NAME: trx_active_transactions SUBSYSTEM: transaction COUNT: -684 MAX_COUNT: 62 MIN_COUNT: -699 AVG_COUNT: -13.68 COUNT_RESET: -684 MAX_COUNT_RESET: 62 MIN_COUNT_RESET: -699 AVG_COUNT_RESET: NULL TIME_ENABLED: 2016-04-18 08:19:52 TIME_DISABLED: NULL TIME_ELAPSED: 50 TIME_RESET: NULL STATUS: enabled TYPE: counter COMMENT: Number of active transactions 1 row in set (0.00 sec) -- 5.8.0 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: cat docs/INFO_SRC commit: 8a9545fc3bf8322c90bf31f64d451dc56fc418d5 date: 2016-04-15 23:06:33 -0500 build-date: 2016-04-16 17:03:32 +0200 short: 8a9545f branch: mysql-trunk MySQL source 5.8.0 mysql> select name,count from innodb_metrics where name like "trx_%"; +---------------------------+---------+ | name | count | +---------------------------+---------+ | trx_rw_commits | 1209201 | | trx_ro_commits | 0 | | trx_nl_ro_commits | 1 | | trx_commits_insert_update | 1050202 | | trx_rollbacks | 414643 | | trx_rollbacks_savepoint | 0 | | trx_rollback_active | 0 | | trx_active_transactions | -13368 | | trx_rseg_history_len | 844 | | trx_undo_slots_used | 1 | | trx_undo_slots_cached | -1393 | | trx_rseg_current_size | 285 | +---------------------------+---------+ 12 rows in set (0.00 sec) mysql> select * from innodb_metrics where name='trx_active_transactions' \G *************************** 1. row *************************** NAME: trx_active_transactions SUBSYSTEM: transaction COUNT: -13440 MAX_COUNT: 64 MIN_COUNT: -13449 AVG_COUNT: -48.51985559566787 COUNT_RESET: -13440 MAX_COUNT_RESET: 64 MIN_COUNT_RESET: -13449 AVG_COUNT_RESET: NULL TIME_ENABLED: 2016-04-18 08:24:50 TIME_DISABLED: NULL TIME_ELAPSED: 277 TIME_RESET: NULL STATUS: enabled TYPE: counter COMMENT: Number of active transactions 1 row in set (0.00 sec)