druid慢sql监控
1、引入依赖
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>${druid.version}</version> </dependency>2、application.yml配置
spring: datasource: druid: # 使用druid数据源 filter: stat: slow-sql-millis: 1000 #slowSqlMillis的缺省值为3000，也就是3秒。 log-slow-sql: true #日志输出执行慢的SQL enabled: true db-type: mysql3、logback.xml配置
error配置
<!-- error日志输出 --> <appender name="ErrorFile" class="ch.qos.logback.core.rolling.RollingFileAppender"> <File>${LOG_HOME:-d:/}logs/error/error.log</File> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <FileNamePattern>${LOG_HOME:-d:/}logs/error/error-%d{yyyy-MM-dd}.%i.log </FileNamePattern> <MaxHistory>60</MaxHistory> <TimeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP"> <MaxFileSize>5MB</MaxFileSize> </TimeBasedFileNamingAndTriggeringPolicy> </rollingPolicy> <layout class="ch.qos.logback.classic.PatternLayout"> <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n </pattern> </layout> <filter class="ch.qos.logback.classic.filter.LevelFilter"><!-- 只打印错误日志 --> <level>ERROR</level> <onMatch>ACCEPT</onMatch> <onMismatch>DENY</onMismatch> </filter> </appender>默认会打印到error.log中，如果不想打印到error.log，想独立一个日志文件，可以进行下面的配置。
慢SQL打印独到立文件中
<!--druid start--> <appender name="DruidFile" class="ch.qos.logback.core.rolling.RollingFileAppender"> <File>${LOG_HOME:-d:/}logs/slow_sql/slow_sql.log</File> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <FileNamePattern>${LOG_HOME:-d:/}logs/slow_sql/slow_sql-%d{yyyy-MM-dd}.%i.log </FileNamePattern> <MaxHistory>60</MaxHistory> <TimeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP"> <MaxFileSize>5MB</MaxFileSize> </TimeBasedFileNamingAndTriggeringPolicy> </rollingPolicy> <layout class="ch.qos.logback.classic.PatternLayout"> <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n </pattern> </layout> <filter class="ch.qos.logback.classic.filter.LevelFilter"><!-- 只打印错误日志 --> <level>ERROR</level> <onMatch>ACCEPT</onMatch> <onMismatch>DENY</onMismatch> </filter> </appender> <logger name="com.alibaba.druid.filter.stat.StatFilter" additivity="false"> <!-- 这里可以按需配置日志级别 --> <level value="error" /> <appender-ref ref="DruidFile" /> </logger> <!--druid end-->4、错误日志
根据logback.xml配置，会生产慢sql日志slow_sql.log
[ERROR] 2022-08-30 22:44:15.651 [http-nio-8080-exec-1] c.a.druid.filter.stat.StatFilter - slow sql 4698 millis. SELECT id,name,no,create_time,update_time FROM user[] [ERROR] 2022-08-30 22:57:15.183 [http-nio-8080-exec-2] c.a.druid.filter.stat.StatFilter - slow sql 3645 millis. SELECT id,name,no,create_time,update_time FROM user[]