[rt-users] Further import woes
Matthew Watson
mwatson at netspace.net.au
Thu Sep 27 07:35:06 EDT 2001
I don't think its really an issue with your setup, I did a limited
import of about 200 tickets and this took approx 10 minutes...
of cause this means our database of 220000+ tickets is going to take
awhile to process :)
On Wed, Sep 26, 2001 at 04:54:28PM -0700, J B Bell wrote:
> Well, I seem to have a successful import going, for adequately broad
> definitions of "success."
>
> Having copied the mysql RT1 database to the same machine that is to
> house the RT2 setup seems to have solved the mysterious connection
> death problems. Unfortunately, the import is zipping along at about
> 43 minutes per 1,000 tickets. This will make our database of some
> 28,000 tickets take about 24 hours. Not so bad in itself, since of
> course it only needs to be done once, but I'd rather avoid that long a
> service outage, since it would be good to avoid needing to re-import
> again after the main import is done to get the delta in.
>
> Any suggestions? Is this wholly bizarre, indicating some mysql
> misconfiguration? It seems peculiar given how quickly a web page
> comes up in RT, which must use a similar query, but presumably the
> logic to transform the mysql records into a Pg insert is
> time-consuming--I don't know. It's running on a pIII-550, fwiw.
>
> Any clues gratefully accepted.
>
> --JB
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
--
Matthew Watson
Development , Netspace Online Systems
mwatson at netspace.net.au
More information about the rt-users
mailing list