sluggish site, hoping to view query log?

[sneakyimp]

I'm working on a site which is a bit sluggish. We think it's the db so we're hoping to add some indexes.

Rather than reading all the PHP and trying to reconstruct what queries are running, I was hoping to find a tool which would let me see what queries are running. I've looked at http://dev.mysql.com/downloads/gui-tools/5.0.html]MySQL GUI Tools and MySQL Administrator does have a server logs function but it only lets you view these when connecting to localhost.

I was wondering if anyone could recommend a tool that would allow me to get a peek at what queries are running on a remote server without digging into the PHP. It would also be good to have some idea of what permissions might be necessary to view the query logs. I don't have SSH access to this server. I reckon whatever permissions I get will have to be assigned using MySQL.

[johanafm]

If it is at all possible for you to get this information in any way, I'd recommend turning on the slow query log.

Else, you are stuck with PHP as far as I know. However, if you are using a class to handle all queries, setting up a logging function in php is quite easy. No need to go over all the code. You just change what happens in a call to DB::query();

If not, I'd create such a class and then go over all code and make sure that all queries pass through the new class. And it also has other benefits. You will only need to deal with error logging in one single place. If you're not using mysqli today, now's a good time to switch (and to using prepared statements). And if that's not an option presently, when you do have this possibility, you change the code once, not everywhere.

[sneakyimp]

Thanks for the advice. I'm familiar with the class technique. This code doesn't use a class but does funnel all the queries through a single function. I was rather hoping there was some other way.