Current time: 04-15-2014, 09:13 PM Hello There, Guest! (LoginRegister)

Post Reply 
Viewing processes from all users on MySQL PS
02-28-2012, 12:16 PM (This post was last modified: 02-28-2012 12:58 PM by jon-).)
Post: #1
Viewing processes from all users on MySQL PS
Hi, I'm trying to analyse performance on MySQL PS.

I've got around six user accounts that read/write data and another account that I use to 'admin' the MySQL server (which has permissions to create/drop objects etc).

What I'd like to be able to do is run SHOW PROCESSLIST and see activity across ALL account on my MySQL PS (and not just the account I happen to be logged in as while I run that command).

It's really difficult to troubleshoot issues when you can't see what other users are doing. Basically, what I need is my 'admin' account to have the PROCESS privilege, but this isn't listed as an option on the DreamHost MySQL Users page.

Does anybody know a way around this?

(As a side note, a separate forum for DreamHost PS customers wouldn't be a bad idea.)
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Viewing processes from all users on MySQL PS - jon-) - 02-28-2012 12:16 PM

Forum Jump: