发新话题
移动帖子 加入精华 加入置顶 加入收藏 关注此帖

如何关闭mysql的trace日志?



如何关闭mysql的trace日志?

FROM: http://topic.csdn.net/u/20080306/11/b6760add-9acc-43aa-ae1d-726f37a444b9.html
开发环境JSP+MYSQL+Resin
用到了数据库连接池
当程序连接到数据库时,就在WEB引擎的日志文件里产生了大量的信息,一天就能产生上百兆的日志文件
这些信息都是重复而且没有任何意义的,请问如何将他们屏蔽?

垃圾日志如下:
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> Statement.java:1627 com.mysql.jdbc.Statement.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- Statement.java:1627 com.mysql.jdbc.Statement.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> Statement.java:1627 com.mysql.jdbc.Statement.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- Statement.java:1627 com.mysql.jdbc.Statement.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> Statement.java:1627 com.mysql.jdbc.Statement.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- Statement.java:1627 com.mysql.jdbc.Statement.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null
Thu Mar 06 11:20:11 CST 2008 TRACE: --> Statement.java:1627 com.mysql.jdbc.Statement.finalize()
Thu Mar 06 11:20:11 CST 2008 TRACE: <-- Statement.java:1627 com.mysql.jdbc.Statement.finalize(..) returning null

解决方法
你看看你用的MySQl的驱动,是不是debug版的。呵呵!
经检查,确实是jar驱动的问题,里面的配置文件需要修改一下

http://forums.mysql.com/read.php?39,22434,28965#msg-28965

The Solution is not the jar file but a properties file in the jar file you add to the path.

Just search for fullDebug.Properties file in the zip file and set all the values to false.

There are two cases in this. If you have downloaded from mysql site then you get the source code also. In that case you can see a couple of mysql-connector jar file inside the zip file(2 files will be there choose any one).

Now Extract that jar file(note that this contains only the class files) and include this file in the path...Remember to change the fullDebug file in this jar file.
快乐渡过每一天,减肥坚持每一天
编辑 回复 快速回复 TOP

Re:如何关闭mysql的trace日志?

解决办法究竟是怎么的?
http://hi.baidu.com/yangwen_yw
编辑 回复 快速回复 TOP
发新话题