Re: mysql 'top' application

2001-04-29 Thread Jeremy Zawodny
On Fri, Apr 27, 2001 at 07:21:38PM -0700, Soren Ragsdale wrote: I purchase web space on www.phpwebhosting.com, which offers PHP and mySQL services in a shared server environment. Each user gets their own database, in which they can create their own tables. Today, someone is using a LOT of

mysql 'top' application

2001-04-28 Thread Soren Ragsdale
I purchase web space on www.phpwebhosting.com, which offers PHP and mySQL services in a shared server environment. Each user gets their own database, in which they can create their own tables. Today, someone is using a LOT of resources: mysqld is pegged at 96% CPU utilisation, and I'm getting

Re: mysql 'top' application

2001-04-28 Thread Jason Brooke
How can I tell which user on the system is responsible for the lag? Ideally there would be a command like 'top' that would show which databases are being accessed most frequently, or taking the most time to access. -