From owner-freebsd-questions Wed Jun 19 10: 0:47 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mail.essoc.net (ver02.essoc.com [206.14.104.12]) by hub.freebsd.org (Postfix) with SMTP id E080737B408 for ; Wed, 19 Jun 2002 09:59:59 -0700 (PDT) Received: (qmail 43878 invoked from network); 19 Jun 2002 16:59:58 -0000 Received: from adsl-63-193-219-100.dsl.snfc21.pacbell.net (HELO bc) (63.193.219.100) by mail.essoc.net with SMTP; 19 Jun 2002 16:59:58 -0000 Date: Wed, 19 Jun 2002 10:10:51 -0700 From: Brian To: freebsd-questions Subject: MySQL/FreeBSD/Date problems X-Mailer: Sylpheed version 0.7.5claws (GTK+ 1.2.10; i386-portbld-freebsd4.6) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Message-Id: <20020619165959.E080737B408@hub.freebsd.org> Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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 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: on motherboard npx0: INT 16 interface pcib0: on motherboard IOAPIC #1 intpin 3 -> irq 2 IOAPIC #1 intpin 2 -> irq 5 IOAPIC #1 intpin 10 -> irq 9 pci0: on pcib0 pci0: at 2.0 irq 2 fxp0: 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: 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: on xl0 xlphy0: <3Com internal media interface> on miibus1 xlphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto isab0: at device 15.0 on pci0 isa0: on isab0 atapci0: port 0x54c0-0x54cf at device 15.1 on pci0 ata0: at 0x1f0 irq 14 on atapci0 ata1: at 0x170 irq 15 on atapci0 pcib1: on motherboard IOAPIC #1 intpin 0 -> irq 10 IOAPIC #1 intpin 1 -> irq 11 pci1: on pcib1 ahc0: 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: 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: