Burt-L
commented
5 years ago 配置如下： spring.datasource.url=jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true spring.datasource.username=xxx spring.datasource.password=xxx spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.druid.initialSize=5 spring.datasource.druid.minIdle=5 spring.datasource.druid.maxActive=20 spring.datasource.druid.maxWait=60000 spring.datasource.druid.timeBetweenEvictionRunsMillis=60000 spring.datasource.druid.minEvictableIdleTimeMillis=300000 spring.datasource.druid.validationQuery=SELECT "x" spring.datasource.druid.testWhileIdle=true spring.datasource.druid.testOnBorrow=false spring.datasource.druid.testOnReturn=false spring.datasource.druid.poolPreparedStatements=true spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20 spring.datasource.druid.filters=stat,wall,config spring.datasource.druid.filter.wall.enabled=true spring.datasource.druid.filter.wall.config.select-limit=3 spring.datasource.druid.filter.wall.db-type=mysql spring.datasource.druid.filter.wall.config.multi-statement-allow=true spring.datasource.druid.filter.stat.enabled=true spring.datasource.druid.filter.stat.merge-sql=false spring.datasource.druid.filter.stat.slow-sql-millis=5000
com.alibaba.druid.wall.WallProvider#checkInternal
ksewen
版本：druid-spring-boot-starter:1.1.16 场景：springboot:2.0.3 + mybatis-plus-boot-starter:2.3 + mysql 简单单表查询
SELECT user_id AS userId,user_name AS userName,mobile,create_by AS createBy,created_time AS createdTime,updated_by AS updatedBy,updated_time AS updatedTime,is_deleted AS isDeleted FROM test_user WHERE is_deleted=0使用jmeter并发请求(Ramp-Up Period时间为0)，会出现未在以上sql拼接limit的情况。且该sql后续执行都不会被WallFilter加上limit。