CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Connections to MYSql never close

Print topic Send  topic

Author Message
Drazen
Posted: 02/24/2004, 12:37 AM

Applications generated with CCStudio in PHP/MySql makes connections to MySql active forever.
What I am doing wrong?

johny_f

Posts: 23
Posted: 02/24/2004, 4:21 AM

- Go menu: Project/Settings
- then click on tab Connection and modify connection e.g. called "fs".
- uncheck "persistent connection"

Johny_f
_________________
Johny_f
View profile  Send private message
Mate
Posted: 02/24/2004, 5:18 AM

Thank you Johny
I got same help directly from CodeCharge support
It works, however not eaxctly that way.
In dialog tab 'Server Persisten' found uncheked already, while in db
Properties window (data tab), same parameter where set to 'Yes'.
Switched this to 'No' , makes no remaining processe/connections at the MySql
server anymore.
Checked twice.

Regards,
Drazen



"johny_f" <johny_f@forum.codecharge> wrote in message
news:5403b41d624745@news.codecharge.com...
> - Go menu: Project/Settings
> - then click on tab Connection and modify connection e.g. called "fs".
> - uncheck "persistent connection"
>
> Johny_f
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

DonB
Posted: 02/24/2004, 6:27 AM

Have you determined this to be a bad thing or just assumed that it was?
Quoting the PHP.NET discussion about persistent connections:

"Due to the nature of persistent connections, biggest benefit by using them
can be achieved over slow network connections and with a few quick queries
per connection. If you have complex queries, which take long time to execute
or more than 3-5 queries per connection, persistent connections will give
you almost no benefit."

http://www.mysql.com/newsletter/2002-11/a0000000086.html

Like most configuration options, there are good effects and bad effects.
It's important to understand the "why" of persistence before you change it.

--
DonB

http://www.gotodon.com/ccbth


"Drazen" <Drazen@forum.codecharge> wrote in message
news:5403b0d3fcd0c3@news.codecharge.com...
> Applications generated with CCStudio in PHP/MySql makes connections to
MySql active forever.
> What I am doing wrong?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

mateo
Posted: 02/24/2004, 12:03 PM

Thank you for your point. Don.
I am running this on fast local network. This is Netware server which can
handle hundreds connections easily. Afraid Mysql server can't. Specially
when many wasted resourses due to unusefull processes. Also, overloaded
mysql, react negative to overall server perfomances.

After reading the whole article I can understand that whole idea with
persistent connections has no benefits at all.
Take a look at your quoted part again.
If main benefit comes with few short queries per conections, I don't see any
sense here. Short query is short query. It is finished quickly. Clever OS
can handle thousands of those easily.
There are to many warnings about using persistent connection in that
article. Guess that this idea needs a lot of hard work yet.
Whole story runs much faster with persistent conn. off
This is what I need now.

Tanks again
Drazen

"DonB" <~ccbth~@gotodon.com> wrote in message
news:c1fmvl$7fd$1@news.codecharge.com...
> Have you determined this to be a bad thing or just assumed that it was?
> Quoting the PHP.NET discussion about persistent connections:
>
> "Due to the nature of persistent connections, biggest benefit by using
them
> can be achieved over slow network connections and with a few quick queries
> per connection. If you have complex queries, which take long time to
execute
> or more than 3-5 queries per connection, persistent connections will give
> you almost no benefit."
>
> http://www.mysql.com/newsletter/2002-11/a0000000086.html
>
> Like most configuration options, there are good effects and bad effects.
> It's important to understand the "why" of persistence before you change
it.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Drazen" <Drazen@forum.codecharge> wrote in message
>news:5403b0d3fcd0c3@news.codecharge.com...
> > Applications generated with CCStudio in PHP/MySql makes connections to
> MySql active forever.
> > What I am doing wrong?
> >
> >
> > ---------------------------------------
> > Sent from YesSoftware forum
> > http://forums.codecharge.com/
> >
>
>

RonB

Posts: 228
Posted: 02/26/2004, 2:09 AM

This is not a mysql problem but a windows problem/and I believe apache on windows with threads. Every child proces is seen as being new so an existing connection is not being re-used. This leaves a lot of idle connections sleeping around :-) and can acumulate to a lot of "users" that are still connected to the database. Under Linux persistent connections to mysql work like a charm and actualy save resources.
View profile  Send private message
Mate
Posted: 02/26/2004, 9:03 AM


"RonB" <RonB@forum.codecharge> wrote in message
news:5403dc5ea0199b@news.codecharge.com...
> This is not a mysql problem but a windows problem/and I believe apache on
windows with threads. Every child proces is seen as being new so an
existing connection is not being re-used. This leaves a lot of idle
connections sleeping around :-) and can acumulate to a lot of "users" that
are still connected to the database. Under Linux persistent connections to
mysql work like a charm and actualy save resources.
> ---------------------------------------

Exactly what I had.... except,
Funny thing is that when I am running AMP on windows (XP) no remaining
sleeping processes at all.
This issue happened with Apache/MySQL/PHP at the Netware (NW6) server.
Guess I should investigate more detailed setting up MySQL with Netware.
Could be PHP setting as well.
I just can't help myself. I am adicted with Netware so much.

Never mind,
lets go on with more important work.
Drazen


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.