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

Editor to share with you where the location of the mysql log file, I hope you will learn a lot after reading this article, let's discuss it together!

Find the error log file path

Show variables like 'log_error'

In mysql databases, error logging is enabled by default. Also, the error log cannot be disabled. By default, the error log is stored in a data file in the mysql database. The name of the error log file is usually hostname.err. Where hostname represents the server hostname.

The error log information can be configured by itself, and the information recorded in the error log can be defined through log-error and log-warnings, where log-err defines whether the error log is enabled and where the error log is stored, and log-warnings defines whether warning information is also defined in the error log.

By default, the error log records the following information: information during server startup and shutdown (not necessarily error messages, such as how mysql starts InnoDB's tablespace file, how to initialize its own storage engine, etc.), error messages while the server is running, information generated when the event scheduler runs an event, and information generated when starting the server process from the server.

Find the log file path

Show variables like 'general_log_file'

Log is an important part of mysql database. The log file records the changes that occur during the operation of the mysql database; that is, it is used to record the client connection status of the mysql database, the execution of SQL statements, error messages, and so on. When the database is accidentally damaged, the cause of the file error can be seen through the log, and the data can be recovered through the log file.

Slow query log file path

Show variables like 'slow_query_log_file'

Slow query logs are used to record queries that have been executed for more than a specified time. Through the slow query log, you can find out which query statements are inefficient for optimization. It is generally recommended to turn it on, which has little impact on server performance, but can record queries that have been executed on the mysql server for a long time. That can help us locate performance problems.

After reading this article, I believe you have a certain understanding of the location of mysql log files, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.