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

[Michael M Slusarz]

Quoting Myke Place <mp at xmission.com>:

> Chris J. Alexander wrote:
>
>> 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
>>>
>>>
>>>
>>
>>
>>
> For what it's worth, we have also experienced significant load increases
> in moving from 3->4, even with the bells and whistles disabled. CPU load
> is very heavy, even on a beefy box. More than 5 times what it was
> previously (on a good day).
>
> One thing that I've only had a few moments to look at is APD. I can't
> really advocate it, having hardly used it, but if anybody wants to spend
> some real time with it and post their results, I'm guessing that I
> wouldn't be the only person interested:
>
> http://www.linuxjournal.com/article/7213
>
> If you're spending that much time in MySQL wait, my untested assumption
> is that APD will reveal it.

Whenever Horde 3.1 comes out, you will also have the advantage of 
registry caching.  See:
http://marc.theaimsgroup.com/?l=horde-dev&m=111170257206554&w=2

michael

_______________________________________
Michael Slusarz [slusarz at curecanti.org]