From owner-freebsd-amd64@FreeBSD.ORG Sat May 1 20:14:47 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2584816A4CE for ; Sat, 1 May 2004 20:14:47 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0C42343D45 for ; Sat, 1 May 2004 20:14:47 -0700 (PDT) (envelope-from Jeremy@jpgsworld.com) Received: (qmail 14590 invoked by uid 89); 29 Apr 2004 00:10:26 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (67.172.167.223) by host180.ojoink.com with SMTP; 29 Apr 2004 00:10:26 -0000 Message-Id: <5.2.0.9.2.20040428170631.014778f0@127.0.0.1> X-Sender: mail.ojoink.com/110/jeremy@jpgsworld.com@127.0.0.1 (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Wed, 28 Apr 2004 17:08:05 -0700 To: freebsd-amd64@freebsd.org From: Jeremy Gray Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: FreeBSD AMD64 + high performance MySQL - Possible? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 May 2004 03:14:47 -0000 A person I know runs a very large forum using a dual AMD Opteron box running AMD64 Linux for the MySQL database backend. I think he does several thousand concurrent connections per second or something. I intend to do the same, and have the hardware sitting here to do it... But alas, I am a FreeBSD user and would like to stay that way for this database server if possible. I read a lot on Jeremy Zawodny's BLOG site (Yahoo's server god I guess) where he initially slammed MySQL on FreeBSD because of FreeBSD's poor thread support vs linux and then made several follow ups.... The first stating that if you compile MySQL on FreeBSD with inuxThreads support it will eliminate the poor threading issue. (Which, afaik, is not an option for me on AMD64) The second follow up he made was that FreeBSD 5.2 and on (for i386) use a new threading method (called?) that helps resolve FreeBSD's threading issues with MySQL. But I noticed in just last weeks archives that people were still discussing FreeBSD + MySQL problems... presumably on intel architecture. Several weeks ago the MySQL port maintainer Alex Dupre was given access to our Opteron machine in order to make optimizations the port for AMD64. But I think at the time he said the new threading was still being worked on or something. So I guess my question is... does anyone know the best way to compile MySQL on an AMD64 box without too much (or any) performance loss over an identical linux machine? If anyone from the FreeBSD/AMD64 dev team would like to use our hardware to optimize threading for MySQL on AMD64, and compare the results to a linux install (I have a linux install on identical drive we can swap out)... I would be more than willing to donate access to interested and qualified parties. Dual Opteron 241 CPUs, 2 Gigs ram. Tyan S2880UGNR w/ LSI Zero Channel Raid card 4x 15k rpm SCSI drives running 2 raid 0 channels. Swapable OS/system drive. Thanks for any information!