Rename deferred.php - impact

[loplo]

Is there any major impact if I rename deferred.php?
My hosting company is complaining about this file, they say it's consuming too much resources.
They don't give me any realtime resource monitoring, so I can't do any trial and error disabling and enabling xenforo resources.

 

[Chris D]

If we imagined for a moment that renaming it wouldn't break anything (but it would, so don't), it would still consume the same amount of resources, and they'd still be complaining about the same resource usage.

 

[Chris D]

Incidentally, if you run the following query on your database it will tell you what tasks are currently running. If you're able to do that at a time where they consider resource usage to be "too high" then it might reveal specifically what process is causing it.

SELECT deferred_id, unique_key, execute_class, trigger_date FROM xf_deferred

 

[loplo]

The only thing I can see is cron.
Can anyone confirm his process time, for deferred.php.

Mine looks like this:
Resource: Process Time
Exceeded: 160258 > 1800 (seconds)

 

[Rob]

Blimey.... something is very very wrong there. Nothing should take that long to run. I can rebuild all counters in my pretty hefty database in less time.

 

[loplo]

That's what I assumed too. My forum isn't that big, so there's somewhere something wrong.

 

[Chris D]

You will need to run that query at a time where you believe it is using too many resources.

At the moment with only Cron being in the table, that shouldn't be causing it. Although I think we have seen some clean up tasks taking longer sometimes but only where there have been huge amounts of data.

 

[loplo]

Not having access to any kind of resource monitoring, I can't runt it at that exact time.
All the info I get is via email, from my hosting provider.

Now I got a 2hrs deadline to fix my the problem, or else my account will be suspended. The only thing I could do, it was renaming the file.

It looks like I need to reinstall XF, because I can't debug it.

Is there a tutorial how to backup forums, conversations, etc, clean xf install and restore forum content.
I have some cpanel backups, but I don't want to play around with those and risking my account to be suspended.

 

[Chris D]

It's likely to be an add on. Which add ons do you have installed?

 

[loplo]

I have a huge list of installed addons:
"Stay Logged In" checked by default 1.1
Add-on Install & Upgrade 1.2.2
CTA Table BB Code 1.1.1
Custom Field Rules by Waindigo 1.0.0
Custom Fields by Waindigo 2.1.1
Custom Tabs 1.4.0
Digital Point Ad Positioning 1.3.0
Digital Point Social Bar 1.0.2
Extra Node Information by Waindigo 1.0.1
Feeder by Waindigo 1.0.1
First Post Edit Time Limit 1.0.0
HX - Lock Thread Reason 1.0.5
Icewind Clone Node 1.0.3
Join User Group by Waindigo 1.2.0
Keyword Replace by Waindigo 1.0.3b
Nodes As Tabs 1.2.2
OpenGraph Image 1.2.0.0.1
Post Edit Reason by Waindigo 1.0.0
Prefix Forum Listing 1.2.4
Remove Members Tab 1.6
Reports by Waindigo 1.0.0
Restore Strikethrough In Editor 1.0.1
Similar Threads 4.2
Sitemap for XenForo 1.5.3
SoundCloud BBcode Media Site 1.8.3
Special Avatar for Banned Members 1.3.6
Start Conversation from Post Bit 1.3
Statistics 1.5
TaigaChat 0.5.5
Tapatalk 2.4.2
Threadmarks 1.1.5
Thumbnails by Waindigo 2.1.2
Today Birthdays 1.1
Unread Post Count 1.2.0
User Post Count in Threads by Waindigo 1.0.0
User Search by Waindigo 1.1.0a
User Upgrades by Waindigo 1.8.0
Warnings by Waindigo 1.1.7
Warnings Count by Waindigo 1.0.0
Watched Forums by Waindigo 1.0.2
Watched Thread Folders by Waindigo 1.0.1a
XenFacil's Widgets 2
[AD] UI.X 1.0.5 Patch 1
[BBM] BbCode Multimedia - Html5media 1.2.0
[bd] Anonymous Posting 2.2.0c
[bd] Rotating Ads 2.0
[bd] Widget Framework 2.5.9
[ITD] Add "All Post" and "All thread" by user in Member Card. 1.4.5
[Nobita] Style Permissions 1.0.6
[RainDD] User Activity 1.1.2
[RT] Online Status Ribbon 1.3.7
[WMTech] - Double Post Merge 1.3.0
[XenMods] Omnibox 1.0.0

As mentioned, I'd prefer reinstalling the whole forum, if there's a was to export and import the content.

 

[Chris D]

You could do a XF to XF import.

You'd clean reinstall XF in a separate directory into an empty database, and then use the importer to copy the data across. You would lose any data created by the add-ons. You would have to reinstall any add-ons and styles.

Really, though, it would be better to work out which one of these add-ons was causing the problem.

 

[Rob]

My guess is tapatalk but I'm negatively biased

 

[loplo]

For the record, my hosting company suspended my account but we agreed that I'm going to do a fresh reinstall of xenforo.
Reinstalling the modules and UI.X (antiquark) won't be a problem, but what about the first step, the "importer".

Question:
If I import my old database, is it going to import the just the forum structure, messages, conversations, permissions? or it will import everything, like information about resources, settings, etc?
It would be great if it'll import just the structure, messages, conversations and permissions.

 

[Paul B]

If you mean using the XF to XF importer, only the content listed is imported, nothing else.

 

[loplo]

Yes, xf to xf. Not even the users?

1.5 importer supports only xf 1.2/1.3/1.4? Only these are shown in the ACP dropdown.

 

[Rob]

If you choose 1.4 it should be ok but i may be wrong.

 

[loplo]

One issue though, when importing members/users, I'm being logged out and I'm not able to log back in, not with the fresh install user/pass NOR with the imported user/pass.
I have to mention, that I did not tick any of the boxes at the user merge option.

 

[Rob]

I would start over and document everything along the way, especially choices and decisions affecting accounts.
Good luck

 

[loplo]

Well, I'm at my 4th reinstall and import on my localhost.

 

[Rob]

4th? is that all? It took me a few dozen if I recall correctly when I migrated
haha, just kidding.

4 times? how come