How to monitor MySQL queries

Say I browse a php page, how do I know what database queries are run? I think if I can log all the queries 开发者_StackOverflowto a .txt file that would solve my problem. I tried to log, but failed. I just want to know the queries (sql strings) sent to it.

I'm using WinXP and Apache.

One way to do it is going into your my.cnf configuration file and activate the general log. As hinted is a performance killer, so never activate it in production. For development is perfectly OK, though. On my laptop is on all the time.

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
general_log_file        = /var/log/mysql/mysql.log
general_log             = 1

Find your mysql log files directory - mine was:

C:\Program Files\MySQL\MySQL Server 5.0\data

Look for the last updated file. Should be NAME OF YOUR COMPUTER.log - that will be your default logfile ** - Mysql is generally shipped with basic logging enabled, IIRC.

Else, as has been said, set up logging in your cnf file and restart the Mysql service.

** Make yourself a shortcut to this file on your desktop, you should be looking at it often.

When the file gets too big, delete it and restart the Mysql service and it'll start a new one with the same name.

just copy and paste the string in mysql_query() into an echo just before the query.