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