[rt-users] converting rt 1.0 mysql database SLOW

Asif Iqbal iqbala at qwestip.net
Fri Sep 6 21:37:30 EDT 2002


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
> 




More information about the rt-users mailing list