[clue] website is faster

[dennisjperkins at comcast.net]

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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue/attachments/20110518/b9602405/attachment.html