Date: Wed, 19 Jun 2002 10:10:51 -0700 From: Brian <clark@essoc.com> To: freebsd-questions <freebsd-questions@freebsd.org> Subject: MySQL/FreeBSD/Date problems Message-ID: <20020619165959.E080737B408@hub.freebsd.org>
next in thread | raw e-mail | index | archive | help
Hello,
I have been having some issues with MySQL & FreeBSD. Here is the problem. MySQL starts using 99% of the CPU and then the date on the FreeBSD box moves ahead. If I reboot the box the date will go back to the correct date and MySQL will only use minimal resources. MySQL is still working correctly and quickly but since the time changes much of the data is incorrect. I also have ntpd running but it can only correct small differences in the time. The time jumps ahead anywhere from 1.5 hours to 3.5 hours. I am going to upgrade FreeBSD and MySQL today but was wondering if anyone else has had this issue or has any ideas on a fix.
Thanks,
Brian
>>> TOP <<<
last pid: 11107; load averages: 1.00, 1.00, 0.95 up 5+19:37:17 10:59:23
18 processes: 2 running, 16 sleeping
CPU states: 0.8% user, 0.0% nice, 49.2% system, 0.4% interrupt, 49.6% idle
Mem: 244M Active, 641M Inact, 81M Wired, 29M Cache, 112M Buf, 9720K Free
Swap: 2056M Total, 2056M Free
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
301 mysql 58 0 398M 238M CPU0 0 35.1H 99.02% 99.02% mysqld
>>> DMESG <<<
Copyright (c) 1992-2001 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.3-STABLE #0: Thu Jul 5 15:38:34 PDT 2001
brianc@:/usr/src/sys/compile/ESSOC
Timecounter "i8254" frequency 1193182 Hz
CPU: Pentium III/Pentium III Xeon/Celeron (933.07-MHz 686-class CPU)
Origin = "GenuineIntel" Id = 0x686 Stepping = 6
Features=0x387fbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,PN,MMX,FXSR,SSE>
real memory = 1073676288 (1048512K bytes)
config> q
avail memory = 1042485248 (1018052K bytes)
Programming 16 pins in IOAPIC #0
IOAPIC #0 intpin 2 -> irq 0
Programming 16 pins in IOAPIC #1
FreeBSD/SMP: Multiprocessor motherboard
cpu0 (BSP): apic id: 3, version: 0x00040011, at 0xfee00000
cpu1 (AP): apic id: 0, version: 0x00040011, at 0xfee00000
io0 (APIC): apic id: 4, version: 0x000f0011, at 0xfec00000
io1 (APIC): apic id: 5, version: 0x000f0011, at 0xfec01000
Preloaded elf kernel "kernel" at 0xc02db000.
Preloaded userconfig_script "/boot/kernel.conf" at 0xc02db09c.
Pentium Pro MTRR support enabled
md0: Malloc disk
npx0: <math processor> on motherboard
npx0: INT 16 interface
pcib0: <ServerWorks NB6635 3.0LE host to PCI bridge> on motherboard
IOAPIC #1 intpin 3 -> irq 2
IOAPIC #1 intpin 2 -> irq 5
IOAPIC #1 intpin 10 -> irq 9
pci0: <PCI bus> on pcib0
pci0: <ATI Mach64-GV graphics accelerator> at 2.0 irq 2
fxp0: <Intel Pro 10/100B/100+ Ethernet> port 0x5480-0x54bf mem 0xfb000000-0xfb0fffff,0xfb101000-0xfb101fff irq 5 at device 3.0 on pci0
fxp0: Ethernet address 00:d0:b7:b6:9e:99
inphy0: <i82555 10/100 media interface> on miibus0
inphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
xl0: <3Com 3c905B-TX Fast Etherlink XL> port 0x5400-0x547f mem 0xfb102000-0xfb10207f irq 9 at device 6.0 on pci0
xl0: Ethernet address: 00:01:02:3f:35:4d
miibus1: <MII bus> on xl0
xlphy0: <3Com internal media interface> on miibus1
xlphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
isab0: <ServerWorks IB6566 PCI to ISA bridge> at device 15.0 on pci0
isa0: <ISA bus> on isab0
atapci0: <ServerWorks ROSB4 ATA33 controller> port 0x54c0-0x54cf at device 15.1 on pci0
ata0: at 0x1f0 irq 14 on atapci0
ata1: at 0x170 irq 15 on atapci0
pcib1: <ServerWorks NB6635 3.0LE host to PCI bridge> on motherboard
IOAPIC #1 intpin 0 -> irq 10
IOAPIC #1 intpin 1 -> irq 11
pci1: <PCI bus> on pcib1
ahc0: <Adaptec aic7899 Ultra160 SCSI adapter> port 0x5800-0x58ff mem 0xfd000000-0xfd000fff irq 10 at device 4.0 on pci1
aic7899: Wide Channel A, SCSI Id=7, 32/255 SCBs
ahc1: <Adaptec aic7899 Ultra160 SCSI adapter> port 0x6000-0x60ff mem 0xfd001000-0xfd001fff irq 11 at device 4.1 on pci1
aic7899: Wide Channel B, SCSI Id=7, 32/255 SCBs
orm0: <Option ROMs> at iomem 0xc0000-0xc7fff,0xc8000-0xc8fff,0xc9000-0xcefff 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 at port 0x2f8-0x2ff irq 3 on isa0
sio1: type 16550A
ppc0: <Parallel port> at port 0x378-0x37f irq 7 on isa0
ppc0: SMC-like chipset (ECP/EPP/PS2/NIBBLE) in COMPATIBLE mode
ppc0: FIFO with 16/16/8 bytes threshold
plip0: <PLIP network interface> on ppbus0
lpt0: <Printer> on ppbus0
lpt0: Interrupt-driven port
ppi0: <Parallel I/O> on ppbus0
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
IP packet filtering initialized, divert disabled, rule-based forwarding disabled, default to deny, logging limited to 1000 packets/entry by default
SMP: AP CPU #1 Launched!
Waiting 15 seconds for SCSI devices to settle
pass3 at ahc0 bus 0 target 6 lun 0
pass3: <ESG-SHV SCA HSBP M10 0.04> Fixed Processor SCSI-2 device
pass3: 3.300MB/s transfers
da0 at ahc0 bus 0 target 0 lun 0
da0: <QUANTUM ATLAS10K2-TY092J DDD6> Fixed Direct Access SCSI-3 device
da0: 160.000MB/s transfers (80.000MHz, offset 127, 16bit), Tagged Queueing Enabled
da0: 8759MB (17938985 512 byte sectors: 255H 63S/T 1116C)
da1 at ahc0 bus 0 target 1 lun 0
da1: <IBM DDYS-T18350M S93E> Fixed Direct Access SCSI-3 device
da1: 160.000MB/s transfers (80.000MHz, offset 63, 16bit), Tagged Queueing Enabled
da1: 17501MB (35843670 512 byte sectors: 255H 63S/T 2231C)
da2 at ahc0 bus 0 target 2 lun 0
da2: <IBM DDYS-T18350M S93E> Fixed Direct Access SCSI-3 device
da2: 160.000MB/s transfers (80.000MHz, offset 63, 16bit), Tagged Queueing Enabled
da2: 17501MB (35843670 512 byte sectors: 255H 63S/T 2231C)
Mounting root from ufs:/dev/da0s1a
>>> UNAME <<<
> uname -a
FreeBSD 4.3-STABLE FreeBSD 4.3-STABLE #0: Thu Jul 5 15:38:34 PDT 2001 brianc@:/usr/src/sys/compile/ESSOC i38
>>> DATE <<<
Wed Jun 19 11:10:17 PDT 2002
>>> TOP AFTER REBOOT <<<
last pid: 304; load averages: 0.06, 0.05, 0.02 up 0+00:02:28 09:53:12
18 processes: 1 running, 17 sleeping
CPU states: 1.0% user, 0.0% nice, 0.4% system, 0.4% interrupt, 98.2% idle
Mem: 8688K Active, 6928K Inact, 25M Wired, 4K Cache, 22M Buf, 965M Free
Swap: 2056M Total, 2056M Free
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
301 mysql 2 0 389M 6152K poll 1 0:03 1.82% 1.81% mysqld
>>> DATE AFTER REBOOT <<<
Wed Jun 19 09:54:13 PDT 200
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?20020619165959.E080737B408>