Home > Article > Operation and Maintenance > Where are the MySQL logs in Linux?
Where are the MySQL logs in Linux?
The MySQL logs in Linux are generally saved in the /var/log/ directory , but you need to look at the specific configuration file to determine. The specific method is as follows:
1. First log in to mysql:
>mysql -u root -p
2. Then check whether it is enabled. Log (recommended learning: Linux video tutorial)
mysql>show variables like 'log_%';
3. View the current log
mysql> show master status;
4. The mysql log type you need to know:
Error log: -log-err
Query log: -log
Slow query log: -log-slow-queries
Update log: - log-update
Binary log: -log-bin
5. Modify the configuration/etc/my.cnf (the following is the log file storage location)
[mysqld] log=/var/log/mysqld_common.log log-error=/var/log/mysqld_err.log log-bin=/var/log/mysqld_bin.bin
For more Linux operation and maintenance related tutorials, please pay attention to PHP中文网!
The above is the detailed content of Where are the MySQL logs in Linux?. For more information, please follow other related articles on the PHP Chinese website!