PHP and MySQL Destroy Resources
-
Anonymous
UnregisteredI am trying to install php and mysql for my vps, it is a very small vps with 128mb ram dedicated and 256mb burstable. Before I attempted php and mysql my server had nginx on it and was at a steady ~33mb of ram, now with just mysql installed I am already bursting to 139mb of ram. I can't even compile php to install. I had asked around before purchasing and even contacted my host and they stated the 128mb package would handle my single site which only has a blog. Can anyone throw in some advice?
MySQL is using about 114mb of ram, freshly installed.
Posted 2 years ago # -
hmmn .. painful deal, Shane.
any clues from:-
ps aux | grep mysql
so what if you check your memory:-
free -m
.. gives it in mBs
then:-
/etc/init.d/mysql restart
then, again:-
free -m
.. any noticeable difference?
and what's does the VIRT column say for memory if you run:-
top -d 1 -n 2 -u mysql
and what's in:-
sudo nano /etc/mysql/my.cnf
.. could be a corrupted install .. how did you install it? any special config?
pain .. you tried launching a new distro? sounds like you've got nothing on this server if you didn't get as far as php .. if so, quickest thing is to redo that
your VPS should be giving you some feedback on this tho .. who is it? (might have to avoid them!)
Posted 2 years ago # -
Anonymous
UnregisteredI have installed MySQL as your guide has stated, I have used a config I found on the internet and got my overall usage down to 77mb of ram, still not enough to compile and install php though. I have tried fresh installs, infact I have gone through about 4 rebuilds ( I break things easily ) and have attempted an install on each and have gotten the same response. My host is fivebean ( fivebean.com ). I am considering upgrading to 512mb of ram instead of 128mb, it would only be an additional $4.50. The best info I have at the moment is that ubuntu uses about 17mb without php or mysql and is over 128mb with just mysql.
Posted 2 years ago # -
Anonymous
UnregisteredI'm actually getting the same issue. Running cherokee instead of nginx, and mysql is also taking up 140mb of ram. I'm not evening running php-my-admin
Free-m gives me 40 free out of 512mb with php-cgi, mysql and cherokee server running. If i run cherokee-admin it's even less :)
I have bluemilecloud with ubuntu 8.04. I think it's just worth it to upgrade the ram IMHO
Posted 2 years ago # -
Anonymous
UnregisteredYea I am going to upgrade to 512mb of ram in a few minutes, will this be plenty for using php, mysql, phpmyadmin, and a few other items for a single site? I am hopping to never have to worry about ram usage again.
Posted 2 years ago # -
Kugelfisch
InactiveA while ago i managed to run a forum with a 300mb db and a joomla site on a server with 256 MB Ram.
It is possible, but quite hard to achive :/
If i remember correctly I used this script to get an idea on how i have to set the values in the my.cnf
http://www.day32.com/MySQL/Quote from the HP:
This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..."
to produce sane recomendations for tuning server variables.
It is compatable with all versions of MySQL 3.23 and higher (including 5.1).Currently it handles recomendations for the following:
# Slow Query Log
# Max Connections
# Worker Threads
# Key Buffer
# Query Cache
# Sort Buffer
# Joins
# Temp Tables
# Table (Open & Definition) Cache
# Table Locking
# Table Scans (read_buffer)
# Innodb StatusPosted 2 years ago # -
v nice Kugelfisch
Posted 2 years ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.