RSS Feed/News High CPU usage when jobs get added to XF_Job

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
27,875
Points
823

Reputation:

We recently moved from Vbulletin 4.2 to XF2.3.

We're having an issue that when a large amount of jobs get added to xf_job table we get high CPU usage.

If we try to send out a mailshot to all members the forum more or less grinds to a halt.

Today I decided to batch delete approx 66,500 inactive zero posters who haven't visited in 5 years or more. This has added 1000's of jobs to xf_job table.

The forum has slowed a lot and we're getting high CPU used by

...

Read more

Continue reading...
 
Status
Not open for further replies.
Top