My server is crashing, I think its due to traffic but I am not sure how to tell
-
@scottalanmiller said:
1GB of RAM is not much for a web server and the database on the same box. Should be okay if tuned, but it does put you as running pretty lean.
What does SAR tell us about CPU and memory just before the crash(es)?
-
What about sar -r?
-
-
@IRJ said:
@scottalanmiller said:
What about sar -r?
I am unfamiliar with that command. How do I run it?
If it is installed, exactly as I wrote it. If you have not installed it yet get it installed straight away. It's the most important troubleshooting tool on Linux. You use it for everything. Also the most important capacity planning tool. Only thing that collects your performance info and stores it.
apt-get install sysstat -
-
Run sar -r 1
-
@marcinozga said:
Is traffic mostly anonymous users? Or authenticated? If anonymous, install some caching plugins for that Wordpress. If people are logging in, you will probably need memcache and apc.
I am using cloudflare for caching which is helping alot. Is there anything else I can do on top of that?
-
-
W3 Total Cache or WP Super Cache will cache your pages as static files. No php or database queries will be fired when somebody visits your site.
-
@IRJ it's too late to diagnose your issues now, sysstat has to be there and enabled (an extra step that only Ubuntu requires, heaven only knows why they make things so hard) BEFORE you have a crash. So we need to enable it and then wait for the next crash to see if you ran out of memory just before it went down or to get a decent idea of what had happened.
-
@IRJ said:
@marcinozga said:
Is traffic mostly anonymous users? Or authenticated? If anonymous, install some caching plugins for that Wordpress. If people are logging in, you will probably need memcache and apc.
I am using cloudflare for caching which is helping alot. Is there anything else I can do on top of that?
Oh yes, that is only a very first step. You want a local cache as well. CF can only offload so much.
-
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
-
https://support.cloudflare.com/hc/en-us/articles/200169546-What-fields-do-I-need-to-enter-in-W3TC-W3-Total-Cache-settings-
here's instruction how to setup W3 Total Cache plugin with Cloudflare. -
@scottalanmiller said:
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
Right. I don't know how WP does this, but Drupal has a module where you pretty much install it and then just tell it which pages you want stored as HTML when people are anonymous.
-
@johnhooks said:
@scottalanmiller said:
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
Right. I don't know how WP does this, but Drupal has a module where you pretty much install it and then just tell it which pages you want stored as HTML when people are anonymous.
WP has a plugin that will do that for the entire site.
-
@scottalanmiller said:
@johnhooks said:
@scottalanmiller said:
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
Right. I don't know how WP does this, but Drupal has a module where you pretty much install it and then just tell it which pages you want stored as HTML when people are anonymous.
WP has a plugin that will do that for the entire site.
You can do the entire site with the Drupal one, but I've always used it mostly for anonymous users since that data doesn't usually change as much as areas where they can log in.
-
@johnhooks said:
@scottalanmiller said:
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
Right. I don't know how WP does this, but Drupal has a module where you pretty much install it and then just tell it which pages you want stored as HTML when people are anonymous.
Drupal Boost does this for entire site. It's extremely powerful when cache directory is mounted in memory.
-
@marcinozga said:
@johnhooks said:
@scottalanmiller said:
You can also consider static pages generated from WordPress. It is basically a manual full site cache. No active database connection needed and the speed goes way up. Faster and more reliable, but more work.
Right. I don't know how WP does this, but Drupal has a module where you pretty much install it and then just tell it which pages you want stored as HTML when people are anonymous.
Drupal Boost does this for entire site. It's extremely powerful when cache directory is mounted in memory.
That's the one I was thinking of, I couldn't think of it off the top of my head. It's been a little while since I've built something, but I thought I remembered choosing which sections I wanted cached even with it figuring it out also.
-
I had another crash at 2:53PM. Is there anything I can do to find out what happened?
-
@IRJ Run sar -r and post back here the data.
