SQL statements tracked and executed by mysql (favorites)

How does one track SQL in SQL server by using an event probe? In fact, the method is very simple. Enable the mysql log function and view the tracking log. How to enable mysql log: how to configure mysql in windows: Version: 5.0.37-community-nt-log (MySQLCommunityEdition (GPL )) find my tracking SQL under SQL SERVER using the event probe, and how to track SQL under mysql?

In fact, the method is very simple. Enable the mysql log function and view the tracking log.

How to enable mysql log:

Configuration method in windows:

My Version: 5.0.37-community-nt-log (MySQL Community Edition (GPL ))

Find my. ini in the "G: \ Program Files (x86) \ MySQL Server 5.0" directory,

Find [mysqld] and add it below:

Log = path for storing logs/my. log

My configuration values:

After modification, restart the mysql service.

Updated on February 1

If you are using the Spring + Spring MVC + MyBatis framework, during the development and debugging phase,

For details, refer to: MyBatis3. Use log4j to output SQL statements on the console.