I've recently started experiencing a database issue with my forum. This is the query that is lagging:
It seems to be happening at roughly the same time each week, which makes me think it could be a scheduled task but am having difficulty working out what exactly is causing it. I presume it's being caused by an add-on? Any help greatly appreciated!
Code:
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefiniIt seems to be happening at roughly the same time each week, which makes me think it could be a scheduled task but am having difficulty working out what exactly is causing it. I presume it's being caused by an add-on? Any help greatly appreciated!
