Recent content by Sicilian

That's my feeling also, but could it be the server is being abused? Is there a section on this Forum to request paid services to have a look at the server setup?

Its almost as if PHP-FPM can't handle extra visitor generated by the mailshot. For example I've just enabled 'Under attack mode' in Cloudfare so that users have to verify they're human. Visitors have dropped from 200+ to under 100 and everthing is stable again.

Everytime we send a manual mailshot using DragonByte Mail for some strange reason we have to keep re-starting PHP-FPM service when though the server loads are low. We have to basically keep re-starting the service until eventually the forum stabilises again. If I close the Forum is all fine...

That looks like it may help. What would happen to email jobs on a mailshot? Would they still end up in xf_job? Will the server cron reduce the load?

Its not a huge busy forum anymore. These days we're lucky to get 10 posts a day.

As per my initial post, see below. Yes have full access to MySQL settings. Its our own dedicated 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

Yes but a similar thing is happening when sending out a mailshot. As soon as theres 1000's of jobs in xf_job my Forum slows dramatically or totally grinds to a halt.

So basically we can't send out mailshots due to this bug? As we end up with 1000's of jobs that basically kill the Forum.

Thats a bit over my head. What do we do, be paitent and let the jobs run though? Or do we have to start editing files? Which I'd prefer not to do. We have worse issues trying to send out a Digest with Dragonbyte mail. 1000's of jobs end up in xf_job and the forum becomes unusable. We have to...

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

I'm deleting the emails from xf_job, but keep getting added. I want to stop the complete mailshot, how is this done?

Where are emails that in the process of being sent stored in the database please?

As per the support ticket on your online store. I need to stop email that is in the process of being sent. I cannot find a table named xf_mail_queue. Can you please help? I need to stop an email that is in the process of being sent as this addon is just killing my forum. Forum is run on a...

As the title, does XF2.3 have a table named xf_mail_queue? I can't find this table in phpmyadmin.

Same error again today: XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '2-85869' for key 'rule_user' src/XF/Db/AbstractStatement.php:230 Stack trace INSERT INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?) ------------...