Bulk mailing and mySQL db connectivity

Discussion in 'Site & Server Administration' started by dnk, Jan 20, 2008.

  1. #1
    I have a fairly large mailing list (8K+) and when I send a mail to the list subscribers, there is a problem connecting to the mySQL db of the forums. I have 2 different forums , one with phpBB and other with SMF , and I am facing a problem for both forums. The main sites are static html , and I have no problem accessing them. I am using a VPS at present. Other than upgrading servers, is there anything else I can do to prevent this problem?
     
    dnk, Jan 20, 2008 IP
  2. agnivo007

    agnivo007 Peon

    Messages:
    4,290
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can try using mysql persistent connections for the mailing program or increase max_connections for mysql.
     
    agnivo007, Jan 20, 2008 IP