vb.org Archive
Page 5 of 6 « First 34 5 6
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.


All times are GMT. The time now is 04:38 AM.
Page 5 of 6 « First 34 5 6
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.01130 seconds
  • Memory Usage 1,739KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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