[clue] website is faster

Wed May 18 09:26:42 MDT 2011

You guys might want to take a look at an opcode cache as well, such as php-apc. It's super easy to configure and makes a huge difference on CMS type installs like Drupal, due to the constant class loading they do.

Do you guys have full shell access? Sounds like you do, since you are talking about top. free -m will show how much actual memory is in use, vs buffers. If a simple page load is causing swap to be hit, that is definitely the source of your slowdown. How much RAM does this server have?

I have been on this list for a while, lurking. You guys have just hit on my forte, which is web application hosting, so I am chiming in :)

If you guys trust access to a relatively new person on this list, I can send you my public ssh key and poke around. If not, I am more than willing to offer advice.

Brandon

On May 18, 2011, at 9:17 AM, Will wrote:

> Ok, also removing any unused modules from Apache's config especially any of those that were used to run scripts/CGI for the old site will help reduce the size of each apache process.
> 
> On Wed, May 18, 2011 at 9:05 AM, <dennisjperkins at comcast.net> wrote:
> It is limited.
> 
> 
> ----- Original Message -----
> From: "Will" <will.sterling at gmail.com>
> To: "CLUE's mailing list" <clue at cluedenver.org>
> Sent: Wednesday, May 18, 2011 9:02:42 AM
> Subject: Re: [clue] website is faster
> 
> Assuming the VPS is limited on memory, backing up and then dropping the old database may help reduce the MySQL foot print.
> 
> On Wed, May 18, 2011 at 8:55 AM, Dan Kulinski <daniel at kulinski.net> wrote:
> Should a missing index cause the page loads to take a matter of seconds?  Unless this is a very large database I would be surprised to have it cause that much of a delay.  There are ways in MySQL to log abnormally long queries and is probably a good idea to investigate.  
> 
> Is the disk I/O per hit just Apache logging or is it much more significant?
> 
> As for the Apache configuration, ChunkHost is allowing free beta testing of their 512MB VPS services.  It may be worthwhile to have one setup, a configuration setup and tested on this server and then that configuration moved back to the production server.  
> 
> Dan Kulinski
> 
> 
> On Wed, May 18, 2011 at 8:43 AM, chris fedde <chris at fedde.us> wrote:
> Looking around on the box (thanks Dennis) I see that mysqld is
> clocking as much time as kswapd0 is.   vmstat shows context switch and
> block IO activity while the server is processing a hit.
> 
> I wonder if the delay is as simple as a missing database index or two.
> 
> I don't have access to logs or configs and so cannot dive much deeper
> at this point.
> 
> thanks
> 
> 
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
> 
> 
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
> 
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
> 
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue

Brandon Allhands
IT Manager
brandon at toolking.com
1.800.696.TOOL
ToolKing.com
11111 West Sixth Ave Unit D
Lakewood, CO 80215
303.500.0427 - Direct

View our Tool Deals of the Day @ www.Tooliday.com

Check out our tool blog, www.Toologics.com

CONFIDENTIALITY NOTICE - This e-mail transmission, and any document, files or previous e-mail messages attached to it, may contain information that is confidential or legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that you must not read or play this transmission and that any disclosure, copying, printing, distribution or use of any the information contained in or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender by telephone or return e-mail and delete the original transmission and its attachments without reading or saving in any manner. Thank you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue/attachments/20110518/12367795/attachment.html 