mysql动态添加mybatis的sql执行所需要的时间

m0_60380027

已于 2023-03-04 22:58:46 修改

阅读量577

点赞数

文章标签： jar

于 2022-04-24 10:45:01 首次发布

原文链接：https://mp.csdn.net/mp_blog/creation/editor/124377372

版权

该博客介绍了如何使用MyBatis的拦截器插件SqlStatementInterceptor来监控SQL执行的耗时。通过在Executor的update和query方法上添加拦截，记录并根据执行时间不同级别输出日志，帮助开发者定位慢查询问题。配置文件中启用了插件，实现了对SQL执行时间的精细化监控。

摘要由CSDN通过智能技术生成

SqlStatementInterceptor.java



import org.apache.ibatis.cache.CacheKey;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.*;
import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.util.Properties;

/**
 * @Author
 * @Date
 * @Version 版本号
 * @Description mybatis执行sql耗时
 */
@Intercepts({
        @Signature(type = Executor.class, method = "update", args = {MappedStatement.class,
                Object.class}),
        @Signature(type = Executor.class, method = "query", args = {MappedStatement.class,
                Object.class, RowBounds.class, ResultHandler.class, CacheKey.class,BoundSql.class})})
@SuppressWarnings({"unchecked", "rawtypes"})
public class SqlStatementInterceptor implements Interceptor {
    public static final Logger log = LoggerFactory.getLogger(SqlStatementInterceptor.class);

    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        long startTime = System.currentTimeMillis();
        try {
            return invocation.proceed();
        } finally {
            long timeConsuming = System.currentTimeMillis()-startTime;
            log.debug("执行SQL:{}ms", timeConsuming);
            if(timeConsuming>999&&timeConsuming<5000){
                log.info("执行SQL大于1s:{}ms", timeConsuming);
            }else if(timeConsuming>=5000&&timeConsuming<10000){
                log.info("执行SQL大于5s:{}ms", timeConsuming);
            }else if(timeConsuming>=10000){
                log.info("执行SQL大于10s:{}ms", timeConsuming);
            }
        }
    }

    @Override
    public Object plugin(Object target) {
        return Plugin.wrap(target, this);
    }

    @Override
    public void setProperties(Properties properties) {

    }
}

配置文件开启插件

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<settings>
		<setting name="cacheEnabled"             value="true"  />  <!-- 全局映射器启用缓存 -->
		<setting name="useGeneratedKeys"         value="false"  />  <!-- 允许 JDBC 支持自动生成主键 -->
		<setting name="defaultExecutorType"      value="REUSE" />  <!-- 配置默认的执行器 -->
		<setting name="logImpl"                  value="SLF4J" />  <!-- 指定 MyBatis 所用日志的具体实现 -->
		<setting name="mapUnderscoreToCamelCase" value="true"/>  <!--驼峰式命名 -->
	</settings>
	<plugins>
		<plugin interceptor="com.config.SqlStatementInterceptor"/>
	</plugins>
	
</configuration>