Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs can help us locate the internal distribution of mysqld. like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs help us locate the internal events of mysqld, database performance faults, record the change history of data, and recover the database. This document describes error log files.
1. composition of the MySQL log file system
2. error log
3. Practical demonstration
# View the current error log configuration, which is located in the data directory by default
# Viewing the current mysql server error log file
# Stopping a mysql server
# Use the configuration file to set the log-error parameter
# Author: Leshami
# Modify my. cnf and delete the skip-opt option
# Start the mysql server again
The error log file format is as follows: