[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Software updates
Just a FYI, the mod_perl scripts for the LBF and user
authentication/authorization are also persisten connections to the DB. So
basically:
# of httpd's on Yukon * (1 PHP + 1 ModPerl) = # mysqld's on Vodka
so 50 httpd's on Yukon = 100 mysqlds on Vodka
Houston, we have a problem. Vodka doesn't have the RAM to keep up with
Yukon in this configuration and be able to even begin to put any disk/DB
caching.
I know how we can cut the requirements almost in half for Vodka- do user
authentication / authorization in PHP instead of Perl. I assume from what
everyone has told me that this is possible, but you tell me. This would
also reduce the httpd memory footprint on Yukon by 50-75% (mod_perl is
fast as a bat out of hell but the tradeoff is it eats memory like a pig).
We could then run any scripts that require mod_perl on a dedicated set of
httpds (which since wouldn't get as many hits wouldn't need as many
instances). For example the LBF.
Anyone care to impliment http-auth against a SQL db in PHP? Wade?
Sporty?
--
Aaron Turner, Core Developer http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization http://linuxkb.org/
Because world domination requires quality open documentation.
On Fri, 29 Oct 1999, Jason Pincin wrote:
> I think all web instances EXCEPT for MAYBE admin should move to yukon
> anyway. When we go live, mysql WILL che memory like a hog. Probably
> every bit as much as Apache given the oppurtunity. Maybe more. There
> probably is a bug in the objects causing that. I havened combed the
> objects to insure proper DB connection closes, etc. yet. I will look into
> it when I get the chance, but it's not life threatening at the moment.
> Another point to note, is that I have set all PHP DB connections to be
> Persistent. So- DB connections will tend to hang around waiting for
> someone to use them. If the KB gets hammered, and 100 connections are
> established, and then usage drops way off, those 100 connections WILL
> stick around for a while before closing. This chews up memory but
> increases performance.
>
> Anyway - thanks for bringing my attention to it Aaron - and my vote is to
> bring Vodka up to 2.2.12 along with Yukon. There's really no downside
> that I see. If I'm wrong point it out.
>
> And I know I promised to upgrade those things a while ago. I will do it
> over the weekend. I appologize - it slipped my mind.
>
>
>
> JAson
>
>
> On Thu, Oct 28, 1999 at 09:23:35PM -0700, Aaron Turner wrote:
> >
> > VA has finally released (actually a few weeks ago) a more recent kernel
> > which has a lot of performance improvements for SMP/Apache boxes.
> > Anyways, this is a very much needed upgrade for Yukon if we'd like decent
> > http performance out of Yukon.
> >
> > Anyways, on the same note, anyone have an opinion on Vodka (single
> > PII-450)? Anyone know if MySQL will take advantage of a 2.2.x based
> > kernel on a single CPU system? VA included the lastest RAID patches with
> > 2.2.12 (yes I know 2.2.13 is out, but I haven't seen a reason to try to
> > use the VA patches on a 2.2.13 kernel).
> >
> > Anyways, I'll be planning the kernel upgrade on Yukon and possibly Vodka.
> > I'll give plenty of warning via email before I switch over- probably next
> > weekend. If anyone has any special needs/thoughts/concerns, now is the
> > time to voice them.
> >
> > Jason- what's the plan on upgrading phpMyAdmin & MySQL to the latest
> > versions? We're two rev's back on MySQL and one on phpMyAdmin. And while
> > I'm at it, why are there so many mysqld's running around? 52 last I
> > checked! At 4.7MB each (-1MB shared), that's 192.4MB, or 76% of the RAM
> > on Vodka. Basically, DB performance is going to really suck if we don't
> > fix this. If we can't/shouldn't limit the number of mysqld's spawning, we
> > should probably move all the different Apache instances to Yukon (admin,
> > dev, devel, tst) to make more RAM available for caching.
> >
> > --
> > Aaron Turner, Core Developer http://vodka.linuxkb.org/~aturner/
> > Linux Knowledge Base Organization http://linuxkb.org/
> > Because world domination requires quality open documentation.
>
> --
> Jason
> http://vodka.linuxkb.org/~chardros
>
--
Aaron Turner, Core Developer http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization http://linuxkb.org/
Because world domination requires quality open documentation.