how to change timeout for mysql persistent connections

About

Asked 9/2, 2011 at 16:58 Answered 9/2, 2011 at 17:1

Solved mysql persistent-connection

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

Affixation answered 9/2, 2011 at 16:58 Comment(1)

Related: How to setup a connection timeout depending of the user login in MySQL – Matthus 15/5, 2013 at 13:22

Check out the wait_timeout parameter for my.ini

Vansickle answered 9/2, 2011 at 17:1 Comment(4)

i added wait_timeout=120 in my.cnf but still have same value as before (checked with select @@wait_timeout;) – Affixation 9/2, 2011 at 17:19

Also check interactive_timeout. – Sidneysidoma 9/2, 2011 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. – Vansickle 9/2, 2011 at 17:33

sure i restarted it. but it was necessary to add interactive_timeout option, as mark rose mention. – Affixation 9/2, 2011 at 19:24

Hot tags

Godot Unity Godot Help Programming Godot 4.X GUI GDScript 3D 2D Physics CSharp Godot 3.X VR XR Projects C++

Recommended topics

Hot tags