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 <vegiv...@tuxera.be>написал: > 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 Евгений Килимчук <ekilimc...@gmail.com> > > I can't write my config parameters now. >> >> 5 августа 2010 г. 23:02 пользователь Евгений Килимчук >> <ekilimc...@gmail.com>написал: >> >> > 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 <li...@olindata.com> >> > >> > 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, Евгений Килимчук <ekilimc...@gmail.com> >> >> 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 <ekilimc...@gmail.com> >> > >> >> >> >> -- >> Best regards, >> >> Eugene Kilimchuk <ekilimc...@gmail.com> >> > > > > -- > 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 <ekilimc...@gmail.com>
