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
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 ?
|• Factors for slower mysqldump on superior hardware vrs faster dump on slower hardware. Same install. Why?||David Taveras||22 Mar|