Xon submitted a new resource:
Deadlock Avoidance - Workarounds for sporadic deadlocks on busy forums
Read more about this resource...
Deadlock Avoidance - Workarounds for sporadic deadlocks on busy forums
XenForo's Datawriters have a _postSaveAfterTransaction() method. This method is intended to run after a database transaction is finished, but if a DataWriter is called from with-in another DataWriter, this does not happen.
This incurs the risk that various notification actions will pull in large queries into the transaction, which increasing the risk of deadlocks on a busy forum.
This is a formally private add-on which has been in use for about a month before being released.
This add-on is only for busy forums which sometimes experience deadlocks on the listed...
Read more about this resource...