[clue] website is faster

Will will.sterling at gmail.com
Wed May 18 09:02:42 MDT 2011


Assuming the VPS is limited on memory, backing up and then dropping the old
database may help reduce the MySQL foot print.

On Wed, May 18, 2011 at 8:55 AM, Dan Kulinski <daniel at kulinski.net> wrote:

> 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
>>
>>
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue/attachments/20110518/f212cddd/attachment-0001.html 


More information about the clue mailing list