应用侧使用druid 配置是 initial-size=10,max-active=200,连接串spring.datasource.ap.url=jdbc:mysql://10.188.63.207:9030,10.188.63.201:9030,10.188.63.203:9030/xcerp_dataservice?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai&connectTimeout=30000&socketTimeout=1900000Doris机器12台,三台FE,12BE,机器配置为96C,512G,单条SQL查询在3秒左右,并发上来后,大概100个会话,速度到2分半。SQL如下:
SELECT COUNT (*) AS total FROM DWD_PCC_EXPENDITURE WHERE (org_id IN (8354 , 4055 , 4056 , 191 , 193 , 194 , 195 , 196 , 197 , 1679 , 198 , 1656 , 199 , 1676 , 1653 , 1674 , 1651 , 19207 , 1659 , 1671 , 8282 , 1666 , 200 , 421 , 1664 , 1345 , 422 , 423 , 424 , 1661 , 425 , 426 , 1669 ) AND project_code = 'C24303333AA5009' AND updated_datetime >= 2018-06-01T00:00 AND updated_datetime <= 2018-07-01T00:00 )