druid慢sql监控

1、引入依赖dependency groupIdcom.alibaba/groupId artifactIddruid-spring-boot-starter/artifactId version${druid.version}/version /dependency2、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 nameErrorFile classch.qos.logback.core.rolling.RollingFileAppender File${LOG_HOME:-d:/}logs/error/error.log/File rollingPolicy classch.qos.logback.core.rolling.TimeBasedRollingPolicy FileNamePattern${LOG_HOME:-d:/}logs/error/error-%d{yyyy-MM-dd}.%i.log /FileNamePattern MaxHistory60/MaxHistory TimeBasedFileNamingAndTriggeringPolicy classch.qos.logback.core.rolling.SizeAndTimeBasedFNATP MaxFileSize5MB/MaxFileSize /TimeBasedFileNamingAndTriggeringPolicy /rollingPolicy layout classch.qos.logback.classic.PatternLayout pattern[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n /pattern /layout filter classch.qos.logback.classic.filter.LevelFilter!-- 只打印错误日志 -- levelERROR/level onMatchACCEPT/onMatch onMismatchDENY/onMismatch /filter /appender默认会打印到error.log中如果不想打印到error.log想独立一个日志文件可以进行下面的配置。慢SQL打印独到立文件中!--druid start-- appender nameDruidFile classch.qos.logback.core.rolling.RollingFileAppender File${LOG_HOME:-d:/}logs/slow_sql/slow_sql.log/File rollingPolicy classch.qos.logback.core.rolling.TimeBasedRollingPolicy FileNamePattern${LOG_HOME:-d:/}logs/slow_sql/slow_sql-%d{yyyy-MM-dd}.%i.log /FileNamePattern MaxHistory60/MaxHistory TimeBasedFileNamingAndTriggeringPolicy classch.qos.logback.core.rolling.SizeAndTimeBasedFNATP MaxFileSize5MB/MaxFileSize /TimeBasedFileNamingAndTriggeringPolicy /rollingPolicy layout classch.qos.logback.classic.PatternLayout pattern[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n /pattern /layout filter classch.qos.logback.classic.filter.LevelFilter!-- 只打印错误日志 -- levelERROR/level onMatchACCEPT/onMatch onMismatchDENY/onMismatch /filter /appender logger namecom.alibaba.druid.filter.stat.StatFilter additivityfalse !-- 这里可以按需配置日志级别 -- level valueerror / appender-ref refDruidFile / /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[]