Date: Tue, 10 Sep 2002 18:27:24 +0100 From: Dominic Marks <dominic_marks@btinternet.com> To: hackers@d.sparks.net Cc: freebsd-hackers@freebsd.org Subject: Re: Dell 2650 SMP perf question Message-ID: <20020910172724.GB889@gallium> In-Reply-To: <Pine.BSF.4.21.0209101051021.52716-100000@search.sparks.net> References: <Pine.BSF.4.21.0209101051021.52716-100000@search.sparks.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, Sep 10, 2002 at 01:16:40PM -0400, hackers@d.sparks.net wrote: > Hi All; > > I'm stumped at how little improvement using an SMP kernel gives in a Dell > 2650. System is dual 2400 xeon processors, 2 GB ram. It's intended to be > used as a database processor, among other things. A perl process that > read and input file and updates simple records in a mysql database > actually run much more slowly: processing ~2million records takes 817 > seconds with SMP enabled and 262 seconds with it disabled. > > Simple things like some_program.pl < some_big_file | another_program.pl > > seem to take full advantage of the second processor, but this system is > supposed to run mysql. > > Hyperthreading is turned off, I believe. There aren't any > "hyperthreading" swithes in the bios I could find, but the "logical > processor" option is turned off. > > > Clues why SMP is so much slower very welcome indeed. I believe at some point in the not too distant past their have been many performance problems for people using MySQL on FreeBSD. These problems where mostly related to MySQL's use of threads, I don't know if these problems have been fully resolved but it could be that SMP is aggrevating this. Watching what MySQL is doing with a trace might show some interesting results. I suppose you're running the lastest version of MySQL ? > --- David > > > > > Nitty Gritty details: > > > > FreeBSD is 4.7prerelease, cvsupped 9/9/02. Dmesg output: > > Copyright (c) 1992-2002 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 4.7-PRERELEASE #0: Mon Sep 9 21:23:39 GMT 2002 > root@:/usr/src/sys/compile/DBSMP > Timecounter "i8254" frequency 1193182 Hz > CPU: Pentium 4 (2392.26-MHz 686-class CPU) > Origin = "GenuineIntel" Id = 0xf24 Stepping = 4 > > Features=0x3febfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,M > MX,FXSR,SSE,SSE2,SS,<b28>,ACC> > real memory = 2147418112 (2097088K bytes) > avail memory = 2088226816 (2039284K bytes) > Changing APIC ID for IO APIC #0 from 0 to 3 on chip > Changing APIC ID for IO APIC #1 from 0 to 4 on chip > Changing APIC ID for IO APIC #2 from 0 to 5 on chip > Programming 16 pins in IOAPIC #0 > IOAPIC #0 intpin 2 -> irq 0 > Programming 16 pins in IOAPIC #1 > Programming 16 pins in IOAPIC #2 > FreeBSD/SMP: Multiprocessor motherboard > cpu0 (BSP): apic id: 0, version: 0x00050014, at 0xfee00000 > cpu1 (AP): apic id: 2, version: 0x00050014, at 0xfee00000 > io0 (APIC): apic id: 3, version: 0x000f0011, at 0xfec00000 > io2 (APIC): apic id: 5, version: 0x000f0011, at 0xfec02000 > Preloaded elf kernel "kernel" at 0xc035a000. > md0: Malloc disk > Using $PIR table, 9 entries at 0xc00fc490 > npx0: <math processor> on motherboard > npx0: INT 16 interface > pcib0: <Host to PCI bridge> on motherboard > IOAPIC #1 intpin 3 -> irq 2 > IOAPIC #1 intpin 7 -> irq 3 > IOAPIC #1 intpin 11 -> irq 5 > pci0: <PCI bus> on pcib0 > pci0: <unknown card> (vendor=0x1028, dev=0x000c) at 4.0 irq 2 > pci0: <unknown card> (vendor=0x1028, dev=0x0008) at 4.1 irq 3 > pci0: <unknown card> (vendor=0x1028, dev=0x000d) at 4.2 irq 5 > pci0: <ATI Mach64-GR graphics accelerator> at 14.0 > atapci0: <ServerWorks CSB5 ATA100 controller> port > 0x8b0-0x8bf,0x8d8-0x8db,0x8d0-0x8d7,0x8c8-0x8cb,0x8c0-0x8c7 a > t device 15.1 on pci0 > ata0: at 0x1f0 irq 14 on atapci0 > ata1: at 0x170 irq 15 on atapci0 > pci0: <OHCI USB controller> at 15.2 irq 0 > isab0: <PCI to ISA bridge (vendor=1166 device=0225)> at device 15.3 on > pci0 > isa0: <ISA bus> on isab0 > pcib1: <Host to PCI bridge> on motherboard > pci1: <PCI bus> on pcib1 > pcib2: <Host to PCI bridge> on motherboard > pci2: <PCI bus> on pcib2 > pcib3: <Host to PCI bridge> on motherboard > IOAPIC #1 intpin 12 -> irq 7 > IOAPIC #1 intpin 13 -> irq 10 > pci3: <PCI bus> on pcib3 > bge0: <Broadcom BCM5701 Gigabit Ethernet> mem 0xfcf10000-0xfcf1ffff irq 7 > at device 6.0 on pci3 > bge0: Ethernet address: 00:06:5b:8c:a5:62 > miibus0: <MII bus> on bge0 > brgphy0: <BCM5701 10/100/1000baseTX PHY> on miibus0 > brgphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, > 1000baseTX-FDX, auto > bge1: <Broadcom BCM5701 Gigabit Ethernet> mem 0xfcf00000-0xfcf0ffff irq 10 > at device 8.0 on pci3 > bge1: Ethernet address: 00:06:5b:8c:a5:63 > miibus1: <MII bus> on bge1 > brgphy1: <BCM5701 10/100/1000baseTX PHY> on miibus1 > brgphy1: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, > 1000baseTX-FDX, auto > pcib4: <Host to PCI bridge> on motherboard > pci4: <PCI bus> on pcib4 > pcib8: <PCI to PCI bridge (vendor=8086 device=0309)> at device 8.0 on pci4 > IOAPIC #1 intpin 14 -> irq 11 > IOAPIC #1 intpin 15 -> irq 13 > pci5: <PCI bus> on pcib8 > ahc_pci0: <Adaptec aic7899 Ultra160 SCSI adapter> port 0xcc00-0xccff mem > 0xfccff000-0xfccfffff irq 11 at device > 6.0 on pci5 > aic7899: Ultra160 Wide Channel A, SCSI Id=7, 32/253 SCBs > ahc_pci1: <Adaptec aic7899 Ultra160 SCSI adapter> port 0xc800-0xc8ff mem > 0xfccfe000-0xfccfefff irq 13 at device > 6.1 on pci5 > aic7899: Ultra160 Wide Channel B, SCSI Id=7, 32/253 SCBs > pcib5: <Host to PCI bridge> on motherboard > pci6: <PCI bus> on pcib5 > pcib6: <Host to PCI bridge> on motherboard > pci7: <PCI bus> on pcib6 > pcib7: <Host to PCI bridge> on motherboard > pci8: <PCI bus> on pcib7 > orm0: <Option ROMs> at iomem > 0xc0000-0xc7fff,0xc8000-0xcdfff,0xec000-0xeffff on isa0 > fdc0: <NEC 72065B or clone> at port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on isa0 > fdc0: FIFO enabled, 8 bytes threshold > fd0: <1440-KB 3.5" drive> on fdc0 drive 0 > atkbdc0: <Keyboard controller (i8042)> at port 0x60,0x64 on isa0 > atkbd0: <AT Keyboard> irq 1 on atkbdc0 > kbd0 at atkbd0 > vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 > sc0: <System console> at flags 0x100 on isa0 > sc0: VGA <16 virtual consoles, flags=0x300> > sio0 at port 0x3f8-0x3ff irq 4 flags 0x10 on isa0 > sio0: type 16550A > sio1: configured irq 3 not in bitmap of probed irqs 0 > ppc0: parallel port not found. > APIC_IO: Testing 8254 interrupt delivery > APIC_IO: Broken MP table detected: 8254 is not connected to IOAPIC #0 > intpin 2 > APIC_IO: routing 8254 via 8259 and IOAPIC #0 intpin 0 > ata0-slave: ATAPI identify retries exceeded > SMP: AP CPU #1 Launched! > acd0: CDROM <TEAC CD-ROM CD-224E> at ata0-master PIO4 > Waiting 5 seconds for SCSI devices to settle > pass1 at ahc0 bus 0 target 6 lun 0 > pass1: <PE/PV 1x5 SCSI BP 0.25> Fixed Processor SCSI-2 device > pass1: 3.300MB/s transfers > da0 at ahc0 bus 0 target 0 lun 0 > da0: <SEAGATE ST373405LC 2203> Fixed Direct Access SCSI-3 device > da0: 160.000MB/s transfers (80.000MHz, offset 63, 16bit), Tagged Queueing > Enabled > da0: 70007MB (143374650 512 byte sectors: 255H 63S/T 8924C) > Mounting root from ufs:/dev/da0s1a > > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-hackers" in the body of the message -- Dominic Marks Computer & Politics Geek [work]::[npl.co.uk] << dominic.marks at npl.co.uk >> [educ]::[umist.ac.uk] << notyet-known at umist.ac.uk >> [home]::[btinternet] << dominic_marks at btinternet.com >> To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020910172724.GB889>