Page 1 of 1
Script maxing out my servers RAM
Posted: Tue Dec 12, 2006 2:04 pm
by 8008135
I can't figure out what to do. I am running Serendipity as my blog script on a busy adult site and my servers RAM is maxed out. The server keeps failing. I think it has to do with the databases or MySql. I know how to work with basic HTML but am not familiar with database and MySql stuff. What can I do to try and stop the huge amount of memory usage? ~Glenn
Re: Script maxing out my servers RAM
Posted: Tue Dec 12, 2006 2:11 pm
by garvinhicking
Hi!
You should check the mysql server documentation or ask the webserver admin; it's a matter of server adjustments, not the PHP scripts themselves.
HTH,
Garvin
Posted: Tue Dec 12, 2006 2:22 pm
by 8008135
I have contacted the Server Admin and they told me I am resonsible for maintance on the server. I have had other people help me by checking the server. They removed the apache log. (Was to big) Here is part of the e-mail conversation I had with the person that looked at the server.
"The apache log file was too large, i have removed it.
Having too big log file will affect server performance as it need to keep the file open for writing.
But in your case, the server resource seems to have a problem
Changing Serendipity, i don't think this can be done easily, the script provider may be created the script in possible efficient way. So making a change will not give lot of performance difference, if yes, why Serendipity do not released that way ? Not sure if any MOD for making it more efficient is available.
I have found some webmasters having problem with godaddy VPS."
Anyways, I have to keep rebooting my server but this only fixes the RAM problem for a few hours. Anybody had this problem with a GoDaddy Virtual Dedicated Server? I thin I need to find a new host/server. Thanks, Glenn
Posted: Tue Dec 12, 2006 5:14 pm
by chickens
Hi 8008135,
I've never personally ran a godaddy VPS, but I do have a list of handy VPS monitoring tools that should work for you.
http://zacgarrett.com/2006/11/27/handy- ... ing-tools/
Odds are your mysql is not optimized for running under the VPS environment. I've found that without proper optimization it can easily eat through all of your alloted RAM. Below is the my.cnf file from my server, but it may not be exactly correct for you depending on the VPS you have.
Code: Select all
[mysqld]
skip-networking
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 8M
max_connect_errors = 10
key_buffer = 48M
max_connect_errors = 10
key_buffer = 16M
query_cache_limit = 1M
query_cache_size = 6M
query_cache_type = 1
table_cache = 128
[mysql.server]
user=mysql
#basedir=/var/lib
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
If this does not work for you and you are looking for a new VPS host I suggest looking at
servint. I've been using them for about a year and a half now and they are a great host. They are far from the cheapest with their packages starting at $49USD. Their support is top notch and the people in their private forums are amazing.
Since they do not have Windows VPSs I had to go elsewhere for that. I currently use
solarvps who is not near as good as servint. This company has both Widows and Linux VPSs, I cant vouch for their Linux products though.
If you need anything server wise just let me know.
Zac