Sections
|
 |
|
|
MySQL and OpenBSD
A tip.
After installation of MySQL, you should edit the file /usr/local/bin/safe_mysqld:
Look for the line with a #-sign in front of ulimit -n 256. Remove that
comment token and MySQL has some room to breathe.
Explanation: by default, a user is permitted to open only 64 files at a time. When you are
greedy and want more, you should execute a ulimit -n 256 for instance. The MySQL
binary package in de OpenBSD packages directory does not raise its limit of 64 files by default,
so it runs out of file descriptors rather fast, leading to strange, seamingly inconsistent,
errors.
|
