The actual operation steps and code for viewing MySQL operation logs

The following articles mainly describe the actual operation steps for viewing MySQL operation logs and the actual operation steps. If you encounter similar operations, however, you do not know how to solve the problem correctly, so the following articles must be good teachers and friends for you.

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=16M 
 
 

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.