From owner-freebsd-questions@FreeBSD.ORG Mon Jul 7 13:22:04 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 97D131065672 for ; Mon, 7 Jul 2008 13:22:04 +0000 (UTC) (envelope-from rvm@CBORD.com) Received: from smssmtp.cbord.com (mx1.cbord.com [24.39.174.11]) by mx1.freebsd.org (Postfix) with ESMTP id 448F08FC1A for ; Mon, 7 Jul 2008 13:22:03 +0000 (UTC) (envelope-from rvm@CBORD.com) X-AuditID: ac1f0165-00000ab0000003c0-0c-4872185b4fed Received: from Email.cbord.com ([10.1.1.100]) by smssmtp.cbord.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 7 Jul 2008 09:21:31 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Mon, 7 Jul 2008 09:19:03 -0400 Message-ID: In-Reply-To: <200807061759.12129.fbsd.questions@rachie.is-a-geek.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Why would it make such a difference to move mysqld to anothermachine? Thread-Index: AcjfgS9mpEGCdhk+TeaMFNrwIDyjLAAsc3kg References: <4870894E.7090708@infracaninophile.co.uk> <200807061759.12129.fbsd.questions@rachie.is-a-geek.net> From: "Bob McConnell" To: X-Brightmail-Tracker: AAAAAA== Subject: RE: Why would it make such a difference to move mysqld to anothermachine? 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: Mon, 07 Jul 2008 13:22:04 -0000 On Behalf Of Mel On Sunday 06 July 2008 10:58:54 Matthew Seaman wrote: >> I suspect that you could have achieved a pretty good speed-up simply by >> adding another hard drive to your server and moving all of the database >> onto it, separate from the web root and any other areas which apache >> would be doing a lot of read/write operations on. I have not been following this thread closely, and I don't know much about MySQL, but I do have a question here. Is it possible that the process of moving the database to the second machine also resulted in cleaning up (defragmenting?) the files and reordering some tables to more closely match their indexes? Would this reduce the response time on the new server, at least until a significant amount of additional data was added that reverses these effects? Thank you, Bob McConnell