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 resources: mysqld is pegged at 96% CPU
> utilisation, and I'm getting 'running out of connections' errors.
>
> 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.
I use mytop:
http://public.yahoo.com/~jzawodn/mytop/
Of course, I wrote it, so I'm biased. :-)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 116 days, processed 717,556,262 queries (71/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php