mysql query logging

Question

User64117442 posted

Hi,

I want to log all mysql query which are executive on mysql like sql profiler for mssql2005.

i worked in mssql mostly so i don`t have much idea about mysql.

i am able to log query which run on my local mysql server with adding following line in C:\wamp\mysql

log=c:/wamp/logs/mysql_querylog.log.

now i want to view this log into some editor.

is there any tool for view the log file.

Please help

Thanks in Advance

Pratik Asthana

Answer 1

User-837620913 posted

MySQL has a profiler as well.

Tutorial blog post:  http://www.trafexisblogging.com/2009/03/mysql-profiler/

Official documentation:  http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html

Answer 2

User64117442 posted

i am able to log query which run on my local mysql server with adding following line in C:\wamp\mysql

log=c:/wamp/logs/mysql_querylog.log.

restart mysql services to take effects