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 m
>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 qu
Hmmm. I thought the article answered the question 'why do I have so
many Threads_created?' perfectly - and how to fix it (if indeed, it
needs fixing), because Threads_created has nothing to do with cake
hanging on to connections (or not).
Threads_created is the number of times mysql has had to cr
Thanks Chris. I do understand php closes connections when a script
finish after you said so and I did some research.
Now for the second question:
The connections in cakephp are pass by reference. Will that result in
some sleeping connections?
On May 2, 10:08 pm, "Chris Hartjes" <[EMAIL PROTECTED
On 5/2/07, redhex <[EMAIL PROTECTED]> wrote:
> My question here is this:
> Does cakephp close all connection when the script finish running?
> Current I am using mysql_connect.
>
As far as I know, PHP does this for you automatically when a script
finishes executing. Not a CakePHP issue at all.
GaryCells:
My questions was not to know about what those number means or to know
more about mysql status. This is a cakephp forum and hence I am asking
does cakephp closes connections when the script dies.
So any other takers?
Question again:
Does cakephp close all connection when the script fin
Google is your friend:
http://www.google.co.uk/search?q=mysql+threads_created
First hit:
http://jeremy.zawodny.com/blog/archives/000173.html
...might help.
~GreyCells
On May 2, 7:21 am, redhex <[EMAIL PROTECTED]> wrote:
> Hi all,
> I am doing monitoring for my site which is cake based and f
Hi all,
I am doing monitoring for my site which is cake based and found the
following:
mysql "show global status"
[158] Threads_cached 5
[159] Threads_connected 3
[160] Threads_created 1098
[161] Threads_running 2
I am concern with the threads_created count. I guess it is a little on
th