how to change timeout for mysql persistent connections

Question

Where is defined timeout of persistent connections? Is it possible to change it?

Related: [How to setup a connection timeout depending of the user login in MySQL](http://stackoverflow.com/q/243644/1288) — Bill the Lizard, May 15 '13 at 13:22

score 10 · Accepted Answer · answered Feb 09 '11 at 17:01

10

Check out the wait_timeout parameter for my.ini

answered Feb 09 '11 at 17:01

Marc B

i added wait_timeout=120 in my.cnf but still have same value as before (checked with select @@wait_timeout;) – user198003 Feb 09 '11 at 17:19
8

Also check interactive_timeout. – Mark Rose Feb 09 '11 at 17:26
@user198003: did you restart mysql after changing the value? There may be multiple my.ini's on your system - make sure you're changing the right one. – Marc B Feb 09 '11 at 17:33
1

sure i restarted it. but it was necessary to add interactive_timeout option, as mark rose mention. – user198003 Feb 09 '11 at 19:24

1 Answers1