atomikos连接池问题

2013-02-20 06:59:57 405 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Atomikos的性能问题 1. Atomikos事物管理与其Datasource二者不配合使用时，对性能有近一倍的影响，例如使用JTA事务管理而DS使用Atomikos配置 2. Atomikos 关闭事务日志 com.atomikos.icatch.max_actives=-1 com.atomikos.icatch.service=com.atomikos.icatch.stand 阅读详情

mysql会自动断开超过60秒的连接，而atomikos连接池没有检测机制去保持空闲的连接

造成连接池的连接超时掉了，以下是日志内容

com.mysql.jdbc.jdbc2.optional.MysqlXAException: Communications link failure

The last packet successfully received from the server was 157,969 milliseconds ago. The last packet sent successfully to the server was 3 milliseconds ago.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:498)
at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:59)
at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:65)
at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:88)
at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:179)
at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:208)
at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:142)
google下看到几个说修改mysql连接超时设置，我觉得mysql连接超时配置是不建议修改的，有没有更好的方式解决呢

...全文