From owner-freebsd-questions@FreeBSD.ORG Mon Jul 7 14:21:56 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 E61CA1065674 for ; Mon, 7 Jul 2008 14:21:56 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: from mx1.identry.com (on.identry.com [66.111.0.194]) by mx1.freebsd.org (Postfix) with ESMTP id 786218FC22 for ; Mon, 7 Jul 2008 14:21:56 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: (qmail 84917 invoked by uid 89); 7 Jul 2008 14:21:55 -0000 Received: from unknown (HELO ?192.168.1.110?) (jalmberg@75.127.142.66) by mx1.identry.com with ESMTPA; 7 Jul 2008 14:21:55 -0000 Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: <48721BB5.1050203@infracaninophile.co.uk> References: <4870894E.7090708@infracaninophile.co.uk> <200807061759.12129.fbsd.questions@rachie.is-a-geek.net> <48721BB5.1050203@infracaninophile.co.uk> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: John Almberg Date: Mon, 7 Jul 2008 10:21:53 -0400 To: freebsd-questions@freebsd.org X-Mailer: Apple Mail (2.752.3) 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 14:21:57 -0000 > Yes, that could be the case if the database was transferred by > doing mysqldump > on the first machine and then loading the dump on the second. This is indeed what I did. Odd that you ask this question, because my very first guess about this issue was that the database was corrupted in some way. However, I could not find any evidence of corruption, per se. I didn't realize that mysql records could become 'fragmented'... I guess this means the records are fragmented on disk as the database file is updated over time. The records in question (mainly product data) are not changed very often, and had been moved (using mysqldump) to this new machine in the last 6 weeks or so. So this doesn't sound like a likely cause. However, a very interesting thing to know... -- John