From mboxrd@z Thu Jan 1 00:00:00 1970
Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org)
by finch.gentoo.org with esmtp (Exim 4.60)
(envelope-from <gentoo-user+bounces-125963-garchives=archives.gentoo.org@lists.gentoo.org>)
id 1Qk19w-0006iR-T6
for garchives@archives.gentoo.org; Thu, 21 Jul 2011 21:51:57 +0000
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
by pigeon.gentoo.org (Postfix) with SMTP id 50EAC21C1E1;
Thu, 21 Jul 2011 21:51:47 +0000 (UTC)
Received: from mail-ey0-f171.google.com (mail-ey0-f171.google.com [209.85.215.171])
by pigeon.gentoo.org (Postfix) with ESMTP id 9004721C198
for <gentoo-user@lists.gentoo.org>; Thu, 21 Jul 2011 21:50:55 +0000 (UTC)
Received: by eye22 with SMTP id 22so1949035eye.2
for <gentoo-user@lists.gentoo.org>; Thu, 21 Jul 2011 14:50:54 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type:content-transfer-encoding;
bh=pM8UBQRwE85S3gJrs/Ks3zQXonIroO4/P2TcnAOs0dE=;
b=YtBSDTlZ4EYuvUjuMhk7FoFFzwBO/+eH8frbfiX/ZpbM1wmeyVt8eiYetkM5A3piw1
FT+CLXrUXKfUVjHwgLr/M4lIugahCk9wBCvqEzkCUV90OD8VOBuS2rzF/j0LwQBmCip0
Ds4moGW22dOEDKglmg2KK9m0NbYCKAt1VaYxY=
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
Received: by 10.14.98.207 with SMTP id v55mr324725eef.49.1311285054653; Thu,
21 Jul 2011 14:50:54 -0700 (PDT)
Received: by 10.14.97.131 with HTTP; Thu, 21 Jul 2011 14:50:54 -0700 (PDT)
In-Reply-To: <4E28635E.2030205@badapple.net>
References: <CAN0CFw1mBx_2iJfZcX1TWLfTs1qT1TfPo_zuJ9AJc_jy1Tc=ww@mail.gmail.com>
<CAEH5T2OfgCDX-E=j_3AOPhPCXBWh55LPaag0uJ11uUajV+Bp4Q@mail.gmail.com>
<CAN0CFw07+AViFekCyTVXWn-tUMcbLk6cUiguMt4iqTvXwPpYWw@mail.gmail.com>
<4E276A9D.5030801@badapple.net>
<CAN0CFw3TG7kSnzYo_SuETO50K+4r+54s5mKunw=pfNa4M49aeA@mail.gmail.com>
<4E28635E.2030205@badapple.net>
Date: Thu, 21 Jul 2011 14:50:54 -0700
Message-ID: <CAN0CFw1KpR677LH7Y8K_Q8m40HPhpSAoaFJnAMeY_Xb70xOG6g@mail.gmail.com>
Subject: Re: [gentoo-user] mysqld invoked oom-killer
From: Grant <emailgrant@gmail.com>
To: gentoo-user@lists.gentoo.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Archives-Salt:
X-Archives-Hash: d9095f14fd88bd0ce0275071de92397a
>>> =A0 =A0 =A0 =A0Next I'd look at tuning your Mysql config. If you've nev=
er touched
>>> my.cnf, by default it's set to use 64MB IIRC. You may need to raise thi=
s
>>> to
>>> get better performance. key_buffer and innodb_buffer_pool_size are the
>>> only
>>> two I'd modify without knowing more.
>>
>> I use the default MyISAM tables and it looks like there are three
>> key_buffer definitions in my.cnf. =A0One under [mysqld] is 16M, one
>> under [isamchk] is 20M, and one under [myisamchk] is 20M. =A0All
>> defaults. =A0Should I increase them all to 64M?
>
> =A0 =A0 =A0 =A0You can, but [mysqld] is the only one that matters for nor=
mal
> production. Depends on the size of your data and tables, but 64M is fine =
to
> start. If you've got a few GB in your databases I'd go with 256-512M or a=
s
> high as you think you can get away with.
>
> =A0 =A0 =A0 =A0Any reason you're still using MyISAM tables? Innodb is alm=
ost as fast
> or much much faster than MyISAM in nearly every way these days.
Can multiple processes be utilized for mysql like they are for
apache2? Perhaps not since it's a database?
- Grant