morningman commented on issue #3859:
URL: 
https://github.com/apache/incubator-doris/issues/3859#issuecomment-644705585


   > 2\. For `publish timeout`, I think we should improve publish version 
performance.
   
   Yes, publish timeout is the root cause of this problem. This part needs 
continuous optimization
   
   > 3\. I think we could add a MVVC GC mechanism like other database system.
   
   If there is still a serious timeout problem, the MVCC mechanism cannot 
fundamentally solve this problem. Because we still face the problem of how to 
set the appropriate `unused_rowset_gc_window_seconds` value. If timeout is 
delayed by 10 minutes, then `unused_rowset_gc_window_seconds` must be set to 
greater than 10 minutes. However, MVCC can solve the problem of poor reading 
performance due to the accumulation of data versions during the delay.
   
   
   In summary, `latest read version` is just a temporary solution that can 
alleviate the problem. And in most cases there should be no problems. In fact, 
@chaoyli  has written a function that supports multi-path lookup of version 
graph, maybe we can implement a complete MVCC logic on this basis.
   


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to