From owner-freebsd-questions Wed Jun 19 18:36:59 2002 Delivered-To: freebsd-questions@freebsd.org Received: from seven.slakin.net (adsl-67-112-126-134.dsl.pltn13.pacbell.net [67.112.126.134]) by hub.freebsd.org (Postfix) with ESMTP id 1F21737B409 for ; Wed, 19 Jun 2002 18:36:50 -0700 (PDT) Received: from localhost (localhost.slakin.net [127.0.0.1]) by seven.slakin.net (Postfix) with ESMTP id C0F276FD; Wed, 19 Jun 2002 18:36:55 -0700 (PDT) Date: Wed, 19 Jun 2002 18:36:55 -0700 (PDT) From: Matt Snow To: Brian Cc: freebsd-questions Subject: Re: MySQL/FreeBSD/Date problems In-Reply-To: <20020619165959.E080737B408@hub.freebsd.org> Message-ID: <20020619183334.O29938-100000@seven.slakin.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 I started out with FreeBSD 4.2 running the MySQL from the ports at the time on a ppro 200MHz. I now run 4.5-stable(soon to be 4.6) with MySQL v3.23.49 on a first-gen Athlon K7 700MHz. all works fine for me. I also run daily cron jobs for ntpdate. * * * * * * * * Matt Snow (@) drama@slakin.net (w) http://slakin.net. On Wed, 19 Jun 2002, Brian wrote: > 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: