Bug #72219 Add first and last connection timestamps to P_S.users table
Submitted: 3 Apr 2014 12:15 Modified: 13 Apr 2014 11:01
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Performance Schema Severity:S4 (Feature request)
Version:5.6+ OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[3 Apr 2014 12:15] Peter Laursen
Continued from here: 

I propose columns added to this table
1) `HOST`

1) because on a server where access from remote hosts happen, the user_part of the full username (user@host) is not very useful.
2) + 3) Because on servers with a high 'uptime' status variable value it would be nice to be able to see if a user connected recently or not. 

How to repeat:
see above

Suggested fix:
see above
[4 Apr 2014 19:09] Sveta Smirnova
Thank you for the reasonable feature request.
[7 Apr 2014 8:50] Marc ALFF
Adding FIRST_CONNECT / LAST_CONNECT columns or similar is a valid feature request.

As for adding a 'HOST' column in the performance_schema.users table,
please look at these tables instead:


[13 Apr 2014 11:01] Peter Laursen
OK .. then I propose to add it to the `accounts` table.

But then - as a sideremak - I really do not see any need of neither `hosts` nor `users` tables at all as the information in those can easily be aggregated from `accounts` (SELECT .. SUM ..).