[D] global_table 2分10s延迟删除太慢了，在高并发下，这张表数据太多了，有啥优化方案吗 [incubator-seata]

["PeppaO (via GitHub)" <gi...@apache.org>]

GitHub user PeppaO created a discussion: global_table 2分10s延迟删除太慢了，在高并发下，这张表数据太多了，有啥优化方案吗

global_table 2分10s延迟删除太慢了，在高并发下，这张表数据太多了，有啥优化方案吗？
除了调低这个130s的参数，还有其他方案吗？
如果等它低频的时候删除完毕，我很担心在高频的时候随着global_table的堆积，影响tps，浪费数据库磁盘空间
@slievrly @funky-eyes @lightClouds917 @wangliang181230

GitHub link: https://github.com/apache/incubator-seata/discussions/6616

----
This is an automatically sent email for dev@seata.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@seata.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@seata.apache.org
For additional commands, e-mail: dev-help@seata.apache.org

Re: [D] global_table 2分10s延迟删除太慢了，在高并发下，这张表数据太多了，有啥优化方案吗 [incubator-seata]

["slievrly (via GitHub)" <gi...@apache.org>]

GitHub user slievrly added a comment to the discussion: global_table 2分10s延迟删除太慢了，在高并发下，这张表数据太多了，有啥优化方案吗

1. Increase queryLimit
2. Asynchronous task to clean up global_table and perform data sharding

GitHub link: https://github.com/apache/incubator-seata/discussions/6616#discussioncomment-9802960

----
This is an automatically sent email for dev@seata.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@seata.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@seata.apache.org
For additional commands, e-mail: dev-help@seata.apache.org