巧用MySQLlog调试程序

2009/2/2 22:46:13    发布:walf_man

打开my.ini文件

在[mysqld]的下面加上
log = c:/mysql_query.log.txt
重启mysql

以后你用可以用editplus查看你运行的sql了,不用在程序里一句句的用log打出来了.

附:Mysql Doc:
http://dev.mysql.com/doc/mysql/en/Log_Files.html
Log File Types of Information Logged to File
The error log Logs problems encountered starting, running, or stopping mysqld.
The isam log Logs all changes to the ISAM tables. Used only for debugging the isam code.
The query log Logs established client connections and executed statements.
The update log Logs statements that change data. This log is deprecated.
The binary log Logs all statements that change data. Also used for replication.
The slow log Logs all queries that took more than long_query_time seconds to execute or didn't use indexes.

来源URL：http://www.chinaitpower.com/A/2002-11-07/40198.html

发表评论:

即刻认识你所在地区的8万帅哥美女
免费注册,简单容易!匿名电邮,既隐秘又安
全!注意:绝不含有或容许任何色情成份!
chinesefriendfinder.com

[评论最长字数:1000,查看结果请刷新]

◎请在这里发表您的看法，发言请遵守国家有关法律、法规，尊重网上道德，承担一切因您的行为而直接或间接引起的法律责任。