On Wed, 2005-06-15 at 11:30 +0200, Nico Meijer wrote:
> Hi Kiraly,
>
> > mysql error: Can't create/write to file '/tmp/
> > #sql_4c99_0.MYD' (Errcode: 9)
>
> MySQL problem.
>
> Simple suggestions, not idiot-proof:
I prefer this on OpenBSD 3.6 (should be same on 3.7):
Add to /etc/login.conf:
#
# for mysql to work right
#
mysql:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=2048:\
:openfiles-max=8192:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
sudo vipw and change the login class for _mysql to 'mysql'.
To use this class, you MUST use 'sudo -c mysql -u _mysql', like this
(can be put in /etc/rc.local):
sudo -c mysql -u _mysql /usr/local/sbin/mysql.server start
This may be useful as well (can also put in /etc/sysctl.conf):
sudo sysctl -w kern.maxfiles=16384
And finally, add to /etc/my.cnf on (OpenBSD 3.6 with mysql 4.0.20):
[mysqld]
...
open-files=1000
...
Jamie Strandboge
