SHOW PROCESSLIST not showing all users?

MySQL & MariaDB Other MySQL® Questions
1

I’m trying to troubleshoot our mysql server, which keeps maxing out its connections. However, I can’t get a full processlist for all users.

I’m logged in as root, and elsewhere as a client that has “process_priv” granted, but when I run “show processlist” I only see the list for the current user.

Am I missing something? All my reads of the documentation [URL=“MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.29 SHOW PROCESSLIST Statement”] http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html[/URL] suggest that I ought to be able to see every process.

2

actually, I was wrong.

I was getting “too many connections” errors and then seeing only a tiny handful of processes, but I think the problem lies elsewhere.