richiejones24 Posted January 15, 2012 Share Posted January 15, 2012 On my new site on average every page that loads opens 9 MySql connections and runs 14 MySql Queries, And as I use Ajax to dynamically update the pages, so this repeats every 60 seconds per page. Is this too many connections? I am not having any problems at the moment but the site is getting more busy, and I don't want the site to start running slow, or the MySql server to crash. Any comment would be much appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/255061-too-many-mysql-connections/ Share on other sites More sharing options...
trq Posted January 15, 2012 Share Posted January 15, 2012 Why are you opening multiple connections? A single connection would be better, but 14 queries is nothing. Quote Link to comment https://forums.phpfreaks.com/topic/255061-too-many-mysql-connections/#findComment-1307847 Share on other sites More sharing options...
robert_gsfame Posted January 15, 2012 Share Posted January 15, 2012 don't forget to close your connection after being executed then Quote Link to comment https://forums.phpfreaks.com/topic/255061-too-many-mysql-connections/#findComment-1307872 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.