From owner-freebsd-database@FreeBSD.ORG Fri Aug 19 16:12:23 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F30C916A41F for ; Fri, 19 Aug 2005 16:12:22 +0000 (GMT) (envelope-from scianos@seq.org) Received: from mail.seq.org (mail.seq.org [205.132.248.10]) by mx1.FreeBSD.org (Postfix) with SMTP id BA11F43D45 for ; Fri, 19 Aug 2005 16:12:22 +0000 (GMT) (envelope-from scianos@seq.org) Received: from smtp-gw.seq.org ([192.168.1.10]) by mail.seq.org (SMSSMTP 4.1.0.19) with SMTP id M2005081909122113906 for ; Fri, 19 Aug 2005 09:12:21 -0700 Received: from SEQ_UHSD-MTA by smtp-gw.seq.org with Novell_GroupWise; Fri, 19 Aug 2005 09:12:22 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.0 Date: Fri, 19 Aug 2005 09:12:15 -0700 From: "Stuart Cianos" To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Cc: uzi@bmby.com Subject: RE: FreeBSD hardware solution for a database server (Uzi) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Aug 2005 16:12:23 -0000 Hi Uzi - That is a decent configuration for a variety of tasks. What type of speed = issues are you seeing: is it limited to a couple of queries? How many = transactions are you running in a given time period? Have you optimized = the indexes on your tables for your particular tasks and/or operations? If you copy your configuration file and post it to the list (make sure you = remove any sensitive info like usernames or passwords, if you store that = type of thing in there) we might be able to help you a bit more. If you = haven't tuned your config file for your particular configuration, then = this can also result in performance not being up to par. Ensure that your = kernel is compiled for SMP capability and that your MySQL is compiled with = optimization ON for maximum throughput. While the optimization doesn't = make a huge difference in the short run, millions of transactions later a = couple of miliseconds here and miliseconds there add up to real time. RAID 0/1 is ideal, although RAID 5 is very sufficient for most all = purposes in this case. If we were running Oracle or Sybase, then different = RAID configurations suit different storage requirements, i.e. RAID 5 for = the table data storage and RAID 0/1 for the transaction logs. There = reasons for this get fairly technical, but if you are interested in the = reasons behind this you can google the topic. MySQL doesn't have such = demanding performance tuning requirements. - Stuart *- Message: 1 Date: Fri, 19 Aug 2005 14:31:39 +0200 From: "Uzi" Subject: FreeBSD hardware solution for a database server=20 To: , Message-ID: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> Content-Type: text/plain; format=3Dflowed; charset=3D"windows-1255"; reply-type=3Doriginal Hi I am looking for a FreeBSD 5.4 hardware/configuration solutions for a = MySQL=20 database server. My server is currently running FreeBSD 5.4 with a web/mail/database = server=20 on a Proliant DL380 G4 (dual Xeon 3.2, 2 GB ram), and the speed isn't = fast=20 enough. We have a pretty big database with allot of complex joins/indexes, so a=20 dedicated database server seems like the next step (among with=20 optimizing/normalizing the database). Proliant DL580 looks fair to my eyes (as I'm pretty happy with HP) But I have a few indecisions: 1. 2/4 CPU 2. Amount of ram (4 GB+) 3. And most important (AFAIK) - Storage configuration (RAID 5 / RAID = 0+1=20 etc.) What would be the preferred solution? Thanks, Uzi P.S - Please CC me the replies as I'm not subscribed. Thanks.