On Mon, Mar 12, 2007 at 09:42:04PM +0800, Joseph A. Dacuma wrote:
> Please also note that on both machines, I tried using using a default
> large my.cnf. I also tried both with modifications on the following:
> 
> query_cache_limit = 4M
> query_cache_size = 128M
> bulk_insert_buffer_size = 8M

The query cache size will exceed the default process memory limit.
You probably want to change this bit in "/etc/rc.d/mysqld":

	ulimit -n 4096
	ulimit -d `ulimit -d -H`		<-- add this
	cd /usr/pkg
	${command} --user=${mysqld_user} --datadir=${mysqld_datadir} \
		   --pid-file=${pidfile} ${mysqld_flags} &

	Kind regards

-- 
Matthias Scheler                                  http://zhadum.org.uk/