SHOW PROCESSLIST shows the list of processes for the current user and session only.
Is there a way for the current user to list all their processes for all currently opened sessions?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Obtain this info from
information_schema.PROCESSLIST. If your user have
PROCESS privilege, and you need to view only your processes - use
WHERE user = USER() filter.