MySQL Performance: MySQL => SHOW PROCESSLIST not showing all users?

Members

Help

Home

Home » Performance » MySQL » SHOW PROCESSLIST not showing all users?

Show: Today's Messages :: Show Polls :: Message Navigator

SHOW PROCESSLIST not showing all users? [message #3707]

Mon, 10 November 2008 14:34

amandabee
Messages: 4
Registered: November 2008
Location: New York, NY

Junior Member

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.

Report message to a moderator

Re: SHOW PROCESSLIST not showing all users? [message #3757 is a reply to message #3707 ]

Wed, 03 December 2008 18:34

amandabee
Messages: 4
Registered: November 2008
Location: New York, NY

Junior Member

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.

Report message to a moderator

Previous Topic:	mysql lost connection error
Next Topic:	New to MySQL -- convert MSSQL to MySQL syntax

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 22:29:00 EDT 2009

Total time taken to generate the page: 0.02514 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.