Re: Database connection reuse in Guts.pm

 
From: "Alex Judd" <alex@PROTECTED>
In-Reply-To: Re: Database connection reuse in Guts.pm
Date: January 19th 2009

Hi Justin

We're early adopters here so according to the code it's the first version of 3 0 :-)

$VERSION = 3 0 0; $VER = '3 0 0';

Can we just upgrade the Guts part or do you recommend a whole upgrade (and to which version???) :-)

Alex

On 01/19/2009 07:45 PM, Justin J wrote: >

On Jan 19, 2009, at 12:29 PM, Alex Judd wrote:

We are hitting some problems with the SQL backend on the new Dada 3 that it is maxing out our max_user_connections setting in mySQL as it appears to spawn child processes that don't reuse the DB connection that is created

Huh - what version of Dada Mail specifically is this? The newest version should always reuse the SQL connection, except when mass mailing, where it has to make one (1) more

Here's what Dada Mail uses to cache connections:

http://search
cpan
org/~timb/DBI-1
607/DBI
pm#connect_cached

There's a lot of code - even in the newish Dada Mails that use this, that attempt to cache the database connection itself Although it probably worked, it didn't work quite as well, and not all the time, so this is a pretty good replacement

rss/atom
‹ Re: Database connection reuse in Guts.pm
Index
Re: Database connection reuse in Guts.pm ›
  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)

  • Start a new thread, email: dadadev@dadamailproject.com

This is the developer discussion mailing list for Dada Mail.

If you are just looking for support Dada Mail, consult the message boards at:

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Topics that are welcome:

  • Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.