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
