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 http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html suggest that I ought to be able to see every process.
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 http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html suggest that I ought to be able to see every process.
Comment