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.<br><br><div class="gmail_quote">On Wed, May 18, 2011 at 9:05 AM, <span dir="ltr"><<a href="mailto:dennisjperkins@comcast.net">dennisjperkins@comcast.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div style="font-family:Arial;font-size:12pt;color:#000000">It is limited.<div class="im"><br><br>----- Original Message -----<br>
From: "Will" <<a href="mailto:will.sterling@gmail.com" target="_blank">will.sterling@gmail.com</a>><br>To: "CLUE's mailing list" <<a href="mailto:clue@cluedenver.org" target="_blank">clue@cluedenver.org</a>><br>
</div><div class="im">Sent: Wednesday, May 18, 2011 9:02:42 AM<br>Subject: Re: [clue] website is faster<br><br></div><div><div></div><div class="h5">Assuming the VPS is limited on memory, backing up and then dropping the old database may help reduce the MySQL foot print.<br>
<br><div class="gmail_quote">On Wed, May 18, 2011 at 8:55 AM, Dan Kulinski <span dir="ltr"><<a href="mailto:daniel@kulinski.net" target="_blank">daniel@kulinski.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">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. <br>
<br>Is the disk I/O per hit just Apache logging or is it much more significant?<br><br>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. <br>
<font color="#888888">
<br>Dan Kulinski</font><div><div></div><div><br><br><div class="gmail_quote">On Wed, May 18, 2011 at 8:43 AM, chris fedde <span dir="ltr"><<a href="mailto:chris@fedde.us" target="_blank">chris@fedde.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Looking around on the box (thanks Dennis) I see that mysqld is<br>
clocking as much time as kswapd0 is. vmstat shows context switch and<br>
block IO activity while the server is processing a hit.<br>
<br>
I wonder if the delay is as simple as a missing database index or two.<br>
<br>
I don't have access to logs or configs and so cannot dive much deeper<br>
at this point.<br>
<br>
thanks<br>
<div><div></div><div><br></div></div></blockquote></div>
</div></div><br>_______________________________________________<br>
clue mailing list<br>
<a href="mailto:clue@cluedenver.org" target="_blank">clue@cluedenver.org</a><br>
<a href="http://cluedenver.org/mailman/listinfo/clue" target="_blank">http://cluedenver.org/mailman/listinfo/clue</a><br></blockquote></div><br>
<br>_______________________________________________<br>clue mailing list<br><a href="mailto:clue@cluedenver.org" target="_blank">clue@cluedenver.org</a><br><a href="http://cluedenver.org/mailman/listinfo/clue" target="_blank">http://cluedenver.org/mailman/listinfo/clue</a></div>
</div></div></div><br>_______________________________________________<br>
clue mailing list<br>
<a href="mailto:clue@cluedenver.org">clue@cluedenver.org</a><br>
<a href="http://cluedenver.org/mailman/listinfo/clue" target="_blank">http://cluedenver.org/mailman/listinfo/clue</a><br></blockquote></div><br>