php3-list | 199807

Re: [PHP3] The price of persistent connections From: Alex Belits (abelits <email protected>)
Date: 07/31/98

On Fri, 31 Jul 1998, Guoneng Zhong wrote:

> Hi,
> I am wondering if persistent connections to MySQL server will take up
> more memory. So is there a trade-off between memory and speed here? I
> experienced a MySQL memory out message on a database with 1400+ records.
>
> Any idea how to avoid or solve this problem? Thanks!

  Generally presistent connections only keep memory allocated for longer
time, and in servers that have symmetric processing model (such as in
Apache -- child processes can receive any request and every of them must
be able to process any kind of request) cause the increase of the number
of simultaneous connections to the database server. In asymmetric
processing model (such as in fhttpd -- child processes are specialized
and separate groups of them are used for some separate subsets of URLs)
number of connections to the database server is lower, and configuration
can separate all database-accessing scripts from others and define lower
number of simultaneously running processes for them, thus decreasing the
number of simultaneous connections to that number. In some cases it may be
desirable to decrease the number of simultaneous connections to one and
eliminate the need of locking in the database. 

--
Alex Belits, fhttpd author

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3