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--