handler_savepoint_rollback should be DERIVE type

Bug #1334173 reported by Kenny Gryp
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Monitoring Plugins
Fix Released
Medium
Unassigned

Bug Description

Handler_savepoint_rollback currently is a GAUGE type, this is not true and should be a DERIVE, just like all other Handler_* stats.

See attached patch.

Revision history for this message
Kenny Gryp (gryp) wrote :
Revision history for this message
Roman Vynar (roman-vynar) wrote :

mysql> show global status like 'Handler_savepoint%';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (1);
Query OK, 1 row affected (0.01 sec)

mysql> savepoint aaa;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (1);
Query OK, 1 row affected (0.00 sec)

mysql> rollback to savepoint aaa;
Query OK, 0 rows affected (0.00 sec)

mysql> show global status like 'Handler_savepoint%';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| Handler_savepoint | 1 |
| Handler_savepoint_rollback | 1 |
+----------------------------+-------+
2 rows in set (0.00 sec)

Yeah, Handler_savepoint_rollback is constantly increasing counter and should be DERIVE.

Changed in percona-monitoring-plugins:
importance: Undecided → Medium
status: New → Fix Committed
milestone: none → 1.1.4
Changed in percona-monitoring-plugins:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.