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

Reply via email to