BIG problems.. not enough help from support - Page 2

**Kayla** · December 13th, 2006, 9:48 PM

Tearabite, can we have update number 2?

Then we can go from there.

Tearabite · December 13th, 2006, 9:54 PM

Quote:

Originally Posted by Kayla

Tearabite, can we have update number 2?

Then we can go from there.

Server ran great all day - no services failed (previously i was getting alerts that several services were failing and being restarted several times per day) - the site didnt crash, and during heavy traffic periods the site was humming along fine with no lags or anything! I was watching CPU usage and during busy times it was floating from 0.5% to about 20% (not sure if that's too high or not) - so for today i'm happy!

Did you make any changes, or was the extra Ram all that was necessary??

**Kayla** · December 13th, 2006, 10:29 PM

When a server houses a single site and begins to have issues, a RAM upgrade is a common solution. John recommended some changes in WHM, but in this case I think the site itself needs to be optimized as much as possible. There's really not much in WHM that can help.

If you know your site is already optimized enough and if there is nothing obvious that needs modification, a RAM upgrade is a quick way to stabilize the server. In the end it really comes down to your visitors and all of the requests they are making to your site. Even with all of the optimization possible for your particular application, you still need a more powerful server as times goes on in order to keep the system running smoothly under pressure.

Tearabite · December 13th, 2006, 10:41 PM

Thanks for your help..
The site (so far) is running great, but I know there is a lot more room for SQL optimzation which I will figure out - Now that I dont have to stress about the site crashing every 3 hours i'll have to time to read up on MySQL..

**Bigjohn** · December 14th, 2006, 10:45 AM

Quote:

Originally Posted by Kayla

When a server houses a single site and begins to have issues, a RAM upgrade is a common solution. John recommended some changes in WHM, but in this case I think the site itself needs to be optimized as much as possible. There's really not much in WHM that can help.

I recommended no such thing, Kayla... I said there is nothing in WHM that he can do to tweek it - he'd have to go right to the server configs - apache and mysql...

Quote:

If you know your site is already optimized enough and if there is nothing obvious that needs modification, a RAM upgrade is a quick way to stabilize the server. In the end it really comes down to your visitors and all of the requests they are making to your site. Even with all of the optimization possible for your particular application, you still need a more powerful server as times goes on in order to keep the system running smoothly under pressure.

I agree. but 5-20% CPU utilization in this case really does indicate that the problem was surely a RAM shortage. There are ways to tweek apache and mysql to optimize memory use - and you (terrabyte) need to look into those and see what you can do to tweek your site. I don't think Drupal is the most optimize CMS, either. Did you turn on any CACHEING that is available within the system? CACHING will improve performance by keeping static representations of frequently accessed content and not re-query the database for each hit.

**Kayla** · December 14th, 2006, 2:47 PM

Oops, sorry, reading too fast. :-x

Tearabite · December 16th, 2006, 2:33 AM

Ya - Drupal caching was on..
I've turned-of several memory hogging and SQL pounding modules in Drupal which has improved things even more.
and, FYI - when the site was crashing, CPU usage was reguarly hitting 70%-85% for extended periods of time, and memory usage was regularly at 78%-90% ..

NOW, after upgrading to 2gb ram and removing those extra modules in Drupal CPU is usually around 1%-3% (i've seen it peak shortly at 20%) - but it's now rare that I've seen it go over 10% ... memory usage is now around 38%, and rarely goes over 50% ..

**Bigjohn** · December 16th, 2006, 11:00 AM

High CPU combined with very high memory use shows that the system was hitting the SWAP file very hard... and so you definately did the right thing by adding that ram.

Joomla developers have always taken care about this possibility - even did a "slashdot" test on the platform, which it passed quite well.

Tearabite · December 16th, 2006, 8:04 PM

The odd thing is that back when i was on my cheap shared-hosting plan, i was dugg on Digg, and got over 100,000 uniques in 24 hours - the site never even blinked!
That was a few months ago, and now i have a lot more content, much bigger DB, more modules, etc.. but that still seems odd..

December 13th, 2006, 9:48 PM	#10 (permalink)
Kayla Marketing Maven Surpass Staff Joined in May 2003 Lives in Orlando 24,749 posts Gave thanks: 946 Thanked 806 times	Tearabite, can we have update number 2? Then we can go from there. __________________ Follow Surpass on Twitter and Facebook Check out the Surpass Blog

December 13th, 2006, 10:29 PM	#12 (permalink)
Kayla Marketing Maven Surpass Staff Joined in May 2003 Lives in Orlando 24,749 posts Gave thanks: 946 Thanked 806 times	When a server houses a single site and begins to have issues, a RAM upgrade is a common solution. John recommended some changes in WHM, but in this case I think the site itself needs to be optimized as much as possible. There's really not much in WHM that can help. If you know your site is already optimized enough and if there is nothing obvious that needs modification, a RAM upgrade is a quick way to stabilize the server. In the end it really comes down to your visitors and all of the requests they are making to your site. Even with all of the optimization possible for your particular application, you still need a more powerful server as times goes on in order to keep the system running smoothly under pressure. __________________ Follow Surpass on Twitter and Facebook Check out the Surpass Blog

December 14th, 2006, 2:47 PM	#15 (permalink)
Kayla Marketing Maven Surpass Staff Joined in May 2003 Lives in Orlando 24,749 posts Gave thanks: 946 Thanked 806 times	Oops, sorry, reading too fast. :-x __________________ Follow Surpass on Twitter and Facebook Check out the Surpass Blog

December 16th, 2006, 11:00 AM	#17 (permalink)
Bigjohn minor deity Super #1 Joined in Apr 2004 Lives in Georgia Hosted on XEON 7,394 posts Gave thanks: 28 Thanked 94 times	High CPU combined with very high memory use shows that the system was hitting the SWAP file very hard... and so you definately did the right thing by adding that ram. Joomla developers have always taken care about this possibility - even did a "slashdot" test on the platform, which it passed quite well. __________________ Proud to be a Surmunity Mod! XEON PASS60 PASS61 Make a fundamental difference! My Sites: Curious about Brewing Beer? Join the community! >>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax Get into an Art museum Victorian London It's your brain -*ON WEB* - mybrainhost.com (under development) What SHOULD Government do? Much Less than it Does!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

December 13th, 2006, 10:41 PM	#13 (permalink)
Tearabite Registered User Seasoned Poster Joined in Aug 2006 67 posts Gave thanks: 11 Thanked 0 times	Thanks for your help.. The site (so far) is running great, but I know there is a lot more room for SQL optimzation which I will figure out - Now that I dont have to stress about the site crashing every 3 hours i'll have to time to read up on MySQL..

December 16th, 2006, 2:33 AM	#16 (permalink)
Tearabite Registered User Seasoned Poster Joined in Aug 2006 67 posts Gave thanks: 11 Thanked 0 times	Ya - Drupal caching was on.. I've turned-of several memory hogging and SQL pounding modules in Drupal which has improved things even more. and, FYI - when the site was crashing, CPU usage was reguarly hitting 70%-85% for extended periods of time, and memory usage was regularly at 78%-90% .. NOW, after upgrading to 2gb ram and removing those extra modules in Drupal CPU is usually around 1%-3% (i've seen it peak shortly at 20%) - but it's now rare that I've seen it go over 10% ... memory usage is now around 38%, and rarely goes over 50% ..

December 16th, 2006, 8:04 PM	#18 (permalink)
Tearabite Registered User Seasoned Poster Joined in Aug 2006 67 posts Gave thanks: 11 Thanked 0 times	The odd thing is that back when i was on my cheap shared-hosting plan, i was dugg on Digg, and got over 100,000 uniques in 24 hours - the site never even blinked! That was a few months ago, and now i have a lot more content, much bigger DB, more modules, etc.. but that still seems odd..

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)