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
Using around 50% cpu.
Any ideas why we are experiencing this issue? Surely these jobs should work their way through without using so much of the recources?
Forum is run on a dediciated server:
Brand DELL
Model Dell R210-II (2xLFF)
Processor 1x Intel Xeon E3-1230v2
RAM 16 GB
AlmaLinux v9.6.0 STANDARD standard
cPanel Version
126.0.16
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
/usr/sbin/mariadbd |
Using around 50% cpu.
Any ideas why we are experiencing this issue? Surely these jobs should work their way through without using so much of the recources?
Forum is run on a dediciated server:
Brand DELL
Model Dell R210-II (2xLFF)
Processor 1x Intel Xeon E3-1230v2
RAM 16 GB
AlmaLinux v9.6.0 STANDARD standard
cPanel Version
126.0.16