<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'>It is limited.<br><br>----- Original Message -----<br>From: "Will" <will.sterling@gmail.com><br>To: "CLUE's mailing list" <clue@cluedenver.org><br>Sent: Wednesday, May 18, 2011 9:02:42 AM<br>Subject: Re: [clue] website is faster<br><br>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 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: 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>clue@cluedenver.org<br>http://cluedenver.org/mailman/listinfo/clue</div></body></html>