XenForo High CPU usage when jobs get added to XF_Job

S

Sicilian

Guest
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...