定位慢sql

1. 引入druid

   druid包装datasource

   <dependency>     <groupId>com.alibaba</groupId>     <artifactId>druid</artifactId> </dependency>

2. 添加Druid监控

   添加Druid监控

   @Value("${druid.stat.loginUsername:mdxAdmin}") private String loginUsername;   @Value("${druid.stat.loginPassword:[email protected]}") private String loginPassword;    @Bean @Profile("druidStat") public ServletRegistrationBean statViewServlet() {     ServletRegistrationBean registrationBean = new ServletRegistrationBean();     registrationBean.setServlet(new StatViewServlet());     registrationBean.addUrlMappings("/druid/*");     registrationBean.addInitParameter("loginUsername", loginUsername);     registrationBean.addInitParameter("loginPassword", loginPassword);     registrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");       return registrationBean; }

3. 启动服务并登陆 （http://localhost:8081/druid/login.html，账号、密码、路径可以在步骤2中配置）
   
   
   
4. 点击 SQL监控并查看
   
   
   这里展示所有执行sql，可根据[最慢]进行排序
   
   
5. 点击可疑sql（步骤4图红色部分）
   
   
   这里展示sql详情
   
   
   

代码参考：https://gitlab.fenqi.im/r_d_arch_team/framework-server-example/tree/master

druid：https://github.com/alibaba/druid

使用例子：http://blog.****.net/flyfish778/article/details/53470683