General Query Log per database

[rykos]

I've been trying to find out if it's possible to enable the general query log for a single database rather than the entire DBMS. So far I've turned up no results and was wondering if anyone here might have some insight into this.

Again, what I'd like to do is monitor all queries executed against a single database on the server. I'd like to do this without having to write a logging system in PHP to capture all the queries (I'm not the author of the scripts and would not want to mess around with them).

Thanks in advance for any advice or comments.

[bradgrafelman]

Are we talking about MySQL? Assuming we are...

rykos wrote:

I've been trying to find out if it's possible to enable the general query log for a single database rather than the entire DBMS.

Well, if such a configuration/filter did exist, I would be highly surprised if it wasn't well documented in the MySQL manual.

Unfortunately, reading over the manual, it doesn't sound like such a feature/configuration exists - it's either all or nothing.

[rykos]

Yes, I was talking about MySQL.

That's what I was afraid of. Thanks for the response!