vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - Send Mass Emails Using the Mailqueue System (https://vborg.vbsupport.ru/showthread.php?t=139779)

Abe1 07-19-2007 10:47 AM
Quote:
Originally Posted by LanciaStratos (Post 1295053)
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.

LanciaStratos 07-19-2007 02:15 PM
Ah, yes, I hadn't considered reducing the queue! What table do I need to lock?

Abe1 07-20-2007 01:34 AM
Quote:
Originally Posted by LanciaStratos (Post 1295716)
Ah, yes, I hadn't considered reducing the queue! What table do I need to lock?
Just the vb setting by the mail queue options.

BillP 09-06-2007 06:01 AM
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.

baby41 09-06-2007 09:12 PM
Quote:
Originally Posted by Abe1 (Post 1286819)
The the mail queue table in phpmyadmin.
I went to my phpAdmin but I didn't saw any table with that name,can you be more specific,regards.:confused:

Abe1 09-09-2007 08:34 PM
Quote:
Originally Posted by BillP (Post 1333370)
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.

Division 05-10-2008 05:34 PM
My Emails dont take 3 hours anymore stamped. Only 3 minutes to 30,000

PoetJA-1975 07-26-2008 03:21 AM
Thanx again for the share! Brilliant mod ABE

Jacquii.

gobears20 07-26-2008 08:47 PM
I just installed this and I have a few questions.

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.

PoetJA-1975 07-27-2008 12:29 AM
Quote:
Originally Posted by gobears20 (Post 1584835)
I just installed this and I have a few questions.

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.
It's specifically for the email users.

Jacquii.

Abe1 07-27-2008 06:44 AM
Quote:
Originally Posted by gobears20 (Post 1584835)
I just installed this and I have a few questions.

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.
Yes, this hack should help.

Welshy2008 08-07-2008 02:34 PM
Mine says "OK" and emails sent successfully - But no-one receives them. I have set it to "send to members that have selected "No Emails".

Any Ideas Please?

I have also changed the admincp / email.php file as told.

Abe1 08-08-2008 01:04 AM
Quote:
Originally Posted by Welshy2008 (Post 1593459)
Mine says "OK" and emails sent successfully - But no-one receives them. I have set it to "send to members that have selected "No Emails".

Any Ideas Please?

I have also changed the admincp / email.php file as told.
This show not effect the actual emails.

gobears20 08-10-2008 02:39 AM
I just want to let you know that this works really well! It is not only fast, it doesn't crash sql!

I have not had communication with my users in a whike, because the last time I sent an email to all users, it took a long time, but it ended up crashing sql. I have 13,640 members on my board. I only sent 50 at a time and it took less than seven minutes.

Thanks so mch for this!

Does anybody know of a fix for send a PM to all users? I have used this and it crashes sql also. Any idea on sending a PM to all users?

Welshy2008 08-13-2008 09:04 PM
It did work, just took a little time to get there. Tested again (only on one user addy) and it went straight through.

What I would like to know is what bbcode? - would I need to add to it to add the "Individual" username of the person that I send them too, Please?

Many Thanks,

Welshy2008

Welshy2008 08-27-2008 07:22 PM
Can anyone answer my post above please?

hdraye 07-24-2011 12:27 PM
would that still work with 4.xx?


All times are GMT. The time now is 08:55 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01089 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (17)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete