Check whether logs are enabled
Copy codeThe Code is as follows:
Mysql> show variables like 'Log _ bin ';
How to know the current log
Copy codeThe Code is as follows:
Mysql> show master status;
Display the number of binary logs
Copy codeThe Code is as follows:
Mysql> show master logs;
Use mysqlbinlog to view binary log files
Copy codeThe Code is as follows:
Shell> mysqlbinlog mail-bin.000001
Or
Copy codeThe Code is as follows:
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:
1. The error log records the problems that occur when you start, run, or stop mysqld.
My. ini configuration information:
Copy codeThe Code is as follows:
# Enter a name for the error log file. Otherwise a default name will be used.
# Log-error = d:/mysql_log_err.txt
2. query the Client Connection established by log records and the statements executed.
My. ini configuration information:
Copy codeThe Code is as follows:
# Enter a name for the query log file. Otherwise a default name will be used.
# Log = d:/mysql_log.txt
3. Statement for updating log records and changing data. This log is not supported.
My. ini configuration information:
Copy codeThe Code is as follows:
# Enter a name for the update log file. Otherwise a default name will be used.
# Log-update = d:/mysql_log_update.txt
4. Binary logs record all statements for changing data. It is also used for replication.
My. ini configuration information:
Copy codeThe Code is as follows:
# Enter a name for the binary log. Otherwise a default name will be used.
# Log-bin = d:/mysql_log_bin
5. Slow logs record all queries whose execution time exceeds long_query_time seconds or where no index is used.
My. ini configuration information:
Copy codeThe Code is as follows:
# Enter a name for the slow query log file. Otherwise a default name will be used.
# Long_query_time = 1
# Log-slow-queries = d:/mysql_log_slow.txt
In linux:
In [mysqld ],
Copy codeThe Code is as follows:
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
Windows
In [mysqld ],
Copy codeThe Code is as follows:
# 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