{"action":"created","issue":{"url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/1657","repository_url":"https://api.github.com/repos/sharding-sphere/sharding-sphere","labels_url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/1657/labels{/name}","comments_url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/1657/comments","events_url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/1657/events","html_url":"https://github.com/sharding-sphere/sharding-sphere/issues/1657","id":393040369,"node_id":"MDU6SXNzdWUzOTMwNDAzNjk=","number":1657,"title":"In the case of high concurrency, the query is very slow.","user":{"login":"caixinning","id":38900707,"node_id":"MDQ6VXNlcjM4OTAwNzA3","avatar_url":"https://avatars1.githubusercontent.com/u/38900707?v=4","gravatar_id":"","url":"https://api.github.com/users/caixinning","html_url":"https://github.com/caixinning","followers_url":"https://api.github.com/users/caixinning/followers","following_url":"https://api.github.com/users/caixinning/following{/other_user}","gists_url":"https://api.github.com/users/caixinning/gists{/gist_id}","starred_url":"https://api.github.com/users/caixinning/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/caixinning/subscriptions","organizations_url":"https://api.github.com/users/caixinning/orgs","repos_url":"https://api.github.com/users/caixinning/repos","events_url":"https://api.github.com/users/caixinning/events{/privacy}","received_events_url":"https://api.github.com/users/caixinning/received_events","type":"User","site_admin":false},"labels":[{"id":1010965807,"node_id":"MDU6TGFiZWwxMDEwOTY1ODA3","url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/labels/investigate","name":"investigate","color":"f9d0c4","default":false},{"id":967023106,"node_id":"MDU6TGFiZWw5NjcwMjMxMDY=","url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/labels/need%20feedback","name":"need feedback","color":"3ec1ab","default":false}],"state":"open","locked":false,"assignee":{"login":"cherrylzhao","id":8317649,"node_id":"MDQ6VXNlcjgzMTc2NDk=","avatar_url":"https://avatars2.githubusercontent.com/u/8317649?v=4","gravatar_id":"","url":"https://api.github.com/users/cherrylzhao","html_url":"https://github.com/cherrylzhao","followers_url":"https://api.github.com/users/cherrylzhao/followers","following_url":"https://api.github.com/users/cherrylzhao/following{/other_user}","gists_url":"https://api.github.com/users/cherrylzhao/gists{/gist_id}","starred_url":"https://api.github.com/users/cherrylzhao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherrylzhao/subscriptions","organizations_url":"https://api.github.com/users/cherrylzhao/orgs","repos_url":"https://api.github.com/users/cherrylzhao/repos","events_url":"https://api.github.com/users/cherrylzhao/events{/privacy}","received_events_url":"https://api.github.com/users/cherrylzhao/received_events","type":"User","site_admin":false},"assignees":[{"login":"cherrylzhao","id":8317649,"node_id":"MDQ6VXNlcjgzMTc2NDk=","avatar_url":"https://avatars2.githubusercontent.com/u/8317649?v=4","gravatar_id":"","url":"https://api.github.com/users/cherrylzhao","html_url":"https://github.com/cherrylzhao","followers_url":"https://api.github.com/users/cherrylzhao/followers","following_url":"https://api.github.com/users/cherrylzhao/following{/other_user}","gists_url":"https://api.github.com/users/cherrylzhao/gists{/gist_id}","starred_url":"https://api.github.com/users/cherrylzhao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherrylzhao/subscriptions","organizations_url":"https://api.github.com/users/cherrylzhao/orgs","repos_url":"https://api.github.com/users/cherrylzhao/repos","events_url":"https://api.github.com/users/cherrylzhao/events{/privacy}","received_events_url":"https://api.github.com/users/cherrylzhao/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2018-12-20T13:10:39Z","updated_at":"2018-12-21T09:46:20Z","closed_at":null,"author_association":"NONE","body":"Version：\r\n#Generated by Apache Maven\r\n#Tue Oct 23 18:26:28 CST 2018\r\nversion=3.0.0\r\ngroupId=io.shardingsphere\r\nartifactId=sharding-core\r\n\r\nPhenomenon：\r\nSingle table (the table has three fields: self-increment id, varchar (512), timestamp, undivided library sub-table) insert operation, in general, mapper.insert(Object) execution time is 20ms, but as request pressure increasese (average 50~200 calls per second), executions take 5-7 seconds occasionally , and usually recovers within a few seconds. Check the database log and no slow query was found.\r\nThis phenomenon has never been seen before sharding-jdbc was used.\r\n\r\nConfig：\r\ncentos 4core 8G\r\nsql.show=false\r\nhikaricp.data={\"db1\":[\"hikaricp.data.write\",\"hikaricp.data.read\"]}\r\n\r\nhikaricp.data.write.poolName=write\r\nhikaricp.data.write.driverClassName=org.mariadb.jdbc.Driver\r\nhikaricp.data.write.jdbcUrl=jdbc:mysql://xxx?useUnicode=true&characterEncoding=utf-8&autoReconnect=true\r\nhikaricp.data.write.readOnly=false\r\nhikaricp.data.write.connectionTimeout=300000\r\nhikaricp.data.write.idleTimeout=600000\r\nhikaricp.data.write.maxLifetime=10800\r\nhikaricp.data.write.maximumPoolSize=50\r\nhikaricp.data.write.minimumIdle=5\r\n\r\nhikaricp.data.read.poolName=read\r\nhikaricp.data.read.driverClassName=org.mariadb.jdbc.Driver\r\nhikaricp.data.read.jdbcUrl=jdbc:mysql://xxx?useUnicode=true&characterEncoding=utf-8&autoReconnect=true\r\nhikaricp.data.read.readOnly=true\r\nhikaricp.data.read.connectionTimeout=300000\r\nhikaricp.data.read.idleTimeout=600000\r\nhikaricp.data.read.maxLifetime=10800\r\nhikaricp.data.read.maximumPoolSize=20\r\nhikaricp.data.read.minimumIdle=1\r\n\r\nNote：\r\nInitially suspected to be caused by slow query, after checking the database log, the table was not found to have slowquery; then it was suspected that the connection pool was insufficient, and the maximumPoolSize was adjusted from 20 to 50, which had no effect.\r\nIs personal guessing related to the execution strategy of sharding-jdbc executeEngine? For example, if there are multiple sql executions at the same time, will there be a queue or cut-line?\r\nCould you please give me some advice? Thanks a lot!"},"comment":{"url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/comments/449335748","html_url":"https://github.com/sharding-sphere/sharding-sphere/issues/1657#issuecomment-449335748","issue_url":"https://api.github.com/repos/sharding-sphere/sharding-sphere/issues/1657","id":449335748,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0OTMzNTc0OA==","user":{"login":"cherrylzhao","id":8317649,"node_id":"MDQ6VXNlcjgzMTc2NDk=","avatar_url":"https://avatars2.githubusercontent.com/u/8317649?v=4","gravatar_id":"","url":"https://api.github.com/users/cherrylzhao","html_url":"https://github.com/cherrylzhao","followers_url":"https://api.github.com/users/cherrylzhao/followers","following_url":"https://api.github.com/users/cherrylzhao/following{/other_user}","gists_url":"https://api.github.com/users/cherrylzhao/gists{/gist_id}","starred_url":"https://api.github.com/users/cherrylzhao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherrylzhao/subscriptions","organizations_url":"https://api.github.com/users/cherrylzhao/orgs","repos_url":"https://api.github.com/users/cherrylzhao/repos","events_url":"https://api.github.com/users/cherrylzhao/events{/privacy}","received_events_url":"https://api.github.com/users/cherrylzhao/received_events","type":"User","site_admin":false},"created_at":"2018-12-21T09:46:20Z","updated_at":"2018-12-21T09:46:20Z","author_association":"CONTRIBUTOR","body":"would you please upload your demo project to Github, let me have a try.\r\nor modify your demo as we have done in [sharding-sphere-example](https://github.com/sharding-sphere/sharding-sphere-example.git)"}}
{"actor":{"display_login":"cherrylzhao"}}