ylsunyuan技术论坛
标题:
mysql 日志
[打印本页]
作者:
sun
时间:
2017-2-9 22:08
标题:
mysql 日志
一、查看mysql 数据库日志文件:
show variables like 'general_log_file';
复制代码
mysql> show variables like 'general_log_file';
+------------------+--------------------------------+
| Variable_name | Value |
+------------------+--------------------------------+
| general_log_file | /mnt/DataBase/iZ28na4xi3rZ.log |
+------------------+--------------------------------+
1 row in set (0.00 sec)
复制代码
所在位置:
mysql> show variables like 'log_%';
+---------------------------------+------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_error | /alidata/log/mysql/error.log |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
+---------------------------------+------------------------------+
8 rows in set (0.00 sec)
复制代码
欢迎光临 ylsunyuan技术论坛 (http://bbs.ylsunyuan.com/)
Powered by Discuz! X3.2