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 |
signature.asc
Description: Digital signature
