mysql log位置_MySql: log 位置

mysql日志文件位置

登录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)