From owner-freebsd-questions@FreeBSD.ORG Fri Mar 20 18:23:51 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E8B91106564A for ; Fri, 20 Mar 2009 18:23:51 +0000 (UTC) (envelope-from amvandemore@gmail.com) Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25]) by mx1.freebsd.org (Postfix) with ESMTP id 72C628FC0C for ; Fri, 20 Mar 2009 18:23:51 +0000 (UTC) (envelope-from amvandemore@gmail.com) Received: by ey-out-2122.google.com with SMTP id 4so174111eyf.7 for ; Fri, 20 Mar 2009 11:23:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=FxkRTv/WUsq5oDAOvzFyQ8Qa+569uSz52U9k/BPw8jQ=; b=i8K2TksnjET96Rt+8lh1mONRwntVvFiOnTTo8SDI/ipLGKvHfLmZfJpdjc4gY3p/ZM 47/qsw8aqpHmpqvYg7o2xKTx00wQVqyYKFLEESSXAkimme8L2IvvjWGZcruxC4MAlLrq dLLumvUhp0e1jn64wVqLzEZs26vDTus4ZxVJ0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=I7WhAR0dPKK1HLSi0PXjiE4cBkBh5Y4zfNGaFeD7twueAIf7Sbr8aT+NQTPz1XO3lX 4Fd1dj1Q0s5faj3Mkz+FZCk1Ynl1jmCIu6Vy8w953ndTpHMZiR/49+zYUd+/DFavUR5g 0Hs7eOMVOhC+lnf94zXDhE2MSfxLwhynRf458= Received: by 10.216.70.130 with SMTP id p2mr1562881wed.190.1237573430227; Fri, 20 Mar 2009 11:23:50 -0700 (PDT) Received: from ?216.16.29.53? (host-53.216-16-29.iw.net [216.16.29.53]) by mx.google.com with ESMTPS id g11sm3679055gve.17.2009.03.20.11.23.48 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 20 Mar 2009 11:23:49 -0700 (PDT) Message-ID: <49C3DF33.3060403@gmail.com> Date: Fri, 20 Mar 2009 13:23:47 -0500 From: Adam Vandemore User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: MySQL 5.0 on FreeBSD 7 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 20 Mar 2009 18:23:52 -0000 Matt Juszczak wrote: > Hi all, > > About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit). > I read at the time that the use of pthreads with FreeBSD would > significantly improve performance, but as I was running the 64 bit > version of FreeBSD, I could not use them. > > Fast forward to today - a different setup and new opportunity has > allowed me to research this combination again. This time, some > reading I have done on the use of FreeBSD 7 with MySQL has shown > significant performance increases, but none of them really mention in > detail how MySQL was setup. > > I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 > GB RAM in the box) and attempt to build with pthreads enabled, as well > as a static build and optimized compiler options. Once again, got the > error/warning in ports that the linux pthreads only works with the > i386 32 bit setup. > > So I'm wondering if anyone here has successfully seen a MySQL 5.x > performance boost with FreeBSD 7 compared to that of FreeBSD 6 on a 64 > bit architecture, and if so, what they did to enable that boost. > > Thanks! > > -Matt > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > ULE scheduler is a big performance increase. That's the default scheduler in 7.1 but not 7.0. You can check this out for more detail. -- Adam Vandemore Systems Administrator IMED Mobility (605) 498-1610