Enable mysql Logging in windows and linux

 

Check whether logs are enabled
Mysql> show variables like 'Log _ bin ';

How to know the current log

Mysql> show master status;

 

Display the number of binary logs

Mysql> show master logs;

Use mysqlbinlog to view binary log files
Shell> mysqlbinlog mail-bin.000001
Or shell> mysqlbinlog mail-bin.000001 | tail

Specify the log output location in the configuration file.
Windows: the configuration file for Windows is my. ini, which is usually in the MySQL installation directory or c: \ Windows.
Linux: the configuration file of Linux is my. cnf, which is usually in/etc.

Overview of log file types:

 

In [mysqld ],

 

Log-error =/usr/local/mysql/log/error. log
Log =/usr/local/mysql/log/mysql. log
Long_query_time = 2
Log-slow-queries =/usr/local/mysql/log/slowquery. log

 

SQL code

 

In [mysqld ],

 

# Startup log
Log = "E:/wamp/MySql/mysql_log/mysql. log"
# Error logs
Log-error = "E:/wamp/MySql/mysql_log/mysql. logerror. log"
# It indicates how long the SQL statement will be logged down after execution, which is 2 seconds
Long_query_time = 2
# Slow query logs
Log-slow-queries = "E:/wamp/MySql/mysql_log/slowquery. log"

 

Long_query_time = 2 -- indicates how long the SQL statement will be logged after execution. Here, it is 2 seconds.

 

Log-slow-queries =/usr/local/mysql/log/slowquery. 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

 

 

 As for the accurate understanding of log files, you still need to read them carefully.