Question

mysql日志文件在哪

Answer 1

登录mysql终端
日志文件路径
mysql> show variables like 'general_log_file';
------------------ ------------------------------------
| Variable_name | Value |
------------------ ------------------------------------
| general_log_file | /usr/local/mysql/data/localhost.log |
------------------ ------------------------------------
1 row in set (0.00 sec)
错误日志文件路径
mysql> show variables like 'log_error';
--------------- ------------------------------------
| Variable_name | Value |
--------------- ------------------------------------
| log_error | /usr/local/mysql/data/localhost.err |
--------------- ------------------------------------
1 row in set (0.00 sec)
慢查询日志文件路径
mysql> show variables like 'slow_query_log_file';
--------------------- -----------------------------------------
| Variable_name | Value |
--------------------- -----------------------------------------
| slow_query_log_file | /usr/local/mysql/data/localhost-slow.log |
--------------------- -----------------------------------------
1 row in set (0.01 sec)