From owner-freebsd-questions Wed Aug 30 13:58: 5 2000 Delivered-To: freebsd-questions@freebsd.org Received: from Astrovan.cstone.net (astrovan.cstone.net [209.145.64.80]) by hub.freebsd.org (Postfix) with ESMTP id 5F5AB37B423 for ; Wed, 30 Aug 2000 13:57:59 -0700 (PDT) Received: from cstone.net ([209.145.93.143]) by Astrovan.cstone.net (Post.Office MTA v3.5.3 release 223 ID# 0-59789U13500L1350S0V35) with ESMTP id net for ; Wed, 30 Aug 2000 16:49:47 -0400 Message-ID: <39AD7548.D5FF8C2F@cstone.net> Date: Wed, 30 Aug 2000 16:57:44 -0400 From: Sean Michael Whipkey X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: FreeBSD 3.4/MySQL Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Our copy of MySQL will periodically race, taking up all CPU usage. This prevents our web page from loading. uname -a shows: reeBSD riff.mrgoodbucks.com 3.4-RELEASE FreeBSD 3.4-RELEASE #0: Thu May 11 13:48:53 EDT 2000 seanmike@riff.mrgoodbucks.com:/usr/src/sys/compile/RIFF i386 dmesg shows: 43GX host to PCI bridge> rev 0x00 on pci0.0.0 chip1: rev 0x00 on pci0.1.0 chip2: rev 0x02 on pci0.7.0 ide_pci0: rev 0x01 on pci0.7.1 chip3: rev 0x02 on pci0.7.3 ahc0: rev 0x00 int a irq 16 on pci0.11.0 ahc0: aic7896/97 Wide Channel A, SCSI Id=7, 16/255 SCBs ahc1: rev 0x00 int a irq 16 on pci0.11.1 ahc1: aic7896/97 Wide Channel B, SCSI Id=7, 16/255 SCBs fxp0: rev 0x08 int a irq 19 on pci0.13.0 fxp0: Ethernet address 00:e0:81:10:7c:07 Probing for devices on PCI bus 1: vga0: rev 0xf3 int a irq 2 on pci1.0.0 Probing for PnP devices: Probing for devices on the ISA bus: sc0 on isa sc0: VGA color <16 virtual consoles, flags=0x0> atkbdc0 at 0x60-0x6f on motherboard atkbd0 irq 1 on isa psm0 not found sio0 at 0x3f8-0x3ff irq 4 flags 0x10 on isa sio0: type 16550A sio1 at 0x2f8-0x2ff irq 3 on isa sio1: type 16550A fdc0 at 0x3f0-0x3f7 irq 6 drq 2 on isa fdc0: FIFO enabled, 8 bytes threshold fd0: 1.44MB 3.5in wdc0 not found at 0x1f0 wdc1 at 0x170-0x177 irq 15 on isa wdc1: unit 0 (atapi): , removable, accel, dma, iordis acd0: drive speed 8268KB/sec, 128KB cache acd0: supported read types: CD-R, CD-RW, CD-DA acd0: Audio: play, 16 volume levels acd0: Mechanism: ejectable tray acd0: Medium: no/blank disc inside, unlocked ppc0 at 0x378 irq 7 flags 0x40 on isa ppc0: Generic chipset (NIBBLE-only) in COMPATIBLE mode lpt0: on ppbus 0 lpt0: Interrupt-driven port ppi0: on ppbus 0 plip0: on ppbus 0 adv0 not found at 0x330 bt0 not found at 0x134 aha0 not found at 0x134 aic0 not found vga0 at 0x3b0-0x3df maddr 0xa0000 msize 131072 on isa npx0 on motherboard npx0: INT 16 interface APIC_IO: Testing 8254 interrupt delivery APIC_IO: routing 8254 via pin 2 Waiting 5 seconds for SCSI devices to settle SMP: AP CPU #1 Launched! changing root device to da0s1a da0 at ahc0 bus 0 target 0 lun 0 da0: Fixed Direct Access SCSI-2 device da0: 80.000MB/s transfers (40.000MHz, offset 15, 16bit), Tagged Queueing Enabled da0: 17366MB (35566480 512 byte sectors: 255H 63S/T 2213C) MySQL is mysql-3.22.27-unknown-freebsd3.2-i386. Allowed packet size is upped to 25 MB. Apache is 1.3.12 with mod_perl, mod_ssl, and a number of other things. File system isn't full: Filesystem 1K-blocks Used Avail Capacity Mounted on /dev/da0s1a 99183 26957 64292 30% / /dev/da0s1g 1524463 838 1401668 0% /home /dev/da0s1e 508143 12914 454578 3% /tmp /dev/da0s1d 11038578 1158957 8996535 11% /usr /dev/da0s1f 2032623 6212 1863802 0% /var /dev/da0s1h 1016303 49570 885429 5% /www procfs 4 4 0 100% /proc The machine itself is colocated at our ISP. I have everything possible logging, portsentry watching the machine, plus used sysctl to log all the "in vain" ports. There are no errors when it crashes. Not in /var/log/messages, not in the Apache logs, not in the MySQL logs. Nothing. Occasionally dmesg reports a core dump, but no .core can be found on the machine. I'd like to upgrade MySQL, as perhaps that would help. What is the easiest way to do that? Thanks, SeanMike -- SeanMike Whipkey - Damnit. Where's my witty repartee? "Ow! Ow! Ow! I had to go after mutants, didn't I? I couldn't just attack Napster, nooooo. I had to attack freaks that know kung fu." - http://ter.air0day.com/xmen.html To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message