Shulou(Shulou.com)06/01 Report--

This article mainly introduces the case of deleting the mysql error log, the article is very detailed, has a certain reference value, interested friends must read it!

The way to delete the mysql error log: first use the "mysqladmin-uroot-p flush-logs" command to open a new error log, which will automatically rename the old error log to "filename.err-old"; then delete these ".err-old" files.

Error log (Error Log) is one of the most commonly used logs in MySQL, which mainly records the information in the process of starting and stopping the MySQL server, the failures and anomalies occurred during the operation of the server, and so on.

Delete error log

In MySQL, you can use the mysqladmin command to open a new error log to ensure hard disk space on the MySQL server. The syntax of the mysqladmin command is:

Mysqladmin-uroot-p flush-logs

After executing this command, the MySQL server first automatically creates a new error log and then renames the old error log to filename.err-old.

When an exception occurs in the MySQL server, the administrator can find the time and cause of the exception in the error log, and then solve the exception according to this information. For error logs from a long time ago, it is unlikely to view them, and you can delete them directly.

The above is all the contents of the case of deleting the mysql error log, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.