That oughta do it.
Posted on 02/03/2008 7:39:29 AM PST by Keyes2000mt
Is there an expert on MySQL in the house? My blog keeps crashing my VPS which has 256 MB of RAM.
That oughta do it.
What level of machine do you currently have?
,...The new DDR2 memory is quite inexpensive compared to the older DDr...which is what i suspect that you might have....
There are variants of Linux that will run on something as small as 256M of Ram,...
I think you answer his question! :^)
CPU+MB COMBO, AMD 64X2 4000+GBT NF4+6100
Starting Price: $129.99
Dual Core Performance Combo
Perfect for Building a Home Office/Entertainment Machine
Got any messages in /var/log/mysqld.log?
2. Check the settings on php.ini (different locations depending on what Linux version you have) - try increasing the max memory ffrom 8M (default) to 32M - it could be that PHP is running out of RAM when processing your blog.
Actually, I started to type this, but I think my wife hit the submit button when I was away. The RAM suggestion is an interesting one, but is costly as I’m renting a VPS, and renting a dedicated host is even more pricey. As for my logs, I got some advice on Yahoo and cleared them out If it crashes again then I’ll have proof for the exact problem. So far, after clear the log, the site is up. It’s been up continuously for 10 hours, which may not seem like much but the way my day’s been going, you better belive it is.
VPS, virtual private server. He has to pay more every month for more RAM. But I don’t see how simple blog software with MySQL shouldn’t be able to run well in that with low load.
I wondered what that VPS was....guess I am behind the times.
This got me to thinking about a problem we were having awhile back-- not sure it's yours too, but you might keep an eye on it.
After several months of operation, one of my app servers would stop responding to Apache calls to its various websites. Turns out, a couple of the apps I was hosting had some very verbose log settings, and the thing was slowly running out of physical disk space. No symptoms until suddenly, the machine wouldn't serve any more pages.
You might do a df command occasionally to make sure you're not coming close to what your VPS provider is giving you. With a measly 256MB RAM, it's possible you don't have a lot of disk space to play around with either.
Unless you have a blog that generates a lot (and I do mean a lot) more traffic than usual, 256 MB RAM should be plenty. Besides looking in the MySQL logs (as others have aptly suggested), have you looked at the Apache (or whatever web server you’re using) logs? If so, is there a common page or operation that is particularly intense and causing the crashes, rather than MySQL itself?
What makes you think the problem is related to MySQL?
A tip:
http://www.datamemorysystems.com
I’ve been buying from them for years and never had a chip go bad — and their prices are the best. (It doesn’t hurt that I live two towns away. :) )
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.