Five common MySQL Log types

MySQL logs are the most common MySQL Log types. If you are interested in MySQL logs, take a look.

1. The error log records the problems that occur when you start, run, or stop mysqld.
My. ini configuration information:
# 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:
# 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:
# 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:
# 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:
# 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

Automatic Restoration of MySQL Log Files

Tips for compressing MySQL Data Files

MySQL database table Representation

Location of MySQL DATA DIRECTORY

How to change the MySQL Data File Path