MySQL Bugs: #72219: Add first and last connection timestamps to P

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:	None
Category:	MySQL Server: Performance Schema	Severity:	S4 (Feature request)
Version:	5.6+	OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any

Description:
Continued from here: 
http://bugs.mysql.com/bug.php?id=72218

I propose columns added to this table
1) `HOST`
2) `FIRST_CONNECT`
3) `LAST_CONNECT`

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

Thank you for the reasonable feature request.

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:

http://dev.mysql.com/doc/refman/5.6/en/accounts-table.html

http://dev.mysql.com/doc/refman/5.6/en/hosts-table.html

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 ..).