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. 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. 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 Link to comment https://forums.phpfreaks.com/topic/255061-too-many-mysql-connections/#findComment-1307872 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.