MySQL Forums :: General :: Changing wait_timeout

Advanced Search

Changing wait_timeout
Posted by: William Chipman ()
Date: February 05, 2008 01:53PM

We are running 4.1.11-Debian_4sarge7-log on a couple of our servers. The PHP applicaitons that interact with the databases use mysql_pconnect for maximum performance. However, if the apache thread is dropped, the MySQL connection thread is not dropped, so we end up with a lot of unused threads.
I would like to reduce the wait_timeout from 28800 (default) to 600.
However "set GLOBAL wait_timeout = 600" has not effect on the variable when I do a "show variables;" I have also put a new line in the my.cnf "wait_timeout = 600" and restarted mysql - change was also ignored.

Any ideas on how to change this variable?

Options: ReplyQuote

Subject Written By Posted
Changing wait_timeout William Chipman 02/05/2008 01:53PM
Re: Changing wait_timeout David Harris 02/25/2008 01:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.