Re: Lost connections with mysql-server-4.0.23p1

[Toni Mueller <openbsd-ports_(_at_)_oeko_(_dot_)_net>]

Hi,

On Wed, 14.09.2005 at 13:26:00 -0400, Jason Dixon <jason_(_at_)_dixongroup_(_dot_)_net> wrote:
> I've got an OpenBSD 3.7 server with mysql-server-4.0.23p1.tgz  

I'm running the same software, and encounter

"bad file descriptor" errors more often than not.

Can somebody please take care to set higher limits for MySQL on
installing the server part of the port, please?

> installed from packages.  Once a week or so, the mysql server will  
> stop taking queries, commands, etc.

This happens at least once a day over here. In that case, MySQL needs
to be restarted by force to get going again. I've made a band-aid for
this, but a solution is very much preferred.

> There are no error messages in /var/mysql/`hostname`.err that would  
> suggest anything is wrong.

> Has anyone else run into problems with  this version?  Any success
> stories with the newest 4.1.14 port  running on 3.7?

I'm trying to move to 3.8 to see if anything gets better, but am
generally not overly happy with MySQL on OpenBSD 8-(


Kind Regards,
--Toni++