hypixel服务器,怎么查看mysql日志路径

怎么查看mysql日志路径

查看mysql日志路径的方法:

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)

赞(0)
未经允许不得转载:主机测评网 » hypixel服务器,怎么查看mysql日志路径
分享到: 更多 (0)