See all queries sent to MySQL

Send this query:

SET GLOBAL general_log = 'ON';

Then run tail:

tail -f /var/lib/mysql/hostname.log

where hostname is the hostname of the database server.

Of course, you can turn it off by:

SET GLOBAL general_log = 'OFF';

References


mysql

38 Words

2010-09-03 11:51 +0000