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

[Mark Keller]

On Saturday 18 November 2006 03:15, Jan Schneider wrote:
> Zitat von Mark Keller <mark at pdx.edu>:
> >> 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.
>
> That doesn't make much sense, since you are probably experiencing
> scaling problems with the DataTree backend. Setting it to the null
> driver should *drastically* reduce your SQL load.
>

I was actually seeing short hangs from time to time. I have no idea if it was 
just coincidental, but soon as I set the datatree driver back to sql it 
stopped. Can you just turn off datatree in the middle of people using it 
without any problems or do all the current sessions need to be reset?

On my test server that no one is using turning off datatree seems to work 
fine. I didn't have problems until I turned it off on my production systems.

Thanks,

Mark Keller