Subject: Re: Lost connection to MySQL server during query
To: Joseph A. Dacuma <jadacuma@ched.gov.ph>
From: Greg A. Woods <woods@planix.com>
List: netbsd-users
Date: 03/12/2007 16:23:01
--pgp-sign-Multipart_Mon_Mar_12_16:22:54_2007-1
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

At Tue, 13 Mar 2007 00:51:06 +0800 (PHT),
Joseph A. Dacuma wrote:
>=20
> Hi Mr. Hassfeld!
>=20
> Thanks for your speedy reply! I failed to indicate in my original post
> about my kernel settings. Like yours, my maxusers is 128 and so as my
> nofiles. At the onset the values for the semaphores are quite high and
> will surely work. I tried the exact settings you gave but bummer of all
> bummers still the same error.
>=20
> I also noticed that both SHMSEG and SEMMAP are not listed on the manual
> pages for options.

Examination of the netbsd-4 source shows the following config(8)
parameters still apply (an excerpt from my sys/arch/*/conf/* files):

# System V compatible IPC subsystem.  (msgctl(2), semctl(2), and shmctl(2))
#
options 	SYSVMSG		# System V-like message queues
# note none of the following are def-opt'ed yet, but they are only in
# sys/msg.h and conf/param.c
#options 	MSGMNI=3D40	# max number of message queue identifiers
#options 	MSGMNB=3D2048	# max size of a message queue
#options 	MSGTQL=3D40	# max number of messages in the system
#options 	MSGSSZ=3D8	# size of a message segment (must be 2^n, n>4)
#options 	MSGSEG=3D2048	# max number of message segments in the system
				# (must be less than 32767)
# note MSGMAX is always recomputed as (MSGSSZ*MSGSEG)
#
options 	SYSVSEM		# System V-like semaphores
#options 	SEMMNI=3D10	# max number of semaphore identifiers in system
#options 	SEMMNS=3D60	# max number of semaphores in system
#options 	SEMMNU=3D30	# number of undo structures in system
#options 	SEMUME=3D10	# max number of undo entries per process
# note none of the following are def-opt'ed yet, but they are only in
# sys/sem.h and conf/param.c
#options 	SEMMAP=3D30	# # of entries in semaphore map
#options 	SEMOPM=3D100	# max # of operations per semop call
#options	SEMMSL=3DSEMMNS	# max # of semaphores per id
#
options 	SYSVSHM		# System V-like memory sharing
#options 	SHMMAXPGS=3D2048	# Size of shared memory map
# note none of the following are def-opt'ed yet, but they are only in
# conf/param.c
#options 	SHMMAX=3DSHMMAXPGS # max shared memory segment size (bytes)
#options 	SHMMIN=3D1	# min shared memory segment size (bytes)
#options 	SHMMNI=3D128	# max number of shared memory identifiers
#options 	SHMSEG=3D128	# max shared memory segments per process
# note SHMALL is not tunable (must be same as SHMMAXPGS)

--=20
						Greg A. Woods

H:+1 416 218-0098 W:+1 416 489-5852 x122 VE3TCP RoboHack <woods@robohack.ca>
Planix, Inc. <woods@planix.com>       Secrets of the Weird <woods@weird.com>

--pgp-sign-Multipart_Mon_Mar_12_16:22:54_2007-1
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
MessageID: RAQNju78K/12RrvMgjQ/3CDsAy8gSQQf

iQA/AwUBRfW2oGZ9cbd4v/R/EQJApQCfarYP3U3Dk9afQ4C99mX060epSa4An3GH
h5PtDbWIOhNAk68C5rboajx8
=o7ZU
-----END PGP SIGNATURE-----

--pgp-sign-Multipart_Mon_Mar_12_16:22:54_2007-1--