MySQL Hogging Memory

I really need to stop it as the server keeps being brought down

[vincevincevince]

 PID USER   PR NI VIRT RES SHR S %CPU %MEM  TIME+ COMMAND
 2611 mysql   15  0 203m 45m 5764 S 0.0 9.7  0:31.99 mysqld

That's from top and I've only got a 48Mb server. I am running FC2 / Apache / MySQL 4.0x. I tried moving the big tables in use on the server to innodb - that reduced the threads in use greatly - but still using a lot of memory. I figure I need some way to stop MySQL from making everything hang.

[kalos]

I have to ask, since you've only got 48M in the machine, is adding some RAM not an option? It's dirt cheap these days.

Barring that, try lowering the innodb_additional_mem_pool_size setting. Mine, by default, was 3M.

[bcolflesh]

I've only got a 48Mb server...

Is that really the amount of RAM?