Date: Wed, 19 Jun 2002 18:36:55 -0700 (PDT) From: Matt Snow <drama@slakin.net> To: Brian <clark@essoc.com> Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: MySQL/FreeBSD/Date problems Message-ID: <20020619183334.O29938-100000@seven.slakin.net> In-Reply-To: <20020619165959.E080737B408@hub.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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<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 > 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?20020619183334.O29938-100000>