From owner-freebsd-questions@FreeBSD.ORG  Thu Dec  8 23:29:42 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id BC05716A41F
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Dec 2005 23:29:42 +0000 (GMT)
	(envelope-from joao.barros@gmail.com)
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.205])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B615A43D68
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Dec 2005 23:29:37 +0000 (GMT)
	(envelope-from joao.barros@gmail.com)
Received: by xproxy.gmail.com with SMTP id t12so536997wxc
	for <freebsd-questions@freebsd.org>;
	Thu, 08 Dec 2005 15:29:32 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=V+c4dGLC2iuYXXBMGnTj7//lFLnDjSdrVh+VlHBc9KpxgyG7j2nhkjqnLZxv092l6BbjzBJUlRTmxdscPg7erQvBqdTyYXXqUOyjwL1Ci4geah+OHLCc1RPuo/+hqU1WLZL9xJxAPO+lLGJZSfqpfI19ARAJ+INuw72RRuUnatE=
Received: by 10.70.46.13 with SMTP id t13mr4417335wxt;
	Thu, 08 Dec 2005 15:29:32 -0800 (PST)
Received: by 10.70.36.7 with HTTP; Thu, 8 Dec 2005 15:29:32 -0800 (PST)
Message-ID: <70e8236f0512081529p71063331ua3b6297fbd007c3d@mail.gmail.com>
Date: Thu, 8 Dec 2005 23:29:32 +0000
From: Joao Barros <joao.barros@gmail.com>
To: daniel <danstemporaryaccount@yahoo.ca>
In-Reply-To: <200512081051.38306.danstemporaryaccount@yahoo.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <200512081051.38306.danstemporaryaccount@yahoo.ca>
Cc: freebsd-questions@freebsd.org
Subject: Re: MySQL "forgot" some of my data!
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 08 Dec 2005 23:29:42 -0000

On 12/8/05, daniel <danstemporaryaccount@yahoo.ca> wrote:
> Our company has a few very large databases (>9gb) which required a shut d=
own,

>   mysql> SELECT * FROM campaigns LIMIT 0;
>   ERROR 1017 at line 1: Can't find file: 'campaigns.MYI' (errno: 2)
Was that using MyISAM or InnoDB ?

> So my questions to you, deal list are:
>
>   1. Should mysqladmin shutdown take this long?
>     a. Is this normal even with a load of 0.00?

I'd say no.... on a Power5 with 8ish cpus and a load of 15 on a 34GB
database I could stop it almost instantly using normal shutdown
procedure.

>
>   2. Is this the best way to shut down a database of this size?

Is there a different way per size? Guess not ;)

>   3. What is most likely to be the cause of the data loss?
Were you using MyISAM of InnoDB? I had this issue after a restart with
the only table using MyISAM.

--
Joao Barros