openemr wrote on Friday, May 06, 2005:
After nearly abandoning OpenBSD for FreeBSDs reputed better support for Mysql 4.1.11(4.1.x needed at a mininum , 4.0.x exhbits bugs due to lack of necessary features), I decided to research more deeply and found the following needs to be done during configuration/building/installation of MySQL.
while building MySQL 4.1.11 I found the following helpful during the configuration of MySQL.
CFLAGS=-pthread CXXFLAGS=-pthread ./configure --with-mit-threads=no
and at runtime invoke mysqld_safe with --open-files-limit=2048
I additionally found changes to /etc/login.conf
mysql:
:datasize=infinity:
:maxproc=infinity:
:openfiles-cur=2048:
:openfiles-max=8192:
:stacksize-cur=8M:
:localcipher=blowfish,8:
:tc=default:
the above seems to get around earlier failures of the mysqld