MySQL server question

[fireorange]

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?

[sixxxthsense]

yeaasssss

[sickbeatz]

huh... KILLA KILLA THE DOPE MAKES TEH SKRILLA

[psili]

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*

[fireorange]

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

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

[zagi]

add to mysql option :

--enable-logging

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

[psili]

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

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

add to mysql option :

--enable-logging

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

you gotta love when a truly solid answer comes along.

[fireorange]

add to mysql option :

--enable-logging

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

Thanks