Re: Persistent Database Connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, April 25, 2005 1:40 pm, Michael Phillipson said:
> What I am baffled by is the fact that the total nunber of connections
> between the web server and my database seems to max out at 9.  Why 9?

Either you never had more than 9 users at one time during your test, so
only 9 Apache children actually had to do any work, and the rest just laid
around doing nothing, or...

You may have configured Interbase (no idea how) to only allow 9
connections, or

The trial version of Interbase may limit you to 9 (or 10) connections.

If you also had, say, some kind of shell Interbase monitor program going,
or some kind of other application with a connection, that would have been
your 10th connection.

If this were MySQL, I'd tell you to look at your /etc/my.cnf file, or to
create one, and to make sure your limit on the number of connections is
*HIGHER* than the number of Children you allow in httpd.conf

Othewise, sooner or later, your server gets busy, and BAM! you've hit a
wal where Apache *wants* a MySQL connection, but MySQL won't give it one,
and your user gets some nasty error message about it, or, if you are
re-directing the errors, the page just plain doesn't work the way they
want, or...  Exactly what happens depends on your error settings and error
handling, and how good your code is at detecting error conditions.

You want the MySQL limit *HIGHER* than the Children, so that if all hell
breaks loose, *YOU* can use the mysql monitor from the shell command line
to log in and do admin tasks, yay even unto "mysqladmin -u root -p stop"

You don't want to get caught where your site is *SO* busy you can't even
get that to work. :-^

Interbase presumably has similar features, but I cannot say for certain.

-- 
Like Music?
http://l-i-e.com/artists.htm

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux