vladimir plotnikov wrote:
Hello!
I have installed OpenBSD 3.8 and MySQL server 4.0.24 (from ports)
From time to time (after high load) I got next - mysql drops connects
by TCP/IP (simple connection closed after telnet to port 3306) and
next in logs:
Few lines like
060620 14:51:06 [ERROR] /usr/local/libexec/mysqld: Can't find file:
'./tasktrack
er/mantis_news_table.frm' (errno: 9)
then, after I send HUP signal to mysqld process, I got next in error
output:
Why not install 3.9 and then the package for MySQL at 5.0.22.
Also, great that you increase MySQL limits as looks like you need it,
but may be you shoudl also look at:
man sysctl.conf for kern.maxfiles
and more importantly, login.conf as well and make sure you start MySQL
with the call you increase the limits for as if not you will get the
default limits that you will hit.
May be something like:
# Start MySQL server
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c '/usr/local/bin/mysqld_safe &' > /dev/null fi
rc.local might fix your issue.
All discribe in the archive as well.
So, install 3.9, why do old if you just install a new box, then 5.0.22
if that's i386, that's the latest stable package, then add a class for
use by <MySQL in login.config, then make sure you start MySQL using it
and then also increse your limits in sysctl.conf.
After that you will be fine.
Again, all explain in archive.
Daniel