MySQL Forums
Forum List  »  Performance

MySQL RAM Usage
Posted by: scott.horowitz
Date: October 31, 2004 02:10PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL RAM Usage
11317
October 31, 2004 02:10PM
4716
October 31, 2004 02:11PM
4733
November 01, 2004 01:10AM
3860
November 01, 2004 01:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.