I have a web server with 1GB of ram and I'm using MySQL 4.3.9 (and php 4.3.9 and Apache 1.3). Ever since I installed a phpbb board, the ram just keeps getting eaten up slowly until it starts using swap memory and the server dies. When I run "top" and sort if by memory usage, I find that MySQL is using all the memory. Here is a screenshot of my output from top:
http://www.theskyiscrape.com/scott/top.jpg
Here is my my.cnf file as well:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=250
set-variable = connect_timeout=300
set-variable = wait_timeout=300
set-variable = query_cache_type=1
set-variable = query_cache_size=16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
So what is the problem.. Bad mysql code? Not configured correctly? I appreciate any help, thanks!
Scott
