MySQL server question
 

I got a PHP script running, I wanna know what SQL commands it executes on a certain DB on the MySQL server to figure out that the algo its ranking the thumbs.

Any MySQL option to log every single SQL query?

yeaasssss

huh... KILLA KILLA THE DOPE MAKES TEH SKRILLA

not sure if this will do what you want, by the

mysqladmin extended-status

will show what's running in the mySQL environment.

actually, there's a bunch of options with "mysqladmin" from the command line to see what's going on at a certain point.

about automating it, i'd guess modify the PHP script and log what it's doing.

*shrug*

I wish, it's a paid script compiled in Zend Optimizer, etc.

add to mysql option :

--enable-logging

this will create hostname.log in your datadir with all mysql queries

yea, we have a couple of those fuckers bought for work and it sucks to debug.

you gotta love when a truly solid answer comes along.

Thanks :thumbsup