Re: mysql and oom-killer

2010-08-05 Thread Rob Wultsch
2010/8/5 Rob Wultsch : > 2010/8/5 Евгений Килимчук : >> 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. >> > > OOM is configurable via the proc filesystem vi

Re: mysql and oom-killer

2010-08-05 Thread Rob Wultsch
2010/8/5 Евгений Килимчук : > 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. > OOM is configurable via the proc filesystem via /proc//oom_adj . You can set t

Re: mysql and oom-killer

2010-08-05 Thread Евгений Килимчук
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 написал: > You don't want to mess with OOM too much - you r

Re: mysql and oom-killer

2010-08-05 Thread Johan De Meersman
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 Евгений Килимчук > I can't write my config parameters no

Re: mysql and oom-killer

2010-08-05 Thread Евгений Килимчук
I can't write my config parameters now. 5 августа 2010 г. 23:02 пользователь Евгений Килимчук написал: > 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

Re: mysql and oom-killer

2010-08-05 Thread Евгений Килимчук
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 > It would be a lot better to make sure y

Re: mysql and oom-killer

2010-08-05 Thread Walter Heck - 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?