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

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

PeppaO commented on issue #6615:
URL: https://github.com/apache/incubator-seata/issues/6615#issuecomment-2212322927

   在g表插入一列podName(假设是有状态部署方式)，有几个tc节点在distribution_lock表中就有几把关于committing的锁。
   每把锁处理对应的podName对应的g表数据,锁key为podName+_committing，在handleRetryCommitting定时器中，foreach获取一把分布式锁，假设有
   3个tc节点，就会轮训获取其中一个分布式锁，获取到后处理对应的任务。
   g表
   xid podName
   111 seata-0
   112 seata-1
   113 seata-0
   114 seata-2
   
   distrubition-lock
   key                     value           expire
   seata-0_committing      ip:port          ....
   seata-1_committing      ip:port          ....
   seata-2_committing      ip:port          ....


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

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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