Factors for slower mysqldump on superior hardware vrs faster dump on

Factors for slower mysqldump on superior hardware vrs faster dump on

am 22.03.2010 14:45:59 von David Taveras

Hello,

Iam using OpenBSD 4.6 GENERIC kernel with mysql-server .

Machine A (faster)

AMD Athlon(tm) 64 X2 Dual Core Processor 5200+ ("AuthenticAMD"
686-class, 512KB L2 cache) 2.72 GHz
2GB of RAM

wd0 at pciide1 channel 0 drive 0:
wd0: 16-sector PIO, LBA48, 152627MB, 312581808 sectors
wd0(pciide1:0:0): using PIO mode 4, Ultra-DMA mode 5

Capacity. 160GB. Interface. SATA 3Gb/s. Cache. 8MB. Model ST3160813AS
SATA 3Gb/s 160GB

Machine B:
Dell PowerEdge R200
Intel(R) Xeon(R) CPU X3330 @ 2.66GHz ("GenuineIntel" 686-class) 2.67 GHz

sd0 at scsibus0 targ 0 lun 0: SCSI3 0/direct fixed
sd0: 237464MB, 512 bytes/sec, 486326272 sec total

Perc6 RAID controller in RAID1 ( i have even tried with one hard disk
and no raid controller and the results are not improved by much) They
are also SATA discs behind.


In fact.. I have also some ogther more sophisticated hardware then
Machine A, Dual Cores, Quad Cores.. and even machine A is faster with
the same mysqldump.

Machine A takes 2.20s
Machines B take 3.30s

Both being idle.


What am I looking in a machine to make it as fast as machine A ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org