List:General Discussion« Previous MessageNext Message »
From:Евгений Килимчук Date:August 5 2010 8:35pm
Subject:Re: mysql and oom-killer
View as plain text  
When OOM-killer kill mysqld, I had a critical corrupted tables. My database
is a very big. I think Apache with cgi-scripts not critical process in this
story. And sshd is a real true.

6 августа 2010 г. 0:09 пользователь Johan De Meersman
<vegivamp@stripped>написал:

> 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 Евгений Килимчук <ekilimchuk@stripped>
>
> I can't write my config parameters now.
>>
>> 5 августа 2010 г. 23:02 пользователь Евгений
> Килимчук
>> <ekilimchuk@stripped>написал:
>>
>> > Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script
>> some
>> > time made heavy load when used many memory and used SWAP. OOM-killer
>> must
>> > 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, Евгений Килимчук
> <ekilimchuk@stripped>
>> >> wrote:
>> >> > Hello!
>> >> >
>> >> > I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs.
>> MySQL
>> >> use
>> >> > 75% (100% = 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>
>>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>



-- 
Best regards,

Eugene Kilimchuk <ekilimchuk@stripped>

Thread
mysql and oom-killerЕвгений Килимчук5 Aug
  • Re: mysql and oom-killerWalter Heck - OlinData.com5 Aug
    • Re: mysql and oom-killerЕвгений Килимчук5 Aug
      • Re: mysql and oom-killerЕвгений Килимчук5 Aug
        • Re: mysql and oom-killerJohan De Meersman5 Aug
          • Re: mysql and oom-killerЕвгений Килимчук5 Aug
            • Re: mysql and oom-killerRob Wultsch6 Aug
              • Re: mysql and oom-killerRob Wultsch6 Aug