Re: FreeBSD MySQL still WAY slower than Linux

2005-06-10 Thread Tom Gidden

Hi Kris,

On 10 Jun 2005, at 18:17, Kris Kennaway wrote:


Show your kernel config etc.


I've been working with Steve on this project.  We've been playing  
with various tuning factors, including kernel changes, different  
stripe sizes on the RAID, my.cnf tuning, libmap.conf, and although  
we can gain a bit here and there, we can't account for the doubling  
of performance with Gentoo.  Anyway, I've included the dmesg and  
kernel config.


The Gentoo install was pretty vanilla-flavoured, as neither Steve or  
I had installed Gentoo before, and both of us are pretty rusty on any  
form of Linux.


Incidentally, this does not seem to be I/O-bound.  The data is big  
enough to stay in the table cache anyway.


I just noticed these particular tests were done on FreeBSD without  
HTT, whereas the Gentoo test was.  However, I can tell you that in  
earlier runs, the difference between HTT and non-HTT on FreeBSD for  
this benchmark was negligible.


Regards,
Tom

--- [snip] ---

Copyright (c) 1992-2005 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
The Regents of the University of California. All rights  
reserved.

FreeBSD 5.4-STABLE #0: Thu Jun  9 09:13:03 BST 2005
[EMAIL PROTECTED]:/usr/src/sys/i386/compile/PE2850_i386_4
Timecounter i8254 frequency 1193182 Hz quality 0
CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2793.01-MHz 686-class CPU)
  Origin = GenuineIntel  Id = 0xf41  Stepping = 1
   
Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE 
,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE

real memory  = 3489398784 (3327 MB)
avail memory = 3418517504 (3260 MB)
ACPI APIC Table: DELL   PE BKC  
ioapic0: Changing APIC ID to 7
ioapic1: Changing APIC ID to 8
ioapic1: WARNING: intbase 32 != expected base 24
ioapic2: Changing APIC ID to 9
ioapic2: WARNING: intbase 64 != expected base 56
ioapic3: Changing APIC ID to 10
ioapic3: WARNING: intbase 96 != expected base 88
ioapic0 Version 2.0 irqs 0-23 on motherboard
ioapic1 Version 2.0 irqs 32-55 on motherboard
ioapic2 Version 2.0 irqs 64-87 on motherboard
ioapic3 Version 2.0 irqs 96-119 on motherboard
npx0: math processor on motherboard
npx0: INT 16 interface
acpi0: DELL PE BKC on motherboard
acpi0: Power Button (fixed)
Timecounter ACPI-fast frequency 3579545 Hz quality 1000
acpi_timer0: 24-bit timer at 3.579545MHz port 0x808-0x80b on acpi0
cpu0: ACPI CPU on acpi0
pcib0: ACPI Host-PCI bridge port 0xcf8-0xcff on acpi0
pci0: ACPI PCI bus on pcib0
pcib1: ACPI PCI-PCI bridge at device 2.0 on pci0
pci1: ACPI PCI bus on pcib1
pcib2: ACPI PCI-PCI bridge at device 0.0 on pci1
pci2: ACPI PCI bus on pcib2
amr0: LSILogic MegaRAID 1.51 mem 0xdfec-0xdfef, 
0xd80f-0xd80f irq 46 at device 14.0 on pci2

amr0: LSILogic PERC 4e/Di Firmware 513O, BIOS H418, 256MB RAM
pcib3: ACPI PCI-PCI bridge at device 0.2 on pci1
pci3: ACPI PCI bus on pcib3
pcib4: ACPI PCI-PCI bridge at device 4.0 on pci0
pci4: ACPI PCI bus on pcib4
pcib5: ACPI PCI-PCI bridge at device 5.0 on pci0
pci5: ACPI PCI bus on pcib5
pcib6: ACPI PCI-PCI bridge at device 0.0 on pci5
pci6: ACPI PCI bus on pcib6
em0: Intel(R) PRO/1000 Network Connection, Version - 1.7.35 port  
0xecc0-0xecff mem 0xdfbe-0xdfbf irq 64 at device 7.0 on pci6

em0: Ethernet address: 00:11:43:ec:b1:7f
em0:  Speed:N/A  Duplex:N/A
pcib7: ACPI PCI-PCI bridge at device 0.2 on pci5
pci7: ACPI PCI bus on pcib7
em1: Intel(R) PRO/1000 Network Connection, Version - 1.7.35 port  
0xdcc0-0xdcff mem 0xdf9e-0xdf9f irq 65 at device 8.0 on pci7

em1: Ethernet address: 00:11:43:ec:b1:80
em1:  Speed:N/A  Duplex:N/A
pcib8: ACPI PCI-PCI bridge at device 6.0 on pci0
pci8: ACPI PCI bus on pcib8
pcib9: ACPI PCI-PCI bridge at device 0.0 on pci8
pci9: ACPI PCI bus on pcib9
pcib10: ACPI PCI-PCI bridge at device 0.2 on pci8
pci10: ACPI PCI bus on pcib10
pcib11: ACPI PCI-PCI bridge at device 30.0 on pci0
pci11: ACPI PCI bus on pcib11
pci11: display, VGA at device 13.0 (no driver attached)
isab0: PCI-ISA bridge at device 31.0 on pci0
isa0: ISA bus on isab0
atapci0: Intel ICH5 UDMA100 controller port 0xfc00-0xfc0f, 
0x376,0x170-0x177,0x3f6,0x1f0-0x1f7 at device 31.1 on pci0

ata0: channel #0 on atapci0
ata1: channel #1 on atapci0
atkbdc0: Keyboard controller (i8042) port 0x64,0x60 irq 1 on acpi0
atkbd0: AT Keyboard irq 1 on atkbdc0
kbd0 at atkbd0
sio0: 16550A-compatible COM port port 0x3f8-0x3ff irq 4 flags 0x10  
on acpi0

sio0: type 16550A
orm0: ISA Option ROMs at iomem 0xec000-0xe,0xc-0xcafff on isa0
sc0: System console at flags 0x100 on isa0
sc0: VGA 16 virtual consoles, flags=0x300
vga0: Generic ISA VGA at port 0x3c0-0x3df iomem 0xa-0xb on  
isa0

sio1: configured irq 3 not in bitmap of probed irqs 0
sio1: port may not be enabled
Timecounter TSC frequency 2793011648 Hz quality 800
Timecounters tick every 10.000 msec
acd0: CDROM SAMSUNG CD-ROM SN-124/N104 at ata0-master PIO4
amrd0: LSILogic MegaRAID logical drive on amr0
amrd0: 

Re: FreeBSD MySQL still WAY slower than Linux

2005-06-10 Thread Tom Gidden

Hi Guy,

On 10 Jun 2005, at 21:37, Guy Helmer wrote:


Have you tried a kernel with PREEMPTION enabled?  I haven't  
quantified the effect, but it's improved performance in some  
situations.

Have you tried increasing vfs.read_max?


Thanks for your suggestions... I've given them a go, and it looks  
like there's no discernible difference in performance for either/ 
both, on KSE, libthr or LinuxThreads.  =(


Regards,
Tom

___
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to [EMAIL PROTECTED]