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">daniel@kulinski.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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 class="h5"><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:0 0 0 .8ex;border-left:1px #ccc solid;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">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>