Bug #71081 Need status variable for COM_RESET_CONNECTION

• Submitted: 4 Dec 2013 23:50
• Reporter: Todd Farmer (OCA)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.7.3
• OS: Any
• CPU Architecture: Any

[4 Dec 2013 23:50] Todd Farmer

Description:
Like COM_PING in Bug#51667, COM_RESET_CONNECTION needs its own counter in status variables.

Note that workaround is to use P_S, which has instrumented the "statement/com/Reset Connection" event:

mysql> SELECT SUM(count_star)
    -> FROM events_statements_summary_global_by_event_name
    -> WHERE event_name = 'statement/com/Reset Connection';
+-----------------+
| SUM(count_star) |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.00 sec)

How to repeat:
Issue SHOW GLOBAL STATUS LIKE 'Com%';  (not that Com_reset isn't the same thing).

Suggested fix:
Add Com_reset_connection status variables.