Where is the MySQL log in Linux-linux operation and maintenance

1. First log in to mysql:

>mysql  -u root -p

2. Then check whether the log is enabled (recommended learning: Linux video tutorial)

mysql>show variables  like & # 39; log_% & # 39;;

3. View the current log

mysql> show master status;

4. The log type of mysql 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 Chinese website!

The above is the detailed content of where is the MySQL log in Linux, please pay attention to other related articles on 1024programmer.com for more information!