Bug #77888 max_used_connection per user/account missing in P_S/sys
Submitted: 30 Jul 2015 15:19 Modified: 31 Jul 2015 8:59
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Performance Schema Severity:S4 (Feature request)
Version:n.a. OS:Any (n.a.)
Assigned to: Marc Alff CPU Architecture:Any
Tags: account, max_used_connection, P_S, performance_schema, sys, user

[30 Jul 2015 15:19] Oli Sennhauser
I was looking for max_used_connections (high water mark) but on a per user/account basis.

I could not find anything related in the P_S/sys schema but only found current/total_connections per user/account.

Would it make sense to have those values in the P_S? We can set it in the mysql.user table. So I would expect to see the outcome somewhere in the P_S...

Scenario: Customers application user went amok and made max_connections full. But he does not know which one... :-)

How to repeat:

Suggested fix:
SELECT user, host, max_used_connections FROM performance_schema.accounts;