SHOW PROCESSLIST: show processes from all sessions
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.

Link