I am facing deadlock on civicrm_acl_cache. I am sending email to 400,000 users. Many times, deadlock occur and due to system lock website goes down.
Need help from team
CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this communityI am facing deadlock on civicrm_acl_cache. I am sending email to 400,000 users. Many times, deadlock occur and due to system lock website goes down.
Need help from team
Consider installing CiviCRM 5.13.1 and enabling multiple MySQL locks. See https://github.com/civicrm/civicrm-core/pull/13854 for details.