Can it be done?

I tried to disable this timer with wait_timeout = 0 in my.cnf.

That changed the timeout (as reported by mysqladmin variables) from the
default 28800 to 1.  Tested, it was definitely a one-second timeout :-(

As a hack-around, I've currently got it set to ten days.

Alternatively, where is the bounds for the value of wait_timeout
documented?

Lastly, this is for a long-held JDBC connection from an application server
which could run for days, no, weeks - and gets upset if mysql closes down
the connection (e.g. overnight/weekends). Any suggestions on a better way
to handle this?

Thanks,
Neale.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to