Shortly after I first came into contact with MySQL, I found that many enterprise-level functions were missing. I wanted to view the SQL statements executed by MySQL in real time, similar to the event probe in MSSQL. I searched for them online, the operation can only be written to logs. The procedure is as follows:
Set the my. ini file. The MySQL installation environment is XP SP2, which is under c: \ windows \... open the file and modify it.
[Mysqld]
Basedir = E:/MySQL 4.0.12
# Bind-address = 192.168.15.196
Datadir = E:/MySQL 4.0.12/Data
# Language = E:/MySQL 4.0.12/share/your language directory
# Slow query log # = slowqueris. Log
# Tmpdir # =
# Port = 3306
# Set-variable = key_buffer = 16 m
Long_query_time = 1 -- indicates how long the SQL statement will be logged after execution. Here, it is 1 second.
Log-Slow-queries = slowqueris. log -- Records slow statements returned by the query.
Log-queries-not-using-indexes = nouseindex. log -- it is a literal meaning that the query with no index is used in the log.
Log = mylog. log -- Record all execution statements
When the preceding parameters are enabled, MySQL performance may be affected. We recommend that you disable them in the production environment.