From owner-freebsd-net@FreeBSD.ORG  Mon Oct 10 06:22:27 2005
Return-Path: <owner-freebsd-net@FreeBSD.ORG>
X-Original-To: freebsd-net@freebsd.org
Delivered-To: freebsd-net@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 7D1C316A41F
	for <freebsd-net@freebsd.org>; Mon, 10 Oct 2005 06:22:27 +0000 (GMT)
	(envelope-from on@cs.ait.ac.th)
Received: from mail.cs.ait.ac.th (mail.cs.ait.ac.th [192.41.170.16])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3B55B43D46
	for <freebsd-net@freebsd.org>; Mon, 10 Oct 2005 06:22:25 +0000 (GMT)
	(envelope-from on@cs.ait.ac.th)
Received: from banyan.cs.ait.ac.th (banyan.cs.ait.ac.th [192.41.170.5])
	by mail.cs.ait.ac.th (8.12.11/8.12.11) with ESMTP id j9A6MM8p043890
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <freebsd-net@freebsd.org>; Mon, 10 Oct 2005 13:22:22 +0700 (ICT)
Received: (from on@localhost)
	by banyan.cs.ait.ac.th (8.13.1/8.12.11) id j9A6MMbW014091;
	Mon, 10 Oct 2005 13:22:22 +0700 (ICT)
Date: Mon, 10 Oct 2005 13:22:22 +0700 (ICT)
Message-Id: <200510100622.j9A6MMbW014091@banyan.cs.ait.ac.th>
From: Olivier Nicole <on@cs.ait.ac.th>
To: freebsd-net@freebsd.org
X-Virus-Scanned: on CSIM by amavisd-milter (http://www.amavis.org/)
Subject: SYN limit
X-BeenThere: freebsd-net@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Networking and TCP/IP with FreeBSD <freebsd-net.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-net>,
	<mailto:freebsd-net-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-net>
List-Post: <mailto:freebsd-net@freebsd.org>
List-Help: <mailto:freebsd-net-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-net>,
	<mailto:freebsd-net-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 10 Oct 2005 06:22:27 -0000

Hi,

I am facing the following problem: I have a web server with an
application that calls a MySQL server.

For class and test run, I may have 100 users accessing the same web
page to login to the same database.

For some reason, it seems that the MySQL server only accepts 50
connections to the same resource comming from the same client at one
given time. 50 other connections are in SYN_SENT state.

Any reason why this limit? 

Both servers are CPU idled 90% or more, disk are running max 5
transactions/second, network is local LAN and busy less than 5%.

It could be a MySQL limit, but MySQL maxconnection is set to 250,
so...

Thanks in advance,

Olivier