From owner-freebsd-stable@FreeBSD.ORG Wed Jun 22 11:02:00 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A24EE16A41C for ; Wed, 22 Jun 2005 11:02:00 +0000 (GMT) (envelope-from michael.schuh@gmail.com) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.197]) by mx1.FreeBSD.org (Postfix) with ESMTP id 361AE43D55 for ; Wed, 22 Jun 2005 11:02:00 +0000 (GMT) (envelope-from michael.schuh@gmail.com) Received: by nproxy.gmail.com with SMTP id g2so16401nfe for ; Wed, 22 Jun 2005 04:01:58 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dd8wwGH2IU46sKXUvZXWLqu0roa8uSurHCJYLSFecTSz5PN9rikrSKAiQe35IVAlhs179K6YOI/eq/XSvqvLzlA9WcNlAdmYLW0JelWo5tejgDxClOkU8RUI0mBRR+ZS+9U58gb7NTgIUbkmQxkVKWAt7c/tqWPRFB8XR9zqKvU= Received: by 10.48.240.16 with SMTP id n16mr13797nfh; Wed, 22 Jun 2005 04:01:58 -0700 (PDT) Received: by 10.48.244.20 with HTTP; Wed, 22 Jun 2005 04:01:58 -0700 (PDT) Message-ID: <1dbad31505062204012e0d42a3@mail.gmail.com> Date: Wed, 22 Jun 2005 13:01:58 +0200 From: Michael Schuh To: freebsd-stable@freebsd.org, Oliver Fromme In-Reply-To: <200506220936.j5M9aR2a059385@lurza.secnetix.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1dbad31505062108011b812ba8@mail.gmail.com> <200506220936.j5M9aR2a059385@lurza.secnetix.de> Cc: Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Michael Schuh List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Jun 2005 11:02:00 -0000 Hi Oliver, 2005/6/22, Oliver Fromme : > Michael Schuh wrote: > > now i have another question, if i use the same Os in 2 versions > > (RELENG_4, RELENG_5) can i hope that the tests are made on the same > > part of disk? >=20 > > Hope you always can. But rely on it you should not. > > ;-) >=20 That's right. :-D > > or in other words can an dd on the two OS' es so much different > > because they use an > > totally other part of disk? I think no, the strategie from dd under > > one OS should not be changed if the OS-Version has changed. >=20 > It's not the dd which decides where to put the file, it's > the filesystem code. And yes, there can be differences > between RELENG_4 and RELENG_5. In particular, in RELENG_5 > you have UFS2, not the old UFS. There have always been > changes to the FS code, for example I remember that the > allocation of directories has changed some time ago to > improve metadata performance for large trees (known as > "dirpref"). >=20 > As I said: The only way to make sure you hit the same > physical place on the disk is to use a raw partition, not > a file on some filesystem. >=20 Yes i have that understand. And that was the reason why i make in future these tests new with an raw-partition on the same part of disk. so that i never must hope, so i become knowledge and i know the facts :-D > Note that even small differences in the placement of the > file can have a noticeable effect on the speed. Apart > from the speed differences of the disk cylinders, it can > also happen that the file is allocated in a non-contiguous > way, especially if it is large and the filesystem already > contains a lot of files, and/or had a lot of write+delete > operations previously (i.e. causing fragmentation). >=20 yes this is also clear for me, but in my case, it was only a small disk (8GB) and it has only the OS, nothing more, nothing less. And as i made these tests, i have all the performance for me and my OS. *grrrrr* i be the master of disaster.......... *lol* We should have all more humor.......the life it's more funny...... > > the part with serial IO related to database-performance have i > > understand, but i quests me have the others understand > > my meanings? >=20 i must hope so :-D, i can not sure > That I don't know. >=20 > Best regards > Oliver >=20 > -- > Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 M=FCnchen > Any opinions expressed in this message may be personal to the author > and may not necessarily reflect the opinions of secnetix in any way. >=20 > "anyone new to programming should be kept as far from C++ as > possible; actually showing the stuff should be considered a > criminal offence" -- Jacek Generowicz >=20 thank you for your suggestions best regards Michael Schuh