List:General Discussion« Previous MessageNext Message »
From:David Taveras Date:March 22 2010 1:45pm
Subject:Factors for slower mysqldump on superior hardware vrs faster dump on
slower hardware. Same install. Why?
View as plain text  
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: <ST3160813AS>
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: <Dell, VIRTUAL DISK, 1028> 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 ?
Thread
Factors for slower mysqldump on superior hardware vrs faster dump on slower hardware. Same install. Why?David Taveras22 Mar