JWM wrote:
The problem is with mysql connection: fix that

I agree. But I don't know why it randomly exceeds the limit in the first
place, and I have no clue how to guarantee 100% that no matter what.. there
will NEVER be an overrun of the connection pool.  (Don't think it's possible
to guarantee 100%).

(Is there an easy way to log/track/plot connection usage in mySQL?)

Do you use the dbcp pooled datasources?

You can tune dbcp parameters (e.g: increase the <max> connections)

<data-source name="maildb" class="org.apache.james.util.dbcp.JdbcDataSource">
         <driver>com.mysql.jdbc.Driver</driver>
         <dburl>jdbc:mysql://127.0.0.1/mail?autoReconnect=true</dburl>
         <user>username</user>
         <password>password</password>
         <max>20</max>
      </data-source>


Stefano


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to