From owner-freebsd-current@FreeBSD.ORG Wed Mar 31 01:32:42 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7FA8116A4D0 for ; Wed, 31 Mar 2004 01:32:40 -0800 (PST) Received: from mailout07.sul.t-online.com (mailout07.sul.t-online.com [194.25.134.83]) by mx1.FreeBSD.org (Postfix) with ESMTP id C176C43D55 for ; Wed, 31 Mar 2004 01:32:39 -0800 (PST) (envelope-from Alexander@Leidinger.net) Received: from fwd07.aul.t-online.de by mailout07.sul.t-online.com with smtp id 1B8c5C-00088O-03; Wed, 31 Mar 2004 11:32:26 +0200 Received: from Andro-Beta.Leidinger.net (GEUHxMZcrezJXCMkFlXA82oKNntWCCqgsHlCJflIuZ9z238I340Xcg@[84.128.201.149]) by fmrl07.sul.t-online.com with esmtp id 1B8c4u-0nEZv60; Wed, 31 Mar 2004 11:32:08 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i2V9W6u1056106; Wed, 31 Mar 2004 11:32:06 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from Magellan.Leidinger.net (netchild@localhost [127.0.0.1]) i2V9WBid027473; Wed, 31 Mar 2004 11:32:11 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 31 Mar 2004 11:32:11 +0200 From: Alexander Leidinger To: Martin Blapp Message-Id: <20040331113211.4aa71b8c@Magellan.Leidinger.net> In-Reply-To: <20040331095802.J84890@cvs.imp.ch> References: <20040331095802.J84890@cvs.imp.ch> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: GEUHxMZcrezJXCMkFlXA82oKNntWCCqgsHlCJflIuZ9z238I340Xcg@t-dialin.net cc: Dag-Erling =?ISO-8859-1?Q?Sm=F8rgrav?= cc: current@freebsd.org Subject: Re: performance of jailed processes X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 31 Mar 2004 09:32:42 -0000 On Wed, 31 Mar 2004 10:00:14 +0200 (CEST) Martin Blapp wrote: > > Hi DES, > > > Specifically, running a query against a remote MySQL server from > > inside a jail takes an order of magnitude more time than from outside > > the jail. Tcpdump shows that the TCP packets carrying the result are > > evenly spaced, so this is not a matter of the server timing out on a > > DNS lookup or anything like that. > > Could you try the following things ? Use libthr or libpthreads for mysql and > see if the results are still the same. Do the same test with linux-threads > (all our mysqls on 4.x with jails use linux-threads and we don't see any > problems) I just had a similar problem with MySQL on a system without jails (-current as of Mar 19), but with one IP-alias. Feeding the initial content of a DB from a 4.6 MB file needed too long (I aborted after two minutes). Binding MySQL to the main IP only didn't changed this. I recompiled with linux-threads and it finished importing the data after 20 seconds. I can't test more on this machine, since it is scheduled to go into production today or tomorrow, but I could add mysql to a test machine (with a more recent -current) and use the same file there if needed. Bye, Alexander. -- I'm available to get hired. http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7