SHOW PROCESSLIST not showing all users?

  • Filter
  • Time
  • Show
Clear All
new posts

  • SHOW PROCESSLIST not showing all users?

    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.

  • #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.