configuring inactivity timeout!

[Marlene]

hi guys, I am migrating a system from version 3 of MySQL to version 5. but there is a problem, that is the default innactivity timeout is eight hours, after which time the connection to the client application is dropped.

The system requires a persistent connection. I have tried configuring the wait_timeout variable to be 0 or -1 in the my.cnf file, but either of these settings causes the connection to be immediately dropped, as opposed to never being dropped. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

It's impossible to set it to infinity, however you can set it up to one year in duration. Just set wait_timeout to a really large number and it will go to one year's time. . -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --