I'll add some better diagnostics... about 20 connections should be plenty except for very busy systems.
Jorge Bastos wrote: >>> Going to set max to 30 >>> >>> Here it is what happened with 20: >>> >>> Oct 30 12:05:33 lira dbmail/imap4d[21014]: [0x897eee0] Alert:[db] >>> db_con_get(+238): Thread is having trouble obtaining a database >> connection. >>> Try [25] >> Cool. Way to go Jon! > > > Tryed with 30, and then with 40, and now I'm with 60. > With 40 I had: (my mysql max connections are set to 1000 just in case) > > Oct 30 12:17:34 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [5] > Oct 30 12:17:34 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [5] > Oct 30 12:17:39 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [10] > Oct 30 12:17:39 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [10] > Oct 30 12:17:40 lira dbmail/imap4d[23512]: [0xb1a00700] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [5] > Oct 30 12:17:44 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [15] > Oct 30 12:17:44 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [15] > Oct 30 12:17:45 lira dbmail/imap4d[23512]: [0x8a270d8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [5] > Oct 30 12:17:45 lira dbmail/imap4d[23512]: [0xb1a00700] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [10] > Oct 30 12:17:45 lira dbmail/imap4d[23512]: [0x8e9b478] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [5] > Oct 30 12:17:49 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [20] > Oct 30 12:17:49 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [20] > Oct 30 12:17:50 lira dbmail/imap4d[23512]: [0x8a270d8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [10] > Oct 30 12:17:50 lira dbmail/imap4d[23512]: [0xb1a00700] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [15] > Oct 30 12:17:50 lira dbmail/imap4d[23512]: [0x8e9b478] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [10] > Oct 30 12:17:54 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [25] > Oct 30 12:17:54 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [25] > Oct 30 12:17:55 lira dbmail/imap4d[23512]: [0x8a270d8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [15] > Oct 30 12:17:55 lira dbmail/imap4d[23512]: [0xb1a00700] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [20] > Oct 30 12:17:55 lira dbmail/imap4d[23512]: [0x8e9b478] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [15] > Oct 30 12:17:59 lira dbmail/imap4d[23512]: [0x89e62a8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [30] > Oct 30 12:17:59 lira dbmail/imap4d[23512]: [0x8a20558] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [30] > > Message from [EMAIL PROTECTED] at Thu Oct 30 12:18:00 2008 ... > lira dbmail/imap4d[23512]: [0x89e62a8] EMERGENCY:[db] db_con_get(+241): > can't get a database connection from the pool! [(nil)] > Oct 30 12:18:00 lira dbmail/imap4d[23512]: [0x8a270d8] Alert:[db] > db_con_get(+238): Thread is having trouble obtaining a database connection. > Try [20] > Oct 30 12:18:00 lira dbmail/imap4d[23512]: [0x89e62a8] EMERGENCY:[db] > db_con_get(+241): can't get a database connection from the pool! [(nil)] > > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
