MySQL Manual
2 MySQL Installation
2.6.4.4 OpenBSD 2.8 Notes
Our users have reported that OpenBSD 2.8 has a threading bug which causes problems with MySQL. The OpenBSD Developers have fixed the problem, but as of January 25th, 2001, it's only available in the ``-current'' branch. The symptoms of this threading bug are: slow response, high load, high CPU usage, and crashes.
If you get an error like Error in accept:: Bad file descriptor or
error 9 when trying to open tables or directories, the problem is probably
that you haven't allocated enough file descriptors for MySQL.
In this case, try starting mysqld_safe as root with the following
options:
shell> mysqld_safe --user=mysql --open-files-limit=2048 &
User Comments
| Posted by [name withheld] on Sunday June 8 2003, @2:32am | [Delete] [Edit] |
I run OpenBSD 3.2, and whenever I output a large ammount of data with MySQL (usually though phpMyAdmin, but I'm sure it would do the same with any software) I'd get the same error. Thanks!
