|
|
package com.yuxue.config;
|
|
|
|
|
|
import com.alibaba.druid.filter.Filter;
|
|
|
import com.alibaba.druid.filter.stat.StatFilter;
|
|
|
import com.alibaba.druid.pool.DruidDataSource;
|
|
|
import com.alibaba.druid.support.http.StatViewServlet;
|
|
|
import com.google.common.collect.Lists;
|
|
|
import org.springframework.boot.context.properties.ConfigurationProperties;
|
|
|
import org.springframework.boot.web.servlet.ServletRegistrationBean;
|
|
|
import org.springframework.context.annotation.Bean;
|
|
|
import org.springframework.context.annotation.Configuration;
|
|
|
|
|
|
/**
|
|
|
* druid连接池的配置,配置如何处理慢sql，
|
|
|
*/
|
|
|
@Configuration
|
|
|
public class DruidConfig {
|
|
|
|
|
|
// 这个注解读取配置文件前缀为prefix的配置，将外部的配置文件与这里绑定
|
|
|
// 容器的开启与关闭
|
|
|
@ConfigurationProperties(prefix = "spring.druid")
|
|
|
@Bean(initMethod = "init", destroyMethod = "close")
|
|
|
public DruidDataSource dataSource() {
|
|
|
DruidDataSource dataSource = new DruidDataSource();
|
|
|
dataSource.setProxyFilters(Lists.newArrayList(statFilter()));
|
|
|
return dataSource;
|
|
|
}
|
|
|
|
|
|
// bean注解，成为spring的bean，利用filter将慢sql的日志打印出来
|
|
|
//@Bean
|
|
|
public Filter statFilter() {
|
|
|
StatFilter statFilter = new StatFilter();
|
|
|
// 多长时间定义为慢sql，这里定义为5s
|
|
|
statFilter.setSlowSqlMillis(5000);
|
|
|
// 是否打印出慢日志
|
|
|
statFilter.setLogSlowSql(true);
|
|
|
// 是否将日志合并起来
|
|
|
statFilter.setMergeSql(true);
|
|
|
return statFilter;
|
|
|
}
|
|
|
|
|
|
// 这是配置druid的监控
|
|
|
@Bean
|
|
|
public ServletRegistrationBean servletRegistrationBean() {
|
|
|
return new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
|
|
|
}
|
|
|
|
|
|
}
|
