We are using James 2.2.08a and mySQL 4.0.13 with the 2.0.14 JDBC driver. We are using a pentium 2.4Ghz server with 1 GB. We also think that the problem might be with the db or the JDBC driver.
Thank you Sudip
From: Danny Angus <[EMAIL PROTECTED]> Reply-To: "James Users List" <[EMAIL PROTECTED]> To: "James Users List" <[EMAIL PROTECTED]> Subject: Re: SQL Exceptions Date: Tue, 14 Oct 2003 17:17:12 +0100
Sudip,
Tell us what version of james, what db, and what jdbc drivers you're using.. It looks (to me) more like a problem with your driver or db than with James, but it _might_ be a problem with the connection pool, either our hand-rolled one or dbcp depending which version of James..
PS I've found in general that few connections (about what you _really_ use) are often better than many, as they smooth out peaks of load, but I don't know if this is applicable to James as this relies on wait/notify being used by the pool to stall threads until connections are available, and if polling or exceptions are usedby the pool instead it might have the opposite effect!
d.
|---------+---------------------------->
| | "Sudip Shekhawat"|
| | <[EMAIL PROTECTED]|
| | l.com> |
| | |
| | 14/10/2003 03:54 |
| | PM |
| | Please respond to|
| | "James Users |
| | List" |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------|
| |
| To: [EMAIL PROTECTED] |
| cc: |
| Subject: SQL Exceptions |
>--------------------------------------------------------------------------------------------------------------|
Hi, We performed stress testing on James using postal for around 4000 messages/min. After 1hr and 15 mins, we got
java.sql.SQLException: Communication link failure: java.net.Socket Exception.
After receiving such exceptions, james stopped processing mails.
For this test the various parameters used were: 1. Number of spool threads = 10 2. Number of outgoing threads = 20 3. Max number of database connections to maildb = 60 4. Max number of database connections to mailrepository = 60 5. Connection manager timeout = 5 seconds
We also noted that if we had 20 spool threads and 20 outgoing threads then
james could process (accept, process, send mail ) around 400 mails/min. We
tried few more configurations of the number of spool/incoming threads such
as 30/30, but found that these gave errors like “broken pipe” or “server
timed out at read”. 20/20 gave the highest throughput, although we didn’t
run the 20/20 set for more than 20 mins.
We would appreciate if some of you could share your views on this matter.
Thank you Sudip
_________________________________________________________________ Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
***************************************************************************
The information in this e-mail is confidential and for use by the addressee(s) only. If you are not the intended recipient (or responsible for delivery of the message to the intended recipient) please notify us immediately on 0141 306 2050 and delete the message from your computer. You may not copy or forward it or use or disclose its contents to any other person. As Internet communications are capable of data corruption Student Loans Company Limited does not accept any responsibility for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice or opinions contained in an e-mail without obtaining written confirmation of it. Neither Student Loans Company Limited or the sender accepts any liability or responsibility for viruses as it is your responsibility to scan attachments (if any). Opinions and views expressed in this e-mail are those of the sender and may not reflect the opinions and views of The Student Loans Company Limited.
This footnote also confirms that this email message has been swept for the presence of computer viruses.
**************************************************************************
_________________________________________________________________
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
