文件名称:mysql_log_analysis
-
所属分类:
- 标签属性:
- 上传时间:2016-04-20
-
文件大小:3.7kb
-
已下载:0次
-
提 供 者:
-
相关连接:无下载说明:别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容来自于网络,使用问题请自行百度
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
(系统自动生成,下载前可以参看下载内容)
下载文件列表
chinaz.com.txt
说明.htm
mysql_query.php
说明.htm
mysql_query.php
本网站为编程资源及源代码搜集、介绍的搜索网站,版权归原作者所有! 粤ICP备11031372号
1999-2046 搜珍网 All Rights Reserved.