MariaDB [(none)]> select id,user,host,memory_used from information_schema.processlist; +-------+-------------+----------------+-------------+ | id | user | host | memory_used | +-------+-------------+----------------+-------------+ | 16659 | root | localhost | 85048 | | 16585 | SOME_USER | SOME_IP:56387 | 67920 | | 16539 | SOME_USER | SOME_IP:56209 | 67920 | | 16538 | SOME_USER | SOME_IP:56208 | 67920 | | 16537 | SOME_USER | SOME_IP:56205 | 67920 | | 16536 | SOME_USER | SOME_IP:56206 | 67920 | | 16477 | SOME_USER | SOME_IP:55980 | 158032 | | 16476 | SOME_USER | SOME_IP:55979 | 416080 | | 16290 | SOME_USER | SOME_IP:55306 | 301392 | | 16099 | SOME_USER | SOME_IP:54627 | 383312 | | 16097 | SOME_USER | SOME_IP:54625 | 264528 | | 17 | SOME_USER | SOME_IP:55353 | 67920 | | 12 | SOME_USER | SOME_IP:55341 | 68184 | | 10 | SOME_USER | SOME_IP:55338 | 6400600 | | 9 | SOME_USER | SOME_IP:55337 | 84568 | | 5 | system user | | 24104 | | 4 | system user | | 24104 | | 3 | system user | | 24104 | | 2 | system user | | 24104 | | 1 | system user | | 24104 | +-------+-------------+----------------+-------------+ 20 rows in set (0.00 sec)