Tracking and monitoring SQL statements executed by MYSQL

I. windows: modify my. ini, add a log line under mysqld, [mysqld] logD: tmpmysql_logmysql_log. SQL, and then restart mysql to view the statement currently being executed by the myql server in real time. ====================== Monitor the SQL statements executed by mysql.

I. windows: modify my. ini, add a log line under mysqld, [mysqld] log = D:/tmp/mysql_log/mysql_log. SQL, and then restart mysql, you can see the statement currently being executed by the myql server in real time. ====================== Monitor the SQL statements executed by mysql.

Take windows as an example:

Modify my. ini and add a log row under mysqld,

[Mysqld]
Log = "D:/tmp/mysql_log/mysql_log. SQL"

Then, restart mysql to view the statements currently being executed by the mysql server in real time.

======================

Monitor the SQL statements executed by mysql to perform performance and function tests in concert with the development, so as to conveniently monitor the SQL statements being executed,

You can add the following in/etc/mysqld:
Log =/usr/local/mysql/var21005/mysql. log can be used: tail-f mysql. log to monitor www.2cto.com. If you need to monitor slow queries, you can add the following content:
Log-slow-queries =/usr/local/mysql/var21005/slowquery. loglong_query_time = 1