springboot监控db事项

1. 增加CAT对SQL的监控

//DynamicDataSourceConfig.java
sessionFactory.setPlugins(new CatMybatisInterceptor("defaultDatasource"));//cat监控SQL执行效率

2.增加对druid Connection的监控

#logback.xml
<logger name="druid.sql.Connection" level="DEBUG"/>

#application.properties
spring.addr-datasource.filters=stat,wall,slf4j

3.打印SQL执行语句

#logback.xml
<logger name="com.xiaomi.nr.address.infra.repository.dao" level="DEBUG"/>