On Tue, 14 Mar 2000, Nicolas Huillard wrote:
> Date: Tue, 14 Mar 2000 10:42:52 +0100
> From: Nicolas Huillard <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: [Mason] High load postgres-driven Web sites
>
> Have someone experience about high-load web sites, using Postgres/mod_perl-Mason ?
>
> The facts :
> * each Apache server has it's database connections (i'm using Mason, which is a
>mod_perl "application server")
> * the database can be on the same machine, or better, somewhere else
> * there may be several Apche machines using a single database
> * each connection to the database is a postgres process, using a fair amount of
>memory
> * if I host many sites, the database machine will have many * many database processes
> The questions :
> * how many database connections can be shared this way, on a typical machine
>(CPU/RAM)
In my situation (FreeBSD 3.4, 512 Mb Ram, Dual PIII, scsi) each backend
children has 3 persistent database connection, MaxClients 35.
We use postgres 6.5.3, Apache+modperl+Mason
Also we have 100 lightweight proxy - apache + mod_proxy
and single tine thttpd, which serves images. After 3 weeks we have
about 500,000 dynamical requests to backend, average load was about
0.03
> * is there a way to limit the number of database connections (transaction monitor,
>Apache::Session, reverse proxy, etc)
> * experience ?
Sure, use MaxClients for backend httpd and keep in mind the number of
different databases you work with. Total number of Postgres backends
is controlled by postmaster option -N XXX
Regards
Oleg
>
> Nicolas Huillard
>
>
> _______________________________________________
> Mason maillist - [EMAIL PROTECTED]
> http://netizen.com.au/mailman/listinfo/mason
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
