Java

本类阅读TOP10
·使用MyEclipse开发Struts框架的Hello World!(录像1)
·hibernate配置笔记
·AOP编程入门--Java篇
·linux下Tomcat 5.0.20 与 Apache 2 安装/集成/配置
·在win2003下整合了整合Tomcat5.5+ apache_2.0.53+ mod_jk_2.0.47.dll
·构建Linux下IDE环境--Eclipse篇
·Jsp 连接 mySQL、Oracle 数据库备忘(Windows平台)
·ASP、JSP、PHP 三种技术比较
·Tomcat5.5.9的安装配置
·AWT GUI 设计笔记(二)

→ 分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
巧用MySQL log调试程序

作者：未知 来源：月光软件站 加入时间：2005-2-28　月光软件站
打开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.



相关文章：

相关软件：