e7 opened a new issue #2344: why checking connection so frequently with druid? URL: https://github.com/apache/incubator-shardingsphere/issues/2344 ```yaml datasource: names: master,slave0 master: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.1.229:3306/xxxx?useSSL=false&useUnicode=true&serverTimezone=UTC&characterEncoding=UTF-8&autoReconnect=true username: xxxx password: 123456 druid: test-on-borrow: false test-while-idle: true validation-query: SELECT 1 time-between-eviction-runs-millis: 30000 min-evictable-idle-time-millis: 30000 connection-init-sqls: set names utf8mb4; slave0: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.1.229:3306/xxxx?useSSL=false&useUnicode=true&serverTimezone=UTC&characterEncoding=UTF-8&autoReconnect=true username: xxxx password: 123456 druid: test-on-borrow: false test-while-idle: true validation-query: SELECT 1 time-between-eviction-runs-millis: 30000 min-evictable-idle-time-millis: 30000 connection-init-sqls: set names utf8mb4; ``` ``` 2019-05-08 09:19:34.444 INFO 10660 --- [nio-8080-exec-7] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:34.444 INFO 10660 --- [nio-8080-exec-7] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:35.441 INFO 10660 --- [io-8080-exec-10] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:35.441 INFO 10660 --- [io-8080-exec-10] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:36.448 INFO 10660 --- [nio-8080-exec-9] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:36.448 INFO 10660 --- [nio-8080-exec-9] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:37.449 INFO 10660 --- [nio-8080-exec-5] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:37.449 INFO 10660 --- [nio-8080-exec-5] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:38.455 INFO 10660 --- [nio-8080-exec-6] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:38.456 INFO 10660 --- [nio-8080-exec-6] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:39.458 INFO 10660 --- [nio-8080-exec-2] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:39.458 INFO 10660 --- [nio-8080-exec-2] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 2019-05-08 09:19:40.455 INFO 10660 --- [nio-8080-exec-1] ShardingSphere-SQL : Rule Type: master-slave 2019-05-08 09:19:40.456 INFO 10660 --- [nio-8080-exec-1] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0 ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
