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)

總結

以上是生活随笔為你收集整理的mysql log位置_MySql: log 位置的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。