Date: Wed, 3 Nov 2004 17:00:35 -0400 (AST)
From: "Marc G. Fournier" <scrappy@postgresql.org>
To: Mitch Pirtle <mitch.pirtle@gmail.com>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>,
	Dave Page <dpage@vale-housing.co.uk>,
	Alexey Borzov <borz_off@cs.msu.su>, Oleg Bartunov <oleg@sai.msu.su>,
	pgsql-www@postgresql.org
Subject: Re: Inadequate hosting for www.postgresql.org
In-Reply-To: <330532b60411031252353b083b@mail.gmail.com>
Message-ID: <20041103165954.J82047@ganymede.hub.org>
References: 
 <E7F85A1B5FF8D44C8A1AF6885BC9A0E4306FB9@ratbert.vale-housing.co.uk>
	<20041103132338.M82047@ganymede.hub.org>
	<330532b60411031252353b083b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Wed, 3 Nov 2004, Mitch Pirtle wrote:

> On Wed, 3 Nov 2004 13:31:23 -0400 (AST), Marc G. Fournier
> <scrappy@postgresql.org> wrote:
>> Now, to any PHP gurus that might be out there ... FreeBSD ports recently
>> went to an 'extensions' format for php ... so, you build apache, you add
>> in mod_php4, and then for the various extensions you want, you have a
>> /usr/local/etc/php/extensions.ini file that you enable/disable in ... when
>> Apache forks off a new Child process, is it loading all of those up again,
>> each time?  Or, even better, does it only load up the PHP stuff when a
>> pages calls for it?  ie. a .html wouldn't load in the mod_php, but a .php
>> would have to load it all up before it could run?  Would that load time be
>> the 'lag' we're seeing?
>
> Not with turck-mmcache going.  Turck loads every PHP script once,
> parses and compiles it to opcode, and then waits for requests, so I
> cannot see how PHP scripts could incur a significant overhead if they
> were really being cached.  I would suggest two things:
>
> 1) looking at apache's minimum number of processes (less forking after
> a restart)

running 15/30 for min/max right now ...

> 2) seeing if mmcache is really configured properly - this can be done
> by copying mmcache.php from the mmcache distribution files to
> somewhere in your document root, and loading it in your browser.  This
> will show you how many files are cached, how many hits, and how many
> reloads.

check out http://www.postgresql.org/mmc/mmcache.php ... also, 
http://www.postgresql.org/phpinfo.php ... if you can suggest any changes, 
please feel free to do so ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664