You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "huaicui (JIRA)" <ji...@apache.org> on 2018/09/28 07:19:00 UTC

[jira] [Created] (KYLIN-3601) PreparedContextPool生成的连接数据与配置不一致

huaicui created KYLIN-3601:
------------------------------

             Summary: PreparedContextPool生成的连接数据与配置不一致
                 Key: KYLIN-3601
                 URL: https://issues.apache.org/jira/browse/KYLIN-3601
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v2.5.0
            Reporter: huaicui
         Attachments: FirstResponseDistribute.jpg, SixthResponseDistribute.jpg, image-2018-09-28-15-14-00-288.png

因为并发性能不够，使用了magang提供的PrepareStatement方法进行测试。性能有所有提高，但随着测试次数的增加，吞吐率会越来越低而且数据超时也越来越多。经过修改代码在queryAndUpdateCache最后返回前加入日志打印：logger.debug("BorrowedCount:"+preparedContextPool.getBorrowedCount()
 +",DestroyedCount:"+preparedContextPool.getDestroyedCount()
 +",CreatedCount:"+preparedContextPool.getCreatedCount()
 +",ReturnedCount:"+preparedContextPool.getReturnedCount()

同时配置文件加入该配置：
kylin.query.statement-cache-max-num-per-key=200
 
 
日志显示，当同一sql并发一段时间后，PreparedContextPool创建了越来越多PrepareStatement，并没有进行阻塞后续来的请求。
!image-2018-09-28-15-14-00-288.png!



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)