From: Johan De Meersman
Date: August 5 2010 8:09pm
Subject: Re: mysql and oom-killer
List-Archive: http://lists.mysql.com/mysql/222445
Message-Id: <AANLkTikZc3o8oyedEYOngmPqbpf_kQsbmZO1ERru_CsA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=000e0cd5662a9ee5bd048d191f75

--000e0cd5662a9ee5bd048d191f75
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: quoted-printable

You don't want to mess with OOM too much - you risk it killing off other
useful/critical things, like SSH daemons, the Apache root, what have you.

Add more memory to the box or split the webserver off to another system, I'=
d
say.


2010/8/5 =E5=D7=C7=C5=CE=C9=CA =EB=C9=CC=C9=CD=DE=D5=CB <ekilimchuk@stripped=
om>

> I can't write my config parameters now.
>
> 5 =C1=D7=C7=D5=D3=D4=C1 2010 =C7. 23:02 =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=
=D8 =E5=D7=C7=C5=CE=C9=CA =EB=C9=CC=C9=CD=DE=D5=CB
> <ekilimchuk@stripped>=CE=C1=D0=C9=D3=C1=CC:
>
> > Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script so=
me
> > time made heavy load when used many memory and used SWAP. OOM-killer mu=
st
> > kill new cgi-forks, wich use many memory, but it kill mysqld and sshd.
> >
> > 2010/8/5 Walter Heck - OlinData.com <lists@stripped>
> >
> > It would be a lot better to make sure your server doesn't turn
> >> OOM-psycho on you. The most common case of this happening is that you
> >> have set the memory-settings in your my.cnf in such a way that it
> >> allows MySQL to use more memory then you have available. Could you
> >> post your my.cnf here by chance?
> >>
> >> Walter Heck
> >> Engineer @ Open Query (http://openquery.com)
> >>
> >> On Fri, Aug 6, 2010 at 02:43, =E5=D7=C7=C5=CE=C9=CA =EB=C9=CC=C9=CD=DE=
=D5=CB <ekilimchuk@stripped>
> >> wrote:
> >> > Hello!
> >> >
> >> > I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs.
> MySQL
> >> use
> >> > 75% (100% =3D 8GB) of memory. When cgi programs use more than 25% of
> >> memory
> >> > and all SWAP file (8GB), kernel run OOM-Kiler wich kill mysqld
> procces.
> >> >
> >> > I use:
> >> >
> >> > echo "0" > /proc/sys/vm/swappiness - This allows to reduce using of
> >>  SWAP.
> >> >
> >> > I want to use:
> >> > echo "-17" > /proc/`pidof mysqld`/oom_adj - This allows save mysqld
> when
> >> run
> >> > oom-killer.
> >> >
> >> > Someone used this option?
> >> >
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Eugene Kilimchuk <ekilimchuk@stripped>
> >
>
>
>
> --
> Best regards,
>
> Eugene Kilimchuk <ekilimchuk@stripped>
>



--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--000e0cd5662a9ee5bd048d191f75--