Druid 监控sql运行效率
https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98
Druid是什么
按照阿里的说法
Druid是Java语言中最好的数据库连接池。Druid能够提供强大的监控和扩展功能。
(阿里的fastjson 也自称是最快的)
1. Pom.xml 增加
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.17</version>
</dependency>
2. spring.xml 增加(修改)
<beanid="statFilter" class="com.alibaba.druid.filter.stat.StatFilter">
<!—sql运行超过这个值 就打印出 单位 毫秒 -->
<property name="slowSqlMillis"value="1" />
<!-- 是否打印慢sql -->
<property name="logSlowSql"value="true" />
</bean>
<beanid="dataSource" class="com.alibaba.druid.pool.DruidDataSource"init-method="init" destroy-method="close">
..........
<propertyname="proxyFilters">
<list>
<ref bean="statFilter"/>
</list>
</property>
</bean>
3. log4j 配置 慢sql 打印到指定的log中
log4j.logger.com.alibaba.druid.filter.stat.StatFilter=info,statAppender
log4j.appender.statAppender=org.apache.log4j.RollingFileAppender
log4j.appender.statAppender.MaxFileSize=5000KB
log4j.appender.statAppender.MaxBackupIndex=50
log4j.appender.statAppender.File=/home/tomcat/logs/slowsql.log
log4j.appender.statAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.statAppender.layout.ConversionPattern=%d[%t] %-5p [%c] - %m%n
附 打印出来的log