Paul Walker on 15 Dec 2011 06:07:29 -0800


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Troubleshooting mem-suck

I ended up going with these setting as recommended by linode:

For mysql:

key_buffer = 16K
max_allowed_packet = 1M
thread_stack = 64K
table_cache = 4
sort_buffer = 64K
net_buffer_length = 2K
And for apache:

StartServers 1
MinSpareServers 3
MaxSpareServers 6
ServerLimit 24
MaxClients 24
MaxRequestsPerChild 3000

The stats from `top` are about the same as before but the performance seems to have gotten better. Possibly I was experiencing some network latency? Not sure. I'm also currently not serving a ton of http requests - I wonder if these settings will need to be tuned when things pick up? I've got some more research to do, but for now things are operating smoothly.

On Wed, Dec 14, 2011 at 10:58 PM, Matt Murphy <mattyhead@gmail.com> wrote:
Paul, anything interesting happen with this?
M
On Sun, Dec 4, 2011 at 6:26 PM, Paul Walker <starsinmypockets@gmail.com> wrote:
> Hey yeah, this is Paul - yes it's a VPS and yes, running several (6) drupal
> instances... I did make some adjustments to the mysql and apache configs as
> per the linode recommendations which had a noticeable effect... Not sure if
> I'm going to hit bottlenecks there - we'll see... I'll post the settings
> later but I've got to run. Thanks everyone for the input.
>
> On Sun, Dec 4, 2011 at 3:52 PM, Matt Murphy <mattyhead@gmail.com> wrote:
>>
>> Paul, am i right thinking this is a VPN you're running Drupal on? If I'm
>> not way off base, you'll probably benefit from starting with looking at your
>> MySql load.  If you're not the guy I'm thinking of and this os not the
>> scenario I imagine, I apologize for the static...
>>
>> MM
>>
>> Sent from my iPhone
>>
>> On Dec 4, 2011, at 14:52, Rich Freeman <r-plug@thefreemanclan.net> wrote:
>>
>> On Dec 4, 2011 12:51 PM, "Paul Walker" <starsinmypockets@gmail.com> wrote:
>> >
>> > Hmm.. I'm experiencing a lot of latency on my server. running `top`
>> > shows really high memory usage, but I'm unable to determine from the line
>> > items what process(es) are responsible for the suck... Does this make sense
>> > to any of you?
>> >
>> > Tasks:  88 total,   1 running,  87 sleeping,   0 stopped,   0 zombie
>> > Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,
>> >  0.0%st
>> > Mem:    768848k total,   651552k used,   117296k free,     9340k buffers
>> > Swap:   524284k total,    23976k used,   500308k free,   428872k cached
>> >
>>
>> This suggests that you only have 769M of RAM, of which 117+9+429M is
>> available for use. Only 23M is swapped - probably because is hasn't been
>> touched much.
>>
>> Doesn't really seem RAM-constrained to me (well, not until you try to run
>> a desktop app written in the last decade, anyway).
>>
>> Try using atop if you have accounting enabled in your kernel. It shows you
>> ten second slices and everything happening in them. That picks up stuff that
>> runs for 10ms and dies. Plus it gives a lot more IO info.
>>
>> Rich
>>
>>
>> ___________________________________________________________________________
>> Philadelphia Linux Users Group         --
>>        http://www.phillylinux.org
>> Announcements -
>> http://lists.phillylinux.org/mailman/listinfo/plug-announce
>> General Discussion  --
>>   http://lists.phillylinux.org/mailman/listinfo/plug
>>
>>
>>
>> ___________________________________________________________________________
>> Philadelphia Linux Users Group         --
>>  http://www.phillylinux.org
>> Announcements -
>> http://lists.phillylinux.org/mailman/listinfo/plug-announce
>> General Discussion  --
>> http://lists.phillylinux.org/mailman/listinfo/plug
>>
>
>
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --        http://www.phillylinux.org
> Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug
>
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug