p6spy监控sql语句

王念博客

发布于 2019-07-25 18:20:30

1.7K0

发布于 2019-07-25 18:20:30

P6Spy 是针对数据库访问操作的动态监测框架（为开源项目，项目首页：www.p6spy.com）它使得数据库数据可无缝截取和操纵，而不必对现有应用程序的代码作任何修改。P6Spy 分发包包括P6Log，它是一个可记录任何 Java 应用程序的所有JDBC事务的应用程序。其配置完成使用时，可以进行数据访问性能的监测。

我们最需要的功能，查看sql语句，不是预编译的带问号的哦，而是真正的数据库执行的sql，更直观，更简单。

1.依赖jar包

 <dependency>
	<groupId>p6spy</groupId>
	<artifactId>p6spy</artifactId>
	<version>2.2.0</version>
</dependency>

2.修改jdbc驱动为p6spy

datasource.druid.driverClassName=com.p6spy.engine.spy.P6SpyDriver

3.添加配置

#第一：module.log的属性必须配置，如果不配置，P6SPY将不起任何作用，典型配置：
module.log=com.p6spy.engine.logging.P6LogFactory
#module.outage=com.p6spy.engine.outage.P6OutageFactory
 
#第二：数据库驱动配置
# oracle driver
# realdriver=oracle.jdbc.driver.OracleDriver
 
# mysql Connector/J driver
# realdriver=com.mysql.jdbc.Driver
 
# informix driver
# realdriver=com.informix.jdbc.IfxDriver
 
# ibm db2 driver
# realdriver=COM.ibm.db2.jdbc.net.DB2Driver
 
# the mysql open source driver
realdriver=org.gjt.mm.mysql.Driver
 
#specifies another driver to use
realdriver2=
#specifies a third driver to use
realdriver3=
 
#第三：appender配置，一般分为三种
#specifies the appender to use for logging
#appender=com.p6spy.engine.logging.appender.Log4jLogger
#控制台
#appender=com.p6spy.engine.logging.appender.StdoutLogger
appender=com.p6spy.engine.logging.appender.FileLogger
 
# name of logfile to use, note Windows users should make sure to use forward slashes in their pathname (e:/test/spy.log) (used for file logger only)
#日志文件存放路径及文件名
logfile     = spy.log
 
# append to  the p6spy log file.  if this is set to false the
# log file is truncated every time.  (file logger only)
append=true
 
#The following are for log4j logging only
log4j.appender.STDOUT=org.apache.log4j.ConsoleAppender
log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout
log4j.appender.STDOUT.layout.ConversionPattern=p6spy - %m%n
 
log4j.logger.p6spy=INFO,STDOUT

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

如有侵权请联系 cloudcommunity@tencent.com 删除

数据库