Hmm. In this case I can come to one conclusion: 1: script runs and exit smoothly == connection closed nicely. 2: script timeout == connection will not closed as per script but the connection will run till the mysql query is completed?
If this is the case then I am in a better position to review my code and queries. Thanks for all the comments and input! Free Classifieds: http://www.ablewise.com/ On May 2, 11:28 pm, "Chris Hartjes" <[EMAIL PROTECTED]> wrote: > >On 5/2/07, GreyCells <[EMAIL PROTECTED]> wrote: > > > @Chris It appears connections are not always closed at end of script: > >http://uk2.php.net/mysql_connect(top comment) :) but cake seems to > > behave impecably. > > Well, that's not entirely true in terms of what the commenter said. > If you have a query that runs longer than the timeout for your PHP > page, I'd be willing to bet that MySQL will hang onto that connection > until it's finished with it. People often confuse a script timing out > with a script that finishes execution. > > I've run into this before at a previous job, on a database-intensive > site. MySQL was keeping connections open when a PHP script crashed > until it could clean up the connection itself. > > -- > Chris Hartjes > > My motto for 2007: "Just build it, damnit!" > > @TheBallpark -http://www.littlehart.net/attheballpark > @TheKeyboard -http://www.littlehart.net/atthekeyboard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---