[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Software updates
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