kengaun
|
Posted: 08/25/2003, 6:11 PM |
|
Noticed that from my winMySQLAdmin process panel, when I login to my
application there will be a new PID created to show that I have connected to
the database. But when I logout from my application, the PID still there
exists there - in sleep mode.
Question : I would like help or advise from any one is there a way how to
disconnect the PID from the database connection ? or this is the way ?
If the PID will not be disconnected, then it will have many many PIDs
hanging there.
I am using CCS 2,1 to develop my application. I am using php and MySQL.
|
|
|
Dave Rexel
|
Posted: 08/25/2003, 6:49 PM |
|
::
Use
unset $yourDBConnectionName;
This should only be an an issue in your Custom Code, CCS should in native
functions unset and thus release the connection object as specified in the
base library
Dave
"kengaun" <kengaun@fairchildsemi.com> wrote in message
news:biec49$sff$1@news.codecharge.com...
> Noticed that from my winMySQLAdmin process panel, when I login to my
> application there will be a new PID created to show that I have connected
to
> the database. But when I logout from my application, the PID still there
> exists there - in sleep mode.
>
> Question : I would like help or advise from any one is there a way how to
> disconnect the PID from the database connection ? or this is the way ?
> If the PID will not be disconnected, then it will have many many PIDs
> hanging there.
>
> I am using CCS 2,1 to develop my application. I am using php and MySQL.
>
>
>
|
|
|
kengaun
|
Posted: 08/25/2003, 11:02 PM |
|
I tried you suggestion. But the connection still there. Any other thing I
need to kill ?
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:bieeb6$vag$1@news.codecharge.com...
> ::
>
> Use
>
> unset $yourDBConnectionName;
>
> This should only be an an issue in your Custom Code, CCS should in native
> functions unset and thus release the connection object as specified in the
> base library
>
> Dave
>
> "kengaun" <kengaun@fairchildsemi.com> wrote in message
>news:biec49$sff$1@news.codecharge.com...
> > Noticed that from my winMySQLAdmin process panel, when I login to my
> > application there will be a new PID created to show that I have
connected
> to
> > the database. But when I logout from my application, the PID still there
> > exists there - in sleep mode.
> >
> > Question : I would like help or advise from any one is there a way how
to
> > disconnect the PID from the database connection ? or this is the way ?
> > If the PID will not be disconnected, then it will have many many PIDs
> > hanging there.
> >
> > I am using CCS 2,1 to develop my application. I am using php and MySQL.
> >
> >
> >
>
>
|
|
|
Walter Kempees
|
Posted: 08/26/2003, 1:34 AM |
|
Don't kill anything (Bhoedda said).
Grin.
The Pid will be automatically reused when the next connection (by you or any
other user) is made to the Db.
This is (specially in Linux world) a good thing, save the upstart of a
process.
You could always check if you are using a 'persistent'connection which will
keep it alive also.
Happy SQueeLing.
DeKemp
"kengaun" <kengaun@fairchildsemi.com> schreef in bericht
news:biet5h$i2d$1@news.codecharge.com...
> I tried you suggestion. But the connection still there. Any other thing I
> need to kill ?
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:bieeb6$vag$1@news.codecharge.com...
> > ::
> >
> > Use
> >
> > unset $yourDBConnectionName;
> >
> > This should only be an an issue in your Custom Code, CCS should in
native
> > functions unset and thus release the connection object as specified in
the
> > base library
> >
> > Dave
> >
> > "kengaun" <kengaun@fairchildsemi.com> wrote in message
> >news:biec49$sff$1@news.codecharge.com...
> > > Noticed that from my winMySQLAdmin process panel, when I login to my
> > > application there will be a new PID created to show that I have
> connected
> > to
> > > the database. But when I logout from my application, the PID still
there
> > > exists there - in sleep mode.
> > >
> > > Question : I would like help or advise from any one is there a way how
> to
> > > disconnect the PID from the database connection ? or this is the way ?
> > > If the PID will not be disconnected, then it will have many many PIDs
> > > hanging there.
> > >
> > > I am using CCS 2,1 to develop my application. I am using php and
MySQL.
> > >
> > >
> > >
> >
> >
>
>
|
|
|
Oung Keng Aun
|
Posted: 08/28/2003, 8:03 PM |
|
Hi ALL,
If I uncheck the Persistence Conncetion in CodeCharge Setting, the PID will
not show up.
Thanks for your advise.
"Walter Kempees" <kempe819@planet.nl> wrote in message
news:bif63d$tva$1@news.codecharge.com...
> Don't kill anything (Bhoedda said).
> Grin.
> The Pid will be automatically reused when the next connection (by you or
any
> other user) is made to the Db.
> This is (specially in Linux world) a good thing, save the upstart of a
> process.
> You could always check if you are using a 'persistent'connection which
will
> keep it alive also.
> Happy SQueeLing.
>
> DeKemp
>
> "kengaun" <kengaun@fairchildsemi.com> schreef in bericht
>news:biet5h$i2d$1@news.codecharge.com...
> > I tried you suggestion. But the connection still there. Any other thing
I
> > need to kill ?
> >
> > "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
> >news:bieeb6$vag$1@news.codecharge.com...
> > > ::
> > >
> > > Use
> > >
> > > unset $yourDBConnectionName;
> > >
> > > This should only be an an issue in your Custom Code, CCS should in
> native
> > > functions unset and thus release the connection object as specified in
> the
> > > base library
> > >
> > > Dave
> > >
> > > "kengaun" <kengaun@fairchildsemi.com> wrote in message
> > >news:biec49$sff$1@news.codecharge.com...
> > > > Noticed that from my winMySQLAdmin process panel, when I login to my
> > > > application there will be a new PID created to show that I have
> > connected
> > > to
> > > > the database. But when I logout from my application, the PID still
> there
> > > > exists there - in sleep mode.
> > > >
> > > > Question : I would like help or advise from any one is there a way
how
> > to
> > > > disconnect the PID from the database connection ? or this is the way
?
> > > > If the PID will not be disconnected, then it will have many many
PIDs
> > > > hanging there.
> > > >
> > > > I am using CCS 2,1 to develop my application. I am using php and
> MySQL.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|