I'm trying to find a count/list of all user connections to both the reader and writer instance. I understand that show full processlist; will give me a list of connected users, but it won't show me what host a user is connected to.
I would love to do this with a SQL statement if it's possible.
Any help is appreciated.
I think
information_schema.PROCESSLIST
contains the information.This table has
HOST
column, it should have client IP address.