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

[Jacques Beaudoin]

Hi Mark,

I did myself a upgrade and never had such a problem.

Are you using php eaccelerator with horde ?

How may users do you have ?

How much ram in your mysql server ?

Are you using innodb ?

-- 
Best regards

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île


----- 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.