schilly Posted November 4, 2010 Share Posted November 4, 2010 Where do these come from and how do they happen? Every now and then I seem to get a ton to the point where the db sometimes hits max connections. Any reasons for this? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/ Share on other sites More sharing options...
fenway Posted November 7, 2010 Share Posted November 7, 2010 Maybe your timeout is set too high? Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1131386 Share on other sites More sharing options...
schilly Posted December 7, 2010 Author Share Posted December 7, 2010 Ya I've lowered that to 5mins from 10mins. But how to do these connections just get left open sleeping? Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1143791 Share on other sites More sharing options...
fenway Posted December 8, 2010 Share Posted December 8, 2010 5 min? That's really high. Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1144489 Share on other sites More sharing options...
schilly Posted December 9, 2010 Author Share Posted December 9, 2010 What do you recommend? Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1144751 Share on other sites More sharing options...
fenway Posted December 9, 2010 Share Posted December 9, 2010 Well, timeouts are basically errors or sleeping connections -- 60 seconds should be more than sufficient. Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1145053 Share on other sites More sharing options...
schilly Posted December 9, 2010 Author Share Posted December 9, 2010 cool. thanks. Quote Link to comment https://forums.phpfreaks.com/topic/217792-sleeping-mysql-connections/#findComment-1145092 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.