Subject: Re: Lost connection to MySQL server during query
To: Matthias Scheler <tron@zhadum.org.uk>
From: Joseph A. Dacuma <jadacuma@ched.gov.ph>
List: netbsd-users
Date: 03/14/2007 20:45:17
Hi Mr. Scheler!
>
> 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/
>

Whoa! It worked! Thanks to all who replied.

Warm regards,

Joseph