how to enable MySQL query log?
来源:互联网 发布:eromangabox新域名 编辑:程序博客网 时间:2024/05/22 15:00
1、to enable the query log,put this in /etc/my.cnf in the [mysqld] section
log=/usr/local/mysql_query.log
2、this worked for me(Mysql 5.6.12 on windows),set parameter int the mysql console:
set global general_log=on;
set global general=1#(or 0 to disable)
set global general_log_file='c:/mysql_query.log'
set global log_output='file'
linux下修改my.cnf如下:
[[mysqld]]general-loggeneral-log-file=queries.loglog-output=file
0 0
- how to enable MySQL query log?
- How to enable DNN Site Log
- How to enable the uart log in user version
- How Do I Enable Remote Access To MySQL Database Server?
- How to enable web condor?
- How to enable navigation arrows
- How to enable the debugfs
- How to Enable Multi-Touch
- MySQL Query Log
- mysql query log
- how to capture log
- how to find the log file of mysql
- how to enable debug in eclipse + weblogic
- how to enable sql dependency output cache
- How to enable SSO on domino server
- How to enable SSL on domino server
- How to enable email notification of commits
- How to enable Windows Installer logging
- Caffe如何画出训练中的loss曲线图和accuracy曲线图
- SpringMvc点点滴滴之注解
- Quick-cocos2d-x 中进度条与资源加载
- 第十二周项目三 图遍历算法实现——广度优先(BFS)遍历
- recyclerview,AppBarLayout,Toolbar,CoordinatorLayout 的结合使用~
- how to enable MySQL query log?
- 第九周项目4--广义表算法库及应用1
- 个税计算器by橙子博客
- JAVA-Struts2学习之环境搭建
- FastJson解析is开头变量方法
- SPI IIC UART通信协议简单说明
- js 屏蔽回车键
- input子系统按键处理
- Android查找dalvikvm疯狂调用GC原因