So this evening, my intermittent problem became a consistent problem. I kept on getting the problem happening. So i checked CF administrator datasources. About 6-8 of my 30 datasources showed an error. I restarted CF and it just got worse... but was inconsistent. One minute this 10 was not working, next minute this 6.
So then the sysadmin and I dug a little deeper. The other clue i had was my MySQL client wouldn't connect at one stage... "too many connections" was the error. So we looked at connections to mySQL. The limit was set at 100 and there was more or less 100 all the time. So then it transpired that most of the connections (70 or more) were from one server, and the rest from the main CF server. The server that all the connections came from has one tiny CF ap running on it, and is being decommissioned as a CF server atm. Which brings me to my point.... The other aps on that server are PHP. And the dude who wrote them was setting up persistent db connections using a mysql_pconnect(), where he should maybe use mysql_connect(). I should add here that i know SFA about PHP. but anyway, there's the problem. PHP. I'm sorry i doubted you, brother CF. So, can anyone tell me about how db connections are pooled etc with CF? so it doesnt start doing the same thing? Cheers Gav --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
