See http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html and http://dev.mysql.com/doc/refman/4.1/en/using-system-variables.html for explinations of the options below.
in /etc/my.cnf you can add this... # 3 day timeout in seconds [mysqld] wait_timeout=259200 interactive_timeout=259200 The default value for wait_timeout is 28800 which is 8 hours. wait_timeout is for connections from TCP/IP. Hope this helps, --Jim ------------------------------------ http://www.mscoast.com/ On 8/31/06, Richard Mixon <[EMAIL PROTECTED]> wrote:
I just found where there is an issue opened for this: http://trac.edgewall.org/ticket/3645 Does anybody have a workaround/patch for now? ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Mixon Sent: Wednesday, August 30, 2006 4:18 PM To: [email protected] Subject: [Trac] MySQL timeout - how to set parameters for this? We have been successfully using the MySQL support in the trunk - with one exception. Anytime there is not activity for about 8 hours, it seems the MySQL connection has timed out. If I restart Apache everything works fine. Under Java I would set the JDBC connection URL such as: jdbc:mysql://localhost:3306/tracDB?autoReconnect=true So I tried database = mysql://tracUser:[EMAIL PROTECTED]/tracdb?autoReconnect=true But this does not seem to help. How can this be fixed? Thanks in advance - Richard _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
_______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
