On Sun, 19 Nov 2006, Gaby Vanhegan wrote:
> I'm really having an incredibly painful time with MySQL on 3.9. Has
> anybody had a problem getting MySQL 4 or 5 to play happy? I've read
> these pages:
>
> http://www.openbsdsupport.org/mysql.htm
> http://monkey.org/openbsd/archive/misc/0411/msg03296.html
> http://marc.theaimsgroup.com/?l=openbsd-misc&m=111881975209858&w=2
> http://marc.theaimsgroup.com/?l=openbsd-misc&m=111887588311627&w=2
>
> And applied it to MySQL 5, both from ports, and the latest 4.x
> release built from source. I still get the database basically
> locking under moderate load, or failing to do a mysqlcheck. The
> errors I get (from the .err file) are along these lines:
>
> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file:
> './condor5/user.frm' (errno: 9)
> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file:
> './condor5/user_in_group.frm' (errno: 9)
> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file:
> './condor5/user_in_group.frm' (errno: 9)
> (using 4.x)
>
> Or these when doing the suggested mysqlcheck command:
>
> mysql.columns_priv OK
> mysql.db OK
> mysql.func
> error : File './mysql/func.MYD' not found (Errcode: 9)
> mysql.help_category
> error : File './mysql/help_category.MYD' not found (Errcode: 9)
> mysql.help_keyword
> error : File './mysql/help_keyword.MYD' not found (Errcode: 9)
> mysql.help_relation
> error : File './mysql/help_relation.MYD' not found (Errcode: 9)
> mysql.help_topic
> error : File './mysql/help_topic.MYD' not found (Errcode: 9)
>
> I've followed all the instructions on the relevant pages, and
> instructions form the mail archives but to no avail. I have a theory
> that it doesn't hold up under the load of dspam using MySQL as it's
> back end, and I'll be trying that running under something else but
> for the moment, normal every day databases just stop working after a
> while. What have you had to do to get MySQL up and running properly?
How do you start mysql? It's essential you start it with the proper
login class, like:
su -c _mysql root ...
-Otto
>
> # sysctl kern.maxfiles
> kern.maxfiles=13666
> # cat /etc/login.conf
> ...
> #
> # MySQL daemon
> #
> _mysql:\
> :datasize=infinity:\
> :maxproc=infinity:\
> :openfiles-cur=2048:\
> :openfiles-max=8192:\
> :stacksize-cur=8M:\
> :localcipher=blowfish,8:\
> :tc=default:
> # userinfo _mysql
> login _mysql
> passwd *************
> uid 502
> groups _mysql
> change NEVER
> class _mysql
> gecos MySQL Account
> dir /nonexistent
> shell /sbin/nologin
> expire NEVER
> # cat /etc/my.cnf | grep files
> open_files_limit = 2048
> # dmesg
> OpenBSD 3.9 (GENERIC.MP) #598: Thu Mar 2 02:37:06 MST 2006
> [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC.MP
> cpu0: Intel(R) Pentium(R) D CPU 2.66GHz ("GenuineIntel" 686-class)
> 2.68 GHz
> cpu0:
> FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,
> CFLUSH,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,TM2,CNXT-ID
> real mem = 2146541568 (2096232K)
> avail mem = 1952505856 (1906744K)
> using 4278 buffers containing 107429888 bytes (104912K) of memory
> mainbus0 (root)
> bios0 at mainbus0: AT/286+(00) BIOS, date 10/30/05, BIOS32 rev. 0 @
> 0xf0010
> apm0 at bios0: Power Management spec V1.2
> apm0: AC on, battery charge unknown
> apm0: flags 30102 dobusy 0 doidle 1
> pcibios at bios0 function 0x1a not configured
> bios0: ROM list: 0xc0000/0x8000 0xc8000/0x2200
> mainbus0: Intel MP Specification (Version 1.1) (INTEL Premium )
> cpu0 at mainbus0: apid 0 (boot processor)
> cpu0: apic clock running at 133 MHz
> cpu1 at mainbus0: apid 1 (application processor)
> cpu1: Intel(R) Pentium(R) D CPU 2.66GHz ("GenuineIntel" 686-class)
> 2.68 GHz
> cpu1:
> FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,
> CFLUSH,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,TM2,CNXT-ID
> mainbus0: bus 0 is type PCI
> mainbus0: bus 1 is type PCI
> mainbus0: bus 2 is type PCI
> mainbus0: bus 3 is type PCI
> mainbus0: bus 4 is type PCI
> mainbus0: bus 5 is type ISA
> ioapic0 at mainbus0: apid 2 pa 0xfec00000, version 20, 24 pins
> pci0 at mainbus0 bus 0: configuration mode 1 (no bios)
> pchb0 at pci0 dev 0 function 0 "Intel 82955X MCH" rev 0x81
> ppb0 at pci0 dev 28 function 0 "Intel 82801GB PCIE" rev 0x01
> pci1 at ppb0 bus 4
> ppb1 at pci0 dev 28 function 4 "Intel 82801G PCIE" rev 0x01
> pci2 at ppb1 bus 3
> em0 at pci2 dev 0 function 0 "Intel PRO/1000MT (82573L)" rev 0x00:
> apic 2 int 16 (irq 11), address 00:15:f2:c8:8e:10
> ppb2 at pci0 dev 28 function 5 "Intel 82801G PCIE" rev 0x01
> pci3 at ppb2 bus 2
> "CMD Technology SiI3132 SATA" rev 0x01 at pci3 dev 0 function 0 not
> configured
> uhci0 at pci0 dev 29 function 0 "Intel 82801GB USB" rev 0x01: apic 2
> int 20 (irq 10)
> usb0 at uhci0: USB revision 1.0
> uhub0 at usb0
> uhub0: Intel UHCI root hub, rev 1.00/1.00, addr 1
> uhub0: 2 ports with 2 removable, self powered
> uhci1 at pci0 dev 29 function 1 "Intel 82801GB USB" rev 0x01: apic 2
> int 17 (irq 10)
> usb1 at uhci1: USB revision 1.0
> uhub1 at usb1
> uhub1: Intel UHCI root hub, rev 1.00/1.00, addr 1
> uhub1: 2 ports with 2 removable, self powered
> uhci2 at pci0 dev 29 function 2 "Intel 82801GB USB" rev 0x01: apic 2
> int 18 (irq 3)
> usb2 at uhci2: USB revision 1.0
> uhub2 at usb2
> uhub2: Intel UHCI root hub, rev 1.00/1.00, addr 1
> uhub2: 2 ports with 2 removable, self powered
> uhci3 at pci0 dev 29 function 3 "Intel 82801GB USB" rev 0x01: apic 2
> int 19 (irq 5)
> usb3 at uhci3: USB revision 1.0
> uhub3 at usb3
> uhub3: Intel UHCI root hub, rev 1.00/1.00, addr 1
> uhub3: 2 ports with 2 removable, self powered
> ppb3 at pci0 dev 30 function 0 "Intel 82801BA AGP" rev 0xe1
> pci4 at ppb3 bus 1
> vga1 at pci4 dev 1 function 0 "ATI Mach64 GU" rev 0x9a
> wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation)
> wsdisplay0: screen 1-5 added (80x25, vt100 emulation)
> ami0 at pci4 dev 2 function 0 "Symbios Logic MegaRAID" rev 0x01: apic
> 2 int 23 (irq 5) LSI 523 64b/lhc
> ami0: FW 713N, BIOS vG119, 64MB RAM
> ami0: 1 channels, 0 FC loops, 1 logical drives
> scsibus0 at ami0: 40 targets
> sd0 at scsibus0 targ 0 lun 0: <AMI, Host drive #00, > SCSI2 0/direct
> fixed
> sd0: 478736MB, 478736 cyl, 64 head, 32 sec, 512 bytes/sec, 980451328
> sec total
> scsibus1 at ami0: 16 targets
> "ITExpress IT8211F" rev 0x11 at pci4 dev 4 function 0 not configured
> skc0 at pci4 dev 5 function 0 "Marvell Yukon 88E8001/8003/8010" rev
> 0x13, Marvell Yukon Lite (0x9): apic 2 int 21 (irq 10)
> sk0 at skc0 port A, address 00:15:f2:c8:88:32
> eephy0 at sk0 phy 0: Marvell 88E1011 Gigabit PHY, rev. 5
> ichpcib0 at pci0 dev 31 function 0 "Intel 82801GB LPC" rev 0x01: PM
> disabled
> pciide0 at pci0 dev 31 function 1 "Intel 82801GB IDE" rev 0x01: DMA,
> channel 0 configured to compatibility, channel 1 configured to
> compatibility
> atapiscsi0 at pciide0 channel 0 drive 0
> scsibus2 at atapiscsi0: 2 targets
> cd0 at scsibus2 targ 0 lun 0: <SAMSUNG, CD-ROM SC-148F, PS06> SCSI0 5/
> cdrom removable
> cd0(pciide0:0:0): using PIO mode 4, DMA mode 2
> pciide0: channel 1 disabled (no drives)
> pciide1 at pci0 dev 31 function 2 "Intel 82801GB SATA" rev 0x01: DMA,
> channel 0 configured to native-PCI, channel 1 configured to native-PCI
> pciide1: using apic 2 int 23 (irq 5) for native-PCI interrupt
> ichiic0 at pci0 dev 31 function 3 "Intel 82801GB SMBus" rev
> 0x01pci_intr_map: no mapping for pin B
> : polling
> iic0 at ichiic0
> isa0 at ichpcib0
> isadma0 at isa0
> pckbc0 at isa0 port 0x60/5
> pckbd0 at pckbc0 (kbd slot)
> pckbc0: using irq 1 for kbd slot
> wskbd0 at pckbd0: console keyboard, using wsdisplay0
> pcppi0 at isa0 port 0x61
> midi0 at pcppi0: <PC speaker>
> spkr0 at pcppi0
> lpt0 at isa0 port 0x378/4 irq 7
> lm0 at isa0 port 0x290/8: unknown Winbond chip (ID 0xa1)
> npx0 at isa0 port 0xf0/16: using exception 16
> pccom0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo
> fdc0 at isa0 port 0x3f0/6 irq 6 drq 2
> fd0 at fdc0 drive 0: 1.44MB 80 cyl, 2 head, 18 sec
> biomask 0 netmask 0 ttymask 0
> pctr: user-level cycle counter enabled
> apm0: disconnected
> dkcsum: sd0 matches BIOS drive 0x80
> root on sd0a
> rootdev=0x400 rrootdev=0xd00 rawdev=0xd02
>
> Gaby
>
> --
> Junkets for bunterish lickspittles since 1998!
> http://www.playr.co.uk/sudoku/
> http://weblog.vanhegan.net/
