[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysqld is being killed by the kernel (in the parlor with a candlestick)



On Fri, Aug 04, 2006 at 12:14:48PM -0400, Roan Horning wrote:
> Hi,
> 
> I've recently installed mysql 4.1 on my debian stable box.  It is being 
> used with a php4 application running on Apache2.
> 
> Mysql installs fine.  I can use the command line client to log into 
> mysqld.  Create databases, create users etc.
> 
> After getting my php4 app running, configure and initially working. I 
> start getting this error.
> 
>    Jul 29 00:09:43 alpha kernel: Out of Memory: Killed process 6782 
> (mysqld).
<snip>
>    top - 11:54:58 up 366 days,  5:32,  1 user,  load average: 0.64, 
> 0.67, 0.39
>    Tasks: 101 total,   1 running,  96 sleeping,   0 stopped,   4 zombie
>    Cpu(s):   0.7% user,   1.3% system,   0.0% nice,  98.0% idle
>    Mem:    240108k total,   235692k used,     4416k free,     3672k buffers
>    Swap:   104416k total,   102804k used,     1612k free,    67228k cached
> 
> Here's a snapshot from top while the php4 app is processing the upload.
> 
>    top - 12:01:20 up 366 days,  5:38,  1 user,  load average: 1.03, 
> 0.94, 0.59
>    Tasks:  94 total,   3 running,  87 sleeping,   0 stopped,   4 zombie
>    Cpu(s):  97.7% user,   2.3% system,   0.0% nice,   0.0% idle
>    Mem:    240108k total,   236860k used,     3248k free,     3276k buffers
>    Swap:   104416k total,   104416k used,        0k free,    31444k cached
> ...
>     5020 www-data  20   0 21088  17m 4724 R 97.4  7.5   0:09.89 apache2
> 
> Has anyone run into this problem?  My head is sore from beating it 
> against my desk.  Any suggestions are greatly appreciated.
> 
Hi Roan,
well the kernel is doing what it is supposed to do: kill a process when
it eats up all the memory. The 2nd top snapshot shows that 99% of real
memory and 100% of swap are being used. Maybe try to create more swap by
making a parttion or using the 'swap file' technique or of course
getting more RAM? Not sure how to address the issue if this is not it,
as I am not a MYSQL expert.
cheers,
Kev
-- 
|  .''`.  == Debian GNU/Linux == |       my web site:       |
| : :' :      The  Universal     | debian.home.pipeline.com |
| `. `'      Operating System    | go to counter.li.org and |
|   `-    http://www.debian.org/ |    be counted! #238656   |
|     my keysever: pgp.mit.edu   |     my NPO: cfsg.org     |

Attachment: signature.asc
Description: Digital signature


Reply to: