reduce mysql connections

2 posts / 0 new
Last post
#1 Fri, 09/18/2009 - 04:36
neorf

reduce mysql connections

How can i disable time a mysql is alive? The problem is that too many mysql connection make my system go down. System has 512 mb Ram. thanks

neorf

Fri, 09/18/2009 - 09:08
andreychek

Howdy,

Well, if the connections are active connections -- that is, if MySQL is doing something -- it could be an issue with the apps being run on your server. You may need to figure out what exactly they're doing and why it's taking so long.

However, you can certainly play with some of the timeout settings that MySQL offers. You can see a list of system variables here:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

You may want to look at "wait_timeout" and "connect_timeout", for starters.

-Eric

Topic locked