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>
<br>Dan Kulinski<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">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 class="h5"><br></div></div></blockquote></div>