[rt-users] converting rt 1.0 mysql database SLOW

Scott pdxguy31 at yahoo.com
Fri Sep 6 23:23:37 EDT 2002


Hello,

 What was your server config?  Any special mySQL
params or anything?  Perl version?  Because I have
tried everything.

Thanks!

--- Asif Iqbal <iqbala at qwestip.net> wrote:
> I migrated ours from 1.0 to 2.0.13 and I had about
> 65,000 tickets
> 
> It worked fine with the upgrade script
> 
> ----- Original Message ----- 
> From: "Scott" <pdxguy31 at yahoo.com>
> To: <rt-users at lists.fsck.com>
> Sent: Friday, September 06, 2002 1:56 AM
> Subject: Re: [rt-users] converting rt 1.0 mysql
> database SLOW
> 
> 
> > Hi Phil,
> >  
> >  Thanks for the suggestion.  The problem is that I
> am
> > not a perl techie.  We just need to import some
> > records ;-).  Has anyone else upgraded 1.0 to 2.0
> with
> > 60,000 or so records?  I think the upgrade script
> is
> > definetly the problem, but I don't know how to
> write a
> > new one.  Are there any other upgrade scripts?
> > 
> > Thanks!
> >  
> > --- Phil Homewood <pdh at snapgear.com> wrote:
> > > Scott wrote:
> > > >  Top shows that perl is using 97.6% CPU. 
> Nothing
> > > else
> > > > is even close.  Any ideas?
> > > 
> > > Try throwing some debugging statements into the
> > > MigrateTickets
> > > function to see which code is running slowly.
> Repeat
> > > as needed
> > > for such things as MigrateTransactions.
> > > -- 
> > > Phil Homewood, Systems Janitor, www.SnapGear.com
> > > pdh at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7
> 3891
> > > 3630
> > > SnapGear - Custom Embedded Solutions and
> Security
> > > Appliances
> > > _______________________________________________
> > > rt-users mailing list
> > > rt-users at lists.fsck.com
> > > http://lists.fsck.com/mailman/listinfo/rt-users
> > > 
> > > Have you read the FAQ? The RT FAQ Manager lives
> at
> > http://fsck.com/rtfm
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> > Have you read the FAQ? The RT FAQ Manager lives at
> http://fsck.com/rtfm
> > 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com



More information about the rt-users mailing list