The only reason it uses two is if the code using persistent connections
connects with different credentials.  ie. you have 2 different apps on the
same server that connects as 2 different user ids and they are both using
persistent connections.  Eventually every httpd will have 2 connections.

-R

On Tue, 30 Jul 2002, Andrey Hristov wrote:

>   Hello,
> last week I read this article :
> http://phplens.com/lens/php-book/optimizing-debugging-php.php
> It is long one. Extract from it (look where is it and read around it):
> [snip]
> Overload on 40 connections
>
> When we pushed the benchmark to use 40 connections, the server overloaded
> with 35% failed requests. On further investigation, it was because the MySQL
> server persistent connects were failing because of "Too Many Connections".
>
> The benchmark also demonstrates the lingering behavior of Apache child
> processes. Each PHP script uses 2 persistent connections, so at 40
> connections, we should only be using at most 80 persistent connections, well
> below the default MySQL max_connections of 100. However Apache idle child
> processes are not assigned immediately to new requests due to latencies,
> keep-alives and other technical reasons; these lingering child processes
> held the remaining 20+ persistent connections that were "the straws that
> broke the Camel's back".
>
> The Fix
>
> By switching to non-persistent database connections, we were able to fix
> this problem and obtained a result of 5.340 seconds. An alternative solution
> would have been to increase the MySQL max_connections parameter from the
> default of 100.
>
> [/snip]
>
> Andrey
>
> ----- Original Message -----
> From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
> To: "Andrey Hristov" <[EMAIL PROTECTED]>
> Cc: "Paul Worthington" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, July 30, 2002 7:59 PM
> Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
>
>
> > What do you mean it uses 2?  It does not.
> >
> > On Tue, 30 Jul 2002, Andrey Hristov wrote:
> >
> > > Maybe it will help you but I've read that when using persistent
> connections
> > > PHP uses 2 on every request.
> > > So if in one moment you have 10 scripts,that use persistent connections,
> > > running you will have 20 connections used to the mysql.
> > >
> > > Regards,
> > > Andrey
> > > ----- Original Message -----
> > > From: "Paul Worthington" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Tuesday, July 30, 2002 5:34 PM
> > > Subject: [PHP-DB] mysql_fetch_array limit? - more details
> > >
> > >
> > > > I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5.
> > > >
> > > > In my table, I've got two fields: Name VARCHAR(35) and txtSWDesc1
> TEXT.
> > > > According to the manual, TEXT will give me a maximum space of 65,536
> > > > bytes per field. I've entered text in this field in the amount of
> > > > approximately
> > > > 500 characters.
> > > >
> > > > I'm using this PHP code, very simple and straightforward, to select
> two
> > > > columns into an array and then display the results in an HTML table:
> > > >
> > >
> ............................................................................
> > > > ..................................
> > > > $db = mysql_connect("localhost", "user1");
> > > > mysql_select_db("testdb",$db);
> > > > $sql = "SELECT * FROM tmp ORDER BY Name";
> > > > $result = mysql_query($sql,$db);
> > > >
> > > > echo "<TABLE>\n";
> > > > echo "<TR>\n<TH>Place Name</TH>\n<TH>Description</TH>\n</TR>\n";
> > > > while ($myrow = mysql_fetch_array($result)) {
> > > >   printf("<TR><TD>%s</TD><TD>%s</TD></TR>\n", $myrow[Name],
> > > > $myrow[txtSWDesc1]);
> > > > }
> > > > echo "</TABLE>\n";
> > > >
> > >
> ............................................................................
> > > > ...............................
> > > > What happens is I'm only getting the first 256 characters of
> txtSWDesc1
> > > > displayed in my table. I am assuming the problem is in
> > > > mysql_fetch_array(), that it must have some size limitation that
> > > > truncates whatever data it has read to exactly 256 chars. Another
> > > > possibility is that the mysql_query() could be truncing the result.
> I've
> > > > checked my data directly in MySQL, and all the characters are there in
> > > > direct SELECTs.
> > > >
> > > > Can someone please help? I've checked all manuals and FAQs I can, but
> I
> > > > can't figure out why I'm having this problem. It should not be
> happening
> > > > at all. Is there some size limitation to the array created via
> > > > mysql_fetch_array()? Is there some other function that will accomodate
> > > > my data? Is there any custom code to handle my data correctly?
> > > >
> > > > Thanks,
> > > > Paul Worthington
> > > > [EMAIL PROTECTED]
> > > >
> > > >
> > > > --
> > > > The views expressed here are those of the user, not necessarily those
> of
> > > > Evolving Systems, Inc.
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to