[imp] upgrade from IMP3 -> IMP4 : serious performance hit

[Timothy Spear]

Chris,
	Have you tried the standard MySQL tuning? Such as memory, cache,
lock settings, slow-queries? I have found MySQL to be very CPU abusive if
forced into full table scans (I never did figure out why). 
	Lastly, in my very limited testing, I found InnoDB for the core
Horde tables and MEMORY storage type for the session tables to be much
faster. (I am doing this as part of setting up a new system to replace
SquirrelMail.)

Good luck,

Tim

-----Original Message-----
From: imp-bounces at lists.horde.org [mailto:imp-bounces at lists.horde.org] On
Behalf Of Chris J. Alexander
Sent: Wednesday, July 20, 2005 9:34 AM
To: imp at lists.horde.org
Subject: Re: [imp] upgrade from IMP3 -> IMP4 : serious performance hit

Just to keep the list updated - we configured two additional Sun v240
servers
this morning into our production mix, and are monitoring to see how this
will
help performance.  So far so good - thanks to all who offered suggestions
and
moral support (both equally important!)

CJA
Quoting "Chris J. Alexander" <cjalexa at emory.edu>:

> The only two that I had enabled were
>
> $conf['mailbox']['show_attachments'] & $conf['mailbox']['show_xpriority']
>
> which I have now disabled.  The load is still climbing though.
>
> Is the new Horde/IMP much more DB intensive?  Perhaps I need to focus on
the
> MySQL installation?  That process seems very 'hot' now, much more so than
> before.  But if the app needs that extra DB interaction, there isn't 
> much I can
> do beyond throw hardware at the problem.  Is there a quick'n'dirty way to
> profile what's eating all my CPU?  I've tried truss'ing the processes but
> gleaned nothing helpful.  Error logging is turned up, but not 
> revealing anything
> to me either.
>
> I am using the Horde VFS with the MySQL DB on the one server, but 
> again that was
> being used before as well.  I tried very hard to make sure the *only* 
> change was
> the upgrade from IMP 3 -> IMP 4.
>
> There are a total of 4000 sessions in the DB split among the two 
> Solaris boxes -
> these are v280R's w/ 4 GB of RAM, that should be plenty of headroom, 
> shouldn't
> it?
>
> Thank you for continued help :)
>
> CJA
>
> ----- Original Message -----
> From: "Jan Schneider" <jan at horde.org>
> To: <imp at lists.horde.org>
> Sent: Tuesday, July 19, 2005 11:38 AM
> Subject: Re: [imp] upgrade from IMP3 -> IMP4 : serious performance hit
>
>
>> Zitat von "Chris J. Alexander" <cjalexa at emory.edu>:
>>
>>
>>> Is this just a symptom that I need much much larger hardware to run the
new
>>> version of Horde for my installation?  My higher ups are screaming at
>>> me every
>>> hour to do something about it; I don't want to downrev if I can help
>>> it, but I
>>> may not have a choice since I can't produce new hardware that fast.
>>
>> It's a fact that Horde 3/IMP 4 need more power than Horde 2/IMP 3, but
>> not *that* much more. Did you try disabling all perfomance hungry
>> configuration settings in IMP?
>>
>> Jan.
>>
>> --
>> Do you need professional PHP or Horde consulting?
>> http://horde.org/consulting/
>>
>> --
>> IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>>
>
> --
> IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>



-- 
Chris J. Alexander
404-727-8333/FAX:404-727-0817

-- 
IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe at lists.horde.org