[imp] my experience

[Jose R. Roca]

Kevin, what is your current setup? What is your average concurrent users
like? I ask because I didn't see the problem until I had a high concurrency
which basically brought the database down... Right now I have the same
concurrency and no problems with the database, the only thing missing is
Nag.

I also tried using different versions of mysql and with different storing
engines and nothing really worked for me.

--
Jose.

On 12/20/05, Jie Gao <J.Gao at isu.usyd.edu.au> wrote:
>
>
>
>
> On Tue, 20 Dec 2005, Kevin M. Myer wrote:
>
> > Date: Tue, 20 Dec 2005 22:01:35 -0500
> > From: Kevin M. Myer <kevin_myer at iu13.org>
> > To: imp at lists.horde.org
> > Subject: Re: [imp] my experience
> >
> > Quoting "Jose R. Roca" <joseroca at gmail.com>:
> >
> > > I basically ran into the same problem and I did basically the same
> thing you
> > > did, throw all the hardware I could find to the problem. Now, since my
> > > instalation was a new one and my users only had access to IMP without
> any
> > > other feature before hand, I just took out Nag which happens to be the
> > > application that runs that query each time a user logs in. As soon as
> I took
> > > Nag out everything ran smoothly. I dont know if you can make the same
> choice
> > > that I did since you might already have users using the old Nag, but I
> can
> > > say that it worked for me.
> > >
> > > Never acually tried seperating the history out of the Datatree might
> try
> > > that out now and try using the Nag application soon.
> >
> > I'm not seeing any performance degradation due to the use of Nag, at
> > least not that I'm aware of.  Either the degradation is not there, or I
> > have MySQL dialed in so well ;)
> >
> > What version of MySQL are you running and what table type are you using?
>
> First mySql 4.0 and then 4.1; tried first MYISAM and then converted to
> INNODB. None helped.
>
> I wasn't aware it was Nag that caused it. :-(
>
> Regards,
>
>
>
> Jie
>
> > Kevin
> >
> > --
> > Kevin M. Myer
> > Senior Systems Administrator
> > Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.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
> >
> --
> 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
>