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? # 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/
