From owner-freebsd-questions@FreeBSD.ORG Wed Jun 4 09:36:39 2008 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 6F7911065678 for ; Wed, 4 Jun 2008 09:36:39 +0000 (UTC) (envelope-from joerg@mysql.com) Received: from mailgate-b.mysql.com (mailgate-b.mysql.com [64.212.38.36]) by mx1.freebsd.org (Postfix) with ESMTP id F31FA8FC1A for ; Wed, 4 Jun 2008 09:36:38 +0000 (UTC) (envelope-from joerg@mysql.com) Received: from mail.mysql.com (mailsend.mysql.com [10.100.1.123]) by mailgate-b.mysql.com (8.13.8/8.13.8) with ESMTP id m549aatP001497 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 4 Jun 2008 11:36:36 +0200 Received: from [192.168.0.54] (p57A08264.dip0.t-ipconnect.de [87.160.130.100]) (authenticated bits=0) by mail.mysql.com (8.13.3/8.13.3) with ESMTP id m549aVwL017388 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 4 Jun 2008 11:36:32 +0200 Message-ID: <4846621D.6020102@mysql.com> Date: Wed, 04 Jun 2008 11:36:29 +0200 From: Joerg Bruehe User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: VeeJay References: <2cd0a0da0806030343o68dcf30bj447d4174b93c30d2@mail.gmail.com> In-Reply-To: <2cd0a0da0806030343o68dcf30bj447d4174b93c30d2@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: quoted-printable Cc: mysql@lists.mysql.com, FreeBSD-Questions Subject: Re: FreeBSD MySQL Performance Tunning suggestions??? 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: Wed, 04 Jun 2008 09:36:39 -0000 Hi all ! VeeJay wrote: > [[...]] >=20 > At my job, I am going to build a Web Server with >=20 > 1. FreeBSD 7.0-RELEASE amd64 > 2. Apache 2.2.8 > 3. PHP 4.4.8 (or may be PHP5, what do you suggest?) >=20 > Server's hardware configuration is as follow: >=20 > 2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB > 16GB (8x2GB Dual Rank DIMMs) 667MHz FBD > 6 x 450GB SAS 15k 3.5" HD Hot Plug > PERC 6/i, Integrated Controller Card x6 backplane > PE2950 III C5 MSS R10 Add-in PERC 5/i / 6/i 1 S > TCP/IP Offload Engine 2P > Broadcom TCP/IP Offload Engine functionality (TOE) Not Enabled >=20 > For FreeBSD 7.0-RELEASE amd64 Which MySQL 5.0 would be used ? > 1. FreeBSD 7.x (x86_64) > or > 2. FreeBSD 6.x (x86) Your machine has 16 GB of RAM. If you ever want to use really large caches in the MySQL server process, = you need to use a 64 bit binary, called "x86_64" in the MySQL package=20 file names. >=20 > I have done some googling and made these configuration files for Apache= and > MySQL? >=20 > Apache: > httpd.conf-----------------------------------------------------start---= --------- > [[... file snipped ...]] >=20 >=20 > MySQL: > my.cnf------------------------------------------------------------start= -------- > [[... file snipped ...]] >=20 >=20 > Is there something you can tune? You cannot tune without knowing which bottleneck you should widen, and=20 how much resources still are available. IMNSHO, you need to start with some configuration, put load onto it (as=20 representative as possible), then watch the system's behavior (take=20 measurements !), and only then determine which part you want to improve. Example: Database caches are good to reduce disk I/O and so to increase=20 performance, but you will not increase caches if your system is already=20 paging heavily (=3D your RAM is too small). There is no need to change any parameter unless a) its current setting restricts your performance, and you have sufficient resources to raise the limit, or b) its current setting allocates more resources than needed here, which could be used better at some other place. You need some initial run and measurement to check that. HTH, J=F6rg --=20 Joerg Bruehe, MySQL Build Team, joerg@mysql.com Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028