My server is crashing, I think its due to traffic but I am not sure how to tell
-
@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.
-
It just crashed again!
-
gonna login and try sar -r again
-
-
@IRJ said:
I had another crash at 2:53PM. Is there anything I can do to find out what happened?
Look into web server and database logs.
-
The site is still down. Should I reboot?
-
-
Rebooting is what fixes the db connection
-
What do you get if you type uptime? More curious about the 10 and 15 min load average.
-
@IRJ Just restart database and webserver services. Most likely we server alone should be enough.
