Hi Kiraly,
> mysql error: Can't create/write to file '/tmp/
> #sql_4c99_0.MYD' (Errcode: 9)
MySQL problem.
Simple suggestions, not idiot-proof:
/etc/my.cnf:
[mysqld_safe]
open-files = 1024
Up kern.maxfiles, if needed. `sysctl -w kern.maxfiles=17720`, for
instance. Modify /etc/sysctl.conf to make changes permanent.
/etc/login.conf changes:
daemon:\
:ignorenologin:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=1024:\ <--- check this one
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
and/or:
default:\
:path=/usr/bin /bin /usr/sbin /sbin /usr/X11R6/bin /usr/local/
bin:\ :umask=022:\
:datasize-max=512M:\ <--- check this one
:datasize-cur=256M:\ <--- check this one
:maxproc-max=128:\
:maxproc-cur=64:\
:openfiles-cur=1024:\ <--- check this one
:stacksize-cur=4M:\
:localcipher=blowfish,6:\
:ypcipher=old:\
:tc=auth-defaults:\
:tc=auth-ftp-defaults:
Whatever suits your need. A reboot will make mysql run in class daemon,
if you start mysql with `sudo mysqld_safe &`, you'll most probably be
in class default. That's why I upped both.
If I am wrong, somebody will kick me in the nuts, so do check back
here. ;-)
I've had problems with both open files and memory limits. Those
problems are gone now.
HTH... Nico
