[clue] website is faster

[Will]

Ok, also removing any unused modules from Apache's config especially any of
those that were used to run scripts/CGI for the old site will help reduce
the size of each apache process.

On Wed, May 18, 2011 at 9:05 AM, <dennisjperkins at comcast.net> wrote:

> It is limited.
>
>
> ----- Original Message -----
> From: "Will" <will.sterling at gmail.com>
> To: "CLUE's mailing list" <clue at cluedenver.org>
> Sent: Wednesday, May 18, 2011 9:02:42 AM
> Subject: Re: [clue] website is faster
>
> 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
>>
>
>
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
>
> _______________________________________________
> 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/2b27d723/attachment.html