Hi Emmanuel, I've found out this option on MySQL Server. I need to make sure this option is correct one to turn on the persistent connection.
[MySQL] ; Allow or prevent persistent links. mysql.allow_persistent=On Also, I wonder how the maximum number of connections in MySQL Server affects to the general performance of Sequoia. I am using just the default number of connections in MySQL configuration file. Thanks a lot. 2009/2/24 Bogon Choi <[email protected]> > Hi Emmanuel, > No, I haven't heard about the persistent connection. Sorry. > Could you tell me how to turn on the persistent connection? Do I also need > to setup on Sequoia's configuration files? Or, just on MySQL Server? > > Thank you very much. > > > > > On Tue, Feb 24, 2009 at 7:58 AM, Emmanuel Cecchet <[email protected]>wrote: > >> Hi, >> >> Are you really using persistent connections? >> Is there any reason why you did leave the connection timeout in your >> MySQL server configuration? >> >> Thanks for your feedback, >> Emmanuel >> >> > I am running Sequoia 2.10.10 with distributed virtual databases across >> > two controllers; backends are MySQL 5.1.30. >> > The reason why I send this is that I could still see the same error >> > fixed in 2.10.5 from 2.10.10. >> > Is there any one who knows about this issue? Thanks very much in >> advance. >> > >> > >> > Stephane Giron closed SEQUOIA-855: >> > ---------------------------------- >> > >> > Resolution: Fixed >> > Fix Version: (was: Sequoia 2.10.5) >> > >> > (was: Sequoia 3.0 beta3) >> > sequoia 2.10.10 >> > >> > Fixed in 2.10 branch >> > >> > > Long idled persistent connections can see exceptions when sending a >> new >> > > request to MySQL >> > >> > > >> ---------------------------------------------------------------------------------------- >> > > >> > > Key: SEQUOIA-855 >> > > URL: https://forge.continuent.org/jira/browse/SEQUOIA-855 >> > >> > > Project: Sequoia >> > > Type: Bug >> > >> > > Components: Core >> > > Versions: Sequoia 3.0 beta1, Sequoia 2.10.2 >> > > Reporter: Stephane Giron >> > > Assignee: Stephane Giron >> > > Priority: Critical >> > >> > > Fix For: sequoia 2.10.10 >> > >> > > >> > > >> > > If a client gets a persistent connection to sequoia against MySQL (or >> other >> > > databases that drop connection after an idle timeout), and does not >> execute >> > >> > > queries against it for a long time, it will see an exception if the >> > > connection was closed by the underlying database. >> > > Trace of this kind of error : >> > > org.continuent.sequoia.common.exceptions.driver.DriverSQLException: >> Message >> > >> > > of cause: No enabled backend to execute request 5 >> > > at >> > > >> org.continuent.sequoia.driver.Connection.statementExecuteQuery(Connection.java:2849) >> > > at >> > > >> org.continuent.sequoia.driver.Statement.executeQuery(Statement.java:468) >> > >> > > at >> > > >> org.continuent.sequoia.driver.Statement.executeQuery(Statement.java:441) >> > > Caused by: >> > > >> org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException: >> > > No enabled backend to execute request 5 >> > >> > > SerializableStackTrace of each cause: >> > > >> org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException: >> > > No enabled backend to execute request 5 >> > > at >> > > >> org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:207) >> > >> > > at >> > > >> org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) >> > > at >> > > >> org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) >> > >> > > at >> > > >> org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:592) >> > > at >> > > >> org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1351) >> > >> > > at >> > > >> org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) >> > > at >> > > >> org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) >> > >> > > at >> > > >> org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) >> > > at >> > > >> org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) >> > >> > >> > >> > >> > >> > -- >> > 여호와는 네게 복을 주시고 너를 지키시기를 원하며 >> > 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 >> > 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 >> > (민수기 6:24-26) >> > ------------------------------------------------------------------------ >> > >> > _______________________________________________ >> > Sequoia mailing list >> > [email protected] >> > https://forge.continuent.org/mailman/listinfo/sequoia >> >> >> -- >> Emmanuel Cecchet >> FTO @ Frog Thinker >> Open Source Development & Consulting >> -- >> Web: http://www.frogthinker.org >> email: [email protected] >> Skype: emmanuel_cecchet >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> https://forge.continuent.org/mailman/listinfo/sequoia >> > > > > -- > 여호와는 네게 복을 주시고 너를 지키시기를 원하며 > 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 > 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 > (민수기 6:24-26) > -- 여호와는 네게 복을 주시고 너를 지키시기를 원하며 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 (민수기 6:24-26)
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
