php - MySQL Sleeping Threads Eating up all my Connections -
php - MySQL Sleeping Threads Eating up all my Connections - i've been continually getting "too many connections" errors on site uses php , mysql. in looking @ info mytop (show processlist), find of these connections sleeping ones. tried setting mysql settings interactive_timeout , wait_timeout 120 seconds processes still somehow sleeping longer that. php max_execution_time set 30 seconds why script maintain mysql connection open more 30 seconds? not explicitly calling mysql_close in of scripts , i'm not using pconnect. have suggestions or advice on need or at? give thanks you! try adding explicit mysql_close($conn) or relevant function particular driver scripts you're using see if it's php failing kill connections. php mysql connections