anhnongdan / cBIMAX

Official source code for cBIMAX - the analytics system for CDN
0 stars 0 forks source link

[Live] Live count(*) cause DB deadlock on high traffic instance #41

Closed anhnongdan closed 7 years ago

anhnongdan commented 7 years ago

https://bitbucket.org/anhnongdan/bimax_seed/issues/36/pw5-high-traffic-mysql-dead-lock-with

anhnongdan commented 7 years ago

Wrong diagnosis, it's rotate's rename query that causes the deadlock.