MySQL Bugs: #71305: PERFORMANCE_SCHEMA.THREADS table, add a PORT column

Bug #71305	PERFORMANCE_SCHEMA.THREADS table, add a PORT column
Submitted:	6 Jan 2014 9:04	Modified:	6 Jan 2014 9:05
Reporter:	Marc ALFF	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:

See related bug#71289
PERFORMANCE_SCHEMA.THREADS table misses port in PROCESSLIST_HOST column

This is a feature request: add a PORT column in table
performance_schema.threads.

This is an ease of use improvement, one should not *have* to instrument network io (and instrument every network io operation) *only* to get a port number, even when available in table socket_instances.

Consider also adding an IP column, for the client IP address

How to repeat:
N/A

Suggested fix:
As described