Slow MYSQL import?

[Dave#]

I am trying to do a MYSQL import/export on our Sun Cluster and a 60 meg export is taking over an hour?

The specs are thus:

First machine: Sun E250 - 1.5 gig of Ram twin 400 Ultra sparc 2 processors running Mysql 3.23.46-log

Second Machine: Sun E4500 6 gig of ram - 6 400 Ultra sparc 2 processors running mysql 3.23.54

Anyone got any suggestions why an import would take so long on such a huge server?

In the past I have occassionally just rsynced the data files between MYSQL instances - is this a VERY bad idea? Anyone got unstuck doing this?

Cheers

[eva2000]

Originally posted by Dave#
I am trying to do a MYSQL import/export on our Sun Cluster and a 60 meg export is taking over an hour?

The specs are thus:

First machine: Sun E250 - 1.5 gig of Ram twin 400 Ultra sparc 2 processors running Mysql 3.23.46-log

Second Machine: Sun E4500 6 gig of ram - 6 400 Ultra sparc 2 processors running mysql 3.23.54

Anyone got any suggestions why an import would take so long on such a huge server?

In the past I have occassionally just rsynced the data files between MYSQL instances - is this a VERY bad idea? Anyone got unstuck doing this?

Cheers woah that is a long time for 60mb

on my

dual AthlonMP 2000+ with 2GB ECC ddram ram it takes me 45-55mins to a 1.3GB sized sql file import and this is with my 300+ user vB forum + 12 other web sites running

on my

P4 2.4B with 512mb ddram the exact same 1.3GB sized sql file took me 125mins or 2+ hrs and this is with nothing running at the time

may i ask what's the drive configuration/type setup on these servers ? and how did you do the backup in the first place ? with or without mysqldump's --opt command ?

as for rsyncing, you doing this while mysql is running ?

[Dave#]

may i ask what's the drive configuration/type setup on these servers ?

The second server is a cluster holding 2 A1000 arrays with about 8 18 gig 10k rpm disks in each . . .


and how did you do the backup in the first place ? with or without mysqldump's --opt

I just did an export - NOT with the --opt flag

as for rsyncing, you doing this while mysql is running ?

Nope - shutdown both mysql servers then rsync accross gigabit ethernet - which is fast

thanks

[cerebro]

dual P3 866, 1 giga ram...1.2 Giga of SQL.
6 hs to import....Red Hat sucks :(