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? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
