文件名称:mysql_log_analysis
介绍说明--下载内容均来自于网络,请自行研究使用
MySQL记录日志查询对于跟踪PHP+MySQL体系下的MySQL负载调优问题很有用处,比如安装了很多Discuz!插件的用户,这样可以大概排查出那些插件有代码问题。其实启用MySQL的慢查询日志很简单,只需要在MYSQL.INI 增加参数即可
log= c:/mysql_query.log
重启mysql就可以将数据库所有操作记录下来,为了方便分析,提供一个简单快速的查看器。
打开文件设置执行目录与地址即可-For the tracking system of PHP+ MySQL MySQL MySQL log query load optimization problem is very useful, such as installing a lot of Discuz! Plugin users. Only in this way can about the investigation of the plugin code. In fact, the slow query log enabled MySQL is very simple, only need to add parameters in the MYSQL.INI can be
C:/mysql_query.log log=
Restart MySQL can be recorded for all operations, in order to facilitate the analysis, provides a simple and fast viewer.
Open the file settings to implement the directory and address can be
log= c:/mysql_query.log
重启mysql就可以将数据库所有操作记录下来,为了方便分析,提供一个简单快速的查看器。
打开文件设置执行目录与地址即可-For the tracking system of PHP+ MySQL MySQL MySQL log query load optimization problem is very useful, such as installing a lot of Discuz! Plugin users. Only in this way can about the investigation of the plugin code. In fact, the slow query log enabled MySQL is very simple, only need to add parameters in the MYSQL.INI can be
C:/mysql_query.log log=
Restart MySQL can be recorded for all operations, in order to facilitate the analysis, provides a simple and fast viewer.
Open the file settings to implement the directory and address can be
(系统自动生成,下载前可以参看下载内容)
下载文件列表
说明.htm
mysql_query.php