[imp] Upgrade from Horde 2 to 3, mysql performance problems.

[Mark Keller]

On Saturday 18 November 2006 00:11, Jacques Beaudoin wrote:
> Hi Mark,
>
> I did myself a upgrade and never had such a problem.
>
> Are you using php eaccelerator with horde ?
>
We don't have eaccelerator going yet. We also bumped to php5 during this 
upgrade and it seemed like we were having issues with eaccelerator/php5. We 
are still doing some testing, but might add it soon.

My understanding is that eaccelerator won't reduce the amount of mysql 
queries. I thought it just caches the php bytecode, but still executes it. 
Correct me if I am wrong. Our web servers seem to be doing fine. Although 
they do have a higher load than horde2/imp3.

> How may users do you have ?
>
Our total imp user base is around 20,000. Maybe 2000-3000 concurrently.

> How much ram in your mysql server ?
>
4GB. I have increased the innodb_buffer and query_cache quite a bit. We still 
have some free memory and no swapping.

> Are you using innodb ?
>
Yes innodb.

Is there some setting that keep the queries down? I mostly see 
horde_sessionhandler and horde_datatree queries. I tried setting datatree to 
the null driver, but that seemed to make things even slower.

Thanks,

Mark Keller

>
> ----- Message de mark at pdx.edu ---------
>      Date : Fri, 17 Nov 2006 22:37:16 -0800
>       De : Mark Keller <mark at pdx.edu>
> Répondre à : Mark Keller <mark at pdx.edu>
>   Objet : [imp] Upgrade from Horde 2 to 3, mysql performance problems.
>        À : imp at lists.horde.org
>
> > We just upgraded our installation from horde2/imp3 to horde3/imp4. We
> > went from ~4 million mysql queries a day to ~25 million. During peaks
> > times of the day the mysql server is totally bogged down, imp becomes
> > very slow and almost unusable. During slow times things are fine.
> >
> > Any idea on what might be the problem? Is the new version that much
> > more query
> > intense or did we just misconfigure something?
> >
> > We use horde/imp/turba/ingo (latest versions). We have 4 dedicated
> > web servers
> > (sunfire v20z/linux) and 1 dedicated mysql server (sunfire
> > v240/solaris/4GB RAM). We are running the disks from a SAN and I don't
> > see I/O bottlenecks. I have tuned the mysql server as much as I know how
> > and have not helped the problem much. We use mysql for session and prefs
> > for all modules.
> >
> > The load on mysql before the upgrade was ~1.5 during peak times and now
> > it is around 8-10.
> >
> > Any help would be appreciated, before the users torch down our offices ;)
> > Seems like my only two options now are buy a big huge server or roll back
> > to the horde2/imp3 versions.
> >
> > Thanks,
> >
> > Mark Keller
> > --
> > 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
>
> ----- Fin du message de mark at pdx.edu -----
>
>
> ----------------------------------------------------
> Ce message a été acheminé par le Webmail de la CSPI.