MySQL Ver 3.22.32

[Martin Foster <mfoster@redwhite.com>]

Uname:
OpenBSD thebe 2.8 compile#3 i386

Patches:
All patches applied to 2.8 up to 011.   The system was an upgrade from
2.7.   

Port:
MySQL Ver 3.22.32 for unknown-openbsd2.8 on i386

Problem:
Port compiles cleanly, and installs without a hitch.  After using
./safe_mysqld & the database will start responding to requests. 
However, when I look that the error logs under /var/mysql I get the
following lines on a very frequent basis:

Memory fault
mysqld restarted on  Fri Dec 15 22:20:25 MST 2000
/usr/local/libexec/mysqld: ready for connections
Memory fault
mysqld restarted on  Fri Dec 15 22:28:24 MST 2000
/usr/local/libexec/mysqld: ready for connections
Killed
mysqld restarted on  Fri Dec 15 23:01:47 MST 2000
/usr/local/libexec/mysqld: ready for connections
Memory fault

Under 2.7 this would resort in a core dump as well.   Now this is just
one of the problems I have noticed under 2.8.  The other problem is that
after a few hours of usage mysqld will literally take up 97 to 99% of
the CPU resources.   

I have attempted to force MySQL to flush it's table information every
1/2 hour to no avail.  Also, when I switched to PostgreSQL this problem
was not reproduced, even under heavier loads. 

MySQL was built using the ports tree found in /OpenBSD/2.8/ of the FTP
server.  Is there any way to actually make it not take up all
resources.  I could care less about the error logs for now. 

					Martin Foster
					mfoster@redwhite.com