doris-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [incubator-doris] kangkaisen commented on pull request #4284: [Apache][Doris][Feature][FE]Support users with high QPS in the same query through result set cache
Date Wed, 26 Aug 2020 04:44:08 GMT

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


Mime
View raw message