mysql delete log

MySQL is a highly reliable database management system, but during use, you may encounter a situation where you cannot delete a large amount of data. This may be due to the fact that the log file recorded by MySQL takes up too much disk space. This article will introduce how to delete MySQL log files.

MySQL’s log files mainly have the following types:

1. Error log (error log)
2. Slow query log (slow query log)
3. Binary Log (binary log)
4. Relay log (relay log)
5. Transaction log (transaction log)

These log files are very important and can help us troubleshoot when problems occur. , but if they take up too much disk space, you need to delete some unnecessary log files.

1. Error log

The error log records any errors that occur during the startup process of the MySQL server. The error log file is often called the error log or log file, and its default location is the *.err file in the MySQL data directory. If you want to delete the error log manually, you can use the following command:

rm /var/lib/mysql/*.err

2. Slow Query Log

Slow Query Log records queries that perform slowly. The default location of the slow query log is the *.slow file in the MySQL data directory. If you want to manually delete the slow query log, you can use the following command:

rm /var/lib/mysql/*.slow

3. Binary log

The binary log contains all changes to the MySQL server. By default, the location of the binary log is in the MySQL data directory, and its file name is *.log. Use the following command to stop binary logging:

mysql> SET SQL_LOG_BIN = 0;

With this command, all write operations will no longer be logged to the binary log.

If you want to manually delete binary logs, you can first use the following command to view the created logs:

SHOW BINARY LOGS;

This command will display the names and sizes of all binary log files. You can then delete unnecessary log files using the following command:

PURGE BINARY LOGS TO 'mysql-bin.000003';

This will delete all old log files starting from the "mysql-bin.000003" file.

4. Relay log

The relay log is the log type used in MySQL master-slave replication (replication). Relay logs are usually stored in the MySQL data directory and their file names are *.relay-log. If you want to delete the relay log manually, you can use the following command:

rm /var/lib/mysql/*.relay-log

5. Transaction log

MySQL server uses the transaction log TM (tranasction log) to record committed transactions . TM log files are usually stored in the MySQL data directory and their file names are *.TM. If you want to manually delete the transaction log file, you can use the following command:

rm /var/lib/mysql/*.TM

Summary

When deleting the MySQL log file, make sure you have sufficient permissions and confirm whether the file is safe before deleting it delete. If you are unsure, back up the log file first or move it to another location. By deleting log files, you can free up disk space and improve database performance, but please be careful not to delete unnecessary log files as they may play an important role in troubleshooting and performance analysis.

The above is the detailed content of mysql delete log. For more information, please follow other related articles on the PHP Chinese website!