[clue] website is faster

[Dan Kulinski]

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