doris-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [incubator-doris] songenjie 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 03:01:07 GMT

songenjie commented on pull request #4284:
URL: https://github.com/apache/incubator-doris/pull/4284#issuecomment-680461074


   > @songenjie Hi, what's your design doc for this PR? I think this PR is repeated with
SQL mode cache in #4330 , what do you think it?
   
   @kangkaisen  
   
   1. Sql Cache Mode 
   - If this switch is turned on, the SQL query result set will be cached. If the interval
between the last visit version time in all partitions of all tables in the query is greater
than cache_last_version_interval_second, and the result set is less than cache_result_max_row_count,
the result set will be cached, and the next same SQL will hit the cache.
   2. 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


----------------------------------------------------------------
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