Date: Wed, 30 Aug 2000 16:57:44 -0400 From: Sean Michael Whipkey <highway@cstone.net> To: freebsd-questions@freebsd.org Subject: FreeBSD 3.4/MySQL Message-ID: <39AD7548.D5FF8C2F@cstone.net>
next in thread | raw e-mail | index | archive | help
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: <Intel 82443GX host to AGP bridge> rev 0x00 on pci0.1.0 chip2: <Intel 82371AB PCI to ISA bridge> rev 0x02 on pci0.7.0 ide_pci0: <Intel PIIX4 Bus-master IDE controller> rev 0x01 on pci0.7.1 chip3: <Intel 82371AB Power management controller> rev 0x02 on pci0.7.3 ahc0: <Adaptec aic7896/97 Ultra2 SCSI adapter> rev 0x00 int a irq 16 on pci0.11.0 ahc0: aic7896/97 Wide Channel A, SCSI Id=7, 16/255 SCBs ahc1: <Adaptec aic7896/97 Ultra2 SCSI adapter> rev 0x00 int a irq 16 on pci0.11.1 ahc1: aic7896/97 Wide Channel B, SCSI Id=7, 16/255 SCBs fxp0: <Intel EtherExpress Pro 10/100B Ethernet> 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: <Trident model 9750 VGA-compatible display device> 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): <TOSHIBA CD-ROM XM-6702B/1005>, 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: <generic printer> on ppbus 0 lpt0: Interrupt-driven port ppi0: <generic parallel i/o> on ppbus 0 plip0: <PLIP network interface> 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: <SEAGATE ST318275LW 0001> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?39AD7548.D5FF8C2F>