Mysql基础知识-日志查看

日志位置配置：

my.cnf 文件

如下：

mysql> show variables like 'general_log_file';
+------------------+---------------------------------+
| Variable_name    | Value                           |
+------------------+---------------------------------+
| general_log_file | /var/lib/mysql/01d03e4c2a5e.log |
+------------------+---------------------------------+
1 row in set

mysql> show variables like 'log_error';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| log_error     | stderr |
+---------------+--------+
1 row in set
-----参考博文
mysql> show variables like 'log_error';
+---------------+--------------------------+
| Variable_name | Value                    |
+---------------+--------------------------+
| log_error     | /var/log/mysql/error.log |
+---------------+--------------------------+
1 row in set (0.01 sec)

mysql> show variables like 'slow_query_log_file';
+---------------------+--------------------------------------+
| Variable_name       | Value                                |
+---------------------+--------------------------------------+
| slow_query_log_file | /var/lib/mysql/01d03e4c2a5e-slow.log |
+---------------------+--------------------------------------+
1 row in set


mysql>  show variables like 'relay_log';
+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| relay_log     | 01d03e4c2a5e-relay-bin |
+---------------+------------------------+
1 row in set
----01d03e4c2a5e  docker容器id 或者机器名