From commits-return-14519-archive-asf-public=cust-asf.ponee.io@doris.apache.org Wed Aug 26 04:44:10 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mailroute1-lw-us.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id ECB381804BB for ; Wed, 26 Aug 2020 06:44:09 +0200 (CEST) Received: from mail.apache.org (localhost [127.0.0.1]) by mailroute1-lw-us.apache.org (ASF Mail Server at mailroute1-lw-us.apache.org) with SMTP id 2E896124C7E for ; Wed, 26 Aug 2020 04:44:09 +0000 (UTC) Received: (qmail 90300 invoked by uid 500); 26 Aug 2020 04:44:08 -0000 Mailing-List: contact commits-help@doris.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@doris.apache.org Delivered-To: mailing list commits@doris.apache.org Received: (qmail 90285 invoked by uid 99); 26 Aug 2020 04:44:08 -0000 Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2020 04:44:08 +0000 From: =?utf-8?q?GitBox?= To: commits@doris.apache.org Subject: =?utf-8?q?=5BGitHub=5D_=5Bincubator-doris=5D_kangkaisen_commented_on_pull_re?= =?utf-8?q?quest_=234284=3A_=5BApache=5D=5BDoris=5D=5BFeature=5D=5BFE=5DSupp?= =?utf-8?q?ort_users_with_high_QPS_in_the_same_query_through_result_set_cach?= =?utf-8?q?e?= Message-ID: <159841704855.32230.11910948700243233338.asfpy@gitbox.apache.org> Date: Wed, 26 Aug 2020 04:44:08 -0000 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit In-Reply-To: References: kangkaisen commented on pull request #4284: URL: https://github.com/apache/incubator-doris/pull/4284#issuecomment-680607002 > 1. this PR `Result Cache` > > * Solve the same connect ID, the same SQL high QPS problem, the same user, in `result_ cache_ expire_ after_ In_ Within milliseconds` time, executing the same SQL will hit the result cache Hi, I think the selfsame OLAP querys in prod env is very rare. Do you test this PR in your prod env? what's the cache hit rate? The Apache Kylin use SQL result cache Like this PR, After Kylin run many years in MEITUAN, we could confirm the SQL result cache is meaningless for OLAP system. The Apache Druid use segment cache like #4330, After Druid run many years in MEITUAN, we could confirm the segment cache is useful for OLAP system. So I think If we already have segment query cache, we don't need the query result cache. ---------------------------------------------------------------- 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: users@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org For additional commands, e-mail: commits-help@doris.apache.org