1. 旧的不去新的不来,论坛迁移通知新地址

    因为当前 xf2.0 用户数据无法转换,请自行注册新账号,注册成功后,购买过 vip 会员的朋友请 PM 我,告诉我新站注册的用户名,我将会帮你升级认证账号。(如果不知道注册问题答案的也可在PM中提出,新站仅支持中文用户注册。)

Add-on [XenMods] Deadlock Avoidance by Xon 1.0.18

论坛过于繁忙出现死锁解决方案

  1. admin
    兼容XenForo版本:
    •   1.4
    •   1.5
    安装需求:
    php +5.5
    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 conditions. Please test carefully as this add-on may break other add-ons.

    This add-on requires php +5.5, and will not work with earlier versions.

    • Race condition for watch thread toggle
    • Deadlock on conversations
    • Deadlock on posts
    • Deadlock on resolving/rejecting Reports

    Race condition for watch thread toggle

    Fixes a race condition when creating/removing a watch thread state

    Deadlock on conversations

    Provides a workaround for a XenForo design issue where updating conversation counters can cause deadlocks.
    • rebuilding user conversation counters occurs inside a large transaction, and is deadlock prone.

    Deadlock on posts

    Provides a workaround for a XenForo design issue where adding/removing posts can cause deadlocks.
    • updating user alert counters occurs inside a large transaction, and is deadlock prone.

    Deadlock on resolving/rejecting Reports
    Provides a workaround for a XenForo design issue where adding/removing posts can cause deadlocks.
    • Sends report resolve/reject alerts inside the transaction.

    Installation

    I recommend using Add-on install & upgrade or [TH] Install and Upgrade to install this addon.

    Contributing features or bug fixes
    Please create a Github Pull request via the "Find more info at github.com..." link.

    Contributions

    If you appreciate this addon, please consider a contribution via PayPal. Details will be provide via private conversation.

    Please contact me if you wish for different licencing arrangements.