up vote 0 down vote favorite
share [g+] share [fb]

I have a 128MB RAM VPS server. I have Debian 32bit OS running on it and I have decided to install some light weight LAMP, so I installed lighthttpd and MySQL but then it had to be started It said it was starting.... and failed. I tried to look to error logs but they are clean. What could it be?

Then I ask my hosting provider about it they just told me to buy more expensive plan because this one just cannot possibly run MySQL because there is not enough ram. But I was aiming for server which could run with 96MB ram server!

link|improve this question
3  
This belongs on serverfault as it is not a programming question. – Ex Umbris Jul 8 '11 at 18:11
in my.cnf/my.ini it's written than minimum 128MB, so i think you should consider to buy some RAM – Sourav Jul 8 '11 at 18:15
feedback

migrated from stackoverflow.com Jul 8 '11 at 18:30

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 0 down vote

I just installed MySQL server on my CentOS VPS... it's running at about 180MB RAM. Out of the box. Sounds like you gotta upgrade. It's almost certainly a RAM issue as your provider mentioned.

link|improve this answer
feedback
up vote 0 down vote

You're probably running a default mysql config that isn't tuned for a smaller RAM footprint. You should probably use the my-small config (/usr/share/doc/mysql-server-5.*/examples/my-small.cnf) which is billed as being for "<=64M". I don't warrant that it'll perform at all well, but it should at least start.

I wouldn't be trying to run anything production in 128MB of RAM these days, there's just too much bloat on a modern system, but if you're up for a challenge, have at it. Oh, and replace lighttpd with nginx; sorry to all the lighttpd fans out there, but you've been superceded.

link|improve this answer
I tried to replace the my.cnf file with the one you mentioned but then I tried to start MySQL server again but it failed again. – Povylas Jul 9 '11 at 18:10
Error messages, log messages, or any other useful diagnostic data? Edit your question to add them. You're probably hitting a change in iblogfile* size; delete those and try again. – womble Jul 9 '11 at 21:58
As I mentioned before all the error logs are clean so I do not have anything to post. – Povylas Jul 14 '11 at 16:16
If MySQL isn't starting, it's definitely logging something, you're just not looking in the right place. – womble Jul 15 '11 at 6:19
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.