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 'r

comic strip SQL question: slow queries on left outer joins

2001-01-11 Thread Soren Ragsdale
Well, I run an online comic strip at http://www.monkeydyne.com/rmcs/ I've done so for three years now, and this is the first time I've been stumped enough to ask the mysql list for help. On the site, users can submit their own comics and they can vote on other people's comics. When a particular