Version: 1.0, by Abe1
Developer Last Online: Jun 2010
Category: Administrative and Maintenance Tools -
Version: 3.6.8
Rating:
Released: 02-17-2007
Last Update: Never
Installs: 68
Code Changes
No support by the author.
Send Mass Emails Using the Mailqueue System 1.0
I recently changed where I send emails for my forum from. I had been using by server and now switched to an outside place. I found that sending a mass email would take FOREVER since it would take a few seconds per email it had to send out.
I had my vb setting of "Use Mailqueue System" set to 'Yes' but I realized it was NOT using the queue.
I found the way to enable the queue and sending mass emails takes me just a few seconds now! (This hack makes sending emails from your own server much faster also.)
This hack enables the vb queue only if you have 'Use Mailqueue System' turned on. Sending mass emails will take you a few seconds instead of minutes of hours!
Unfortunately, I can't really say that I recommend this. I'm on a dual Xeon dedicated server with a very large forum (around 98,000 members, 66,700 of which have opted to receive my messages), and this brought my server to a crawl. Server loads spiked to 120+ only seconds after sending a few thousand messages. This may work great for smaller boards, but it looks like us larger forum owners are still going to be left to find other email solutions on our own.
Check how many emails get sent at once using the queue. Set it to a very low number. Also, try locking the table.
I am trying this on a large board (90K users), and it's taking forever for each screen to finish sending to the mailqueue. I tried 500 users per time, and it took a minute or more for the 500, and then you have to hit "next" so I was looking at a couple of hours of this.
So I stopped, upped it to 10K users per pass, and now it's just taking several minutes for each 10K pass.
On the outbound side, server load is very high, so I have reduced it to process 3 on each mailqueue pass, that seems to help a little. But the site is at a crawl. We have 2 web servers and a mysql slave setup, if it matters.
I am trying this on a large board (90K users), and it's taking forever for each screen to finish sending to the mailqueue. I tried 500 users per time, and it took a minute or more for the 500, and then you have to hit "next" so I was looking at a couple of hours of this.
So I stopped, upped it to 10K users per pass, and now it's just taking several minutes for each 10K pass.
On the outbound side, server load is very high, so I have reduced it to process 3 on each mailqueue pass, that seems to help a little. But the site is at a crawl. We have 2 web servers and a mysql slave setup, if it matters.
Then it must take a long time to connect to your mail server.
Does this have to do with going into your AdminCp and going to Users>Send Email to Users? If it does, one of my big problems that I have had is that I have 13,600 members and when I would try to send an email to them, it would time out after a while and I would have to re-boot my server. Does this hack work well with emailing all of your users? It would be really nice because I have not been able to send out a mass email to them ina while.
Does this have to do with going into your AdminCp and going to Users>Send Email to Users? If it does, one of my big problems that I have had is that I have 13,600 members and when I would try to send an email to them, it would time out after a while and I would have to re-boot my server. Does this hack work well with emailing all of your users? It would be really nice because I have not been able to send out a mass email to them ina while.