From owner-freebsd-performance@FreeBSD.ORG Wed Dec 28 06:02:41 2005 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F34F516A41F for ; Wed, 28 Dec 2005 06:02:40 +0000 (GMT) (envelope-from chrcoluk@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1995D43D70 for ; Wed, 28 Dec 2005 06:02:31 +0000 (GMT) (envelope-from chrcoluk@gmail.com) Received: by wproxy.gmail.com with SMTP id 71so1160667wra for ; Tue, 27 Dec 2005 22:02:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=jsz7SSz0Q697Znn2pJCaL8CfiBMsElK85/yhPnFP3T90njcFjmLq/xjE8XoRKWKhx1p5p2VZ2zNW0ftP99sdPxiK4khmCZ+5iDBVwE+97Bc4c+kyJ2tJcbfwXLlkbxLFHciWwQij7dW7fP6c8Gl6qJBJ9U0OBICDt4uiG08yS2A= Received: by 10.54.110.19 with SMTP id i19mr8044550wrc; Tue, 27 Dec 2005 22:02:31 -0800 (PST) Received: by 10.54.122.17 with HTTP; Tue, 27 Dec 2005 22:02:31 -0800 (PST) Message-ID: <3aaaa3a0512272202u715ccb4fo@mail.gmail.com> Date: Wed, 28 Dec 2005 06:02:31 +0000 From: Chris To: Michael Vince In-Reply-To: <43B0BB44.40708@roq.com> MIME-Version: 1.0 References: <20051216064615.GA41775@gslin.org> <20051216070609.GA3216@il.fontys.nl> <20051216204322.GA66409@gslin.org> <43A35A1E.3020408@samsco.org> <3aaaa3a0512221304p3a35b1ecj@mail.gmail.com> <43B0BB44.40708@roq.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-performance@freebsd.org Subject: Re: Benchmark MySQL Performance On FreeBSD And Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Dec 2005 06:02:41 -0000 > > Make sure your compile your MySQL dynamically which is done by default, > if you include 'BUILD_STATIC=3Dyes' you ruin your ability to change > threading libs. > > portupgrade -N -m 'BUILD_OPTIMIZED=3Dyes' > /usr/ports/databases/mysql41-server > Or upgrade > portupgrade -R -m 'BUILD_OPTIMIZED=3Dyes'/var/db/pkg/mysql-server-4.1.14 > > > Use 'ldd' to find which threading library you are using. > > ldd /usr/local/libexec/mysqld > /usr/local/libexec/mysqld: > libz.so.3 =3D> /lib/libz.so.3 (0x800978000) > libwrap.so.4 =3D> /usr/lib/libwrap.so.4 (0x800a8b000) > libcrypt.so.3 =3D> /lib/libcrypt.so.3 (0x800b94000) > libstdc++.so.5 =3D> /usr/lib/libstdc++.so.5 (0x800cad000) > libm.so.4 =3D> /lib/libm.so.4 (0x800ea4000) > libpthread.so.2 =3D> */usr/lib/libpthread.so.2* (0x800fc0000) > libc.so.6 =3D> /lib/libc.so.6 (0x8010eb000) > > Put something like this into your /etc/libmap.conf to change your > threading library, and restart the service in question for the library > change to take effect. > [/usr/local/libexec/mysqld] > libpthread.so.2 libthr.so.2 > libpthread.so libthr.so > > # ldd /usr/local/libexec/mysqld > /usr/local/libexec/mysqld: > libz.so.3 =3D> /lib/libz.so.3 (0x800978000) > libwrap.so.4 =3D> /usr/lib/libwrap.so.4 (0x800a8b000) > libcrypt.so.3 =3D> /lib/libcrypt.so.3 (0x800b94000) > libstdc++.so.5 =3D> /usr/lib/libstdc++.so.5 (0x800cad000) > libm.so.4 =3D> /lib/libm.so.4 (0x800ea4000) > libpthread.so.2 =3D> */usr/lib/libthr.so.2* (0x800fc0000) > libc.so.6 =3D> /lib/libc.so.6 (0x8010d7000) > > > > Ok thanks just 2 more questions. (a) if I build dynamic there is no performance penalty? since the Makefile states build static for performance. (b) I have no /etc/libmap.conf it doesnt exist, so if I just create one and enter what you say it will work? Chris