1
mysql日志记录(3)在MySQL表中显示日志
source link: https://wakzz.cn/2017/11/05/mysql/%E6%97%A5%E5%BF%97%E8%AE%B0%E5%BD%95(3)%E5%9C%A8MySQL%E8%A1%A8%E4%B8%AD%E6%98%BE%E7%A4%BA%E6%97%A5%E5%BF%97/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
mysql日志记录(3)在MySQL表中显示日志
祈雨的博客
2017-11-05
1、默认值
MySQL日志默认存在文件中
mysql> show variables like 'log_output';
mysql> set global log_output='table';
慢查询的MySQL表:mysql.slow_log
SQL记录的MySQL表:mysql.general_log
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK