Hi Ethan,
On Tue, May 12, 2009 at 03:25:52PM -0700, Ethan Erchinger wrote:
> Results, everything looks reasonable to me.
> http://pastebin.com/m785c155e
Thanks for running this. MySQL is using 44g of memory, which is pretty
close to the 48gb limit for the machine. I'm sort of curious about how
>
>> If pmap -x isn't working for you, there might be another option.
>> There's a -S option to pmap that shows the swap allocations. It may
not
>> provide as much detail as -x, but it should give you a good idea of
how
>> much swap each process is using.
>
> We noticed the same problem with -S as
> I recently tried to debug a similar idiopathic problem with a
colleague.
> We weren't able to figure out what was causing the problem, partially
> because the system took about a week to get into the state where a lot
> of swap was in use. Once it was there, there were only a few obvious
> signs
On Tue, May 12, 2009 at 09:41:41AM -0700, Ethan Erchinger wrote:
> Hi all,
>
> I'm having trouble determining what is using a large amount of swap on a
> few of our OpenSolaris systems. These systems run MySQL, the 5.0.65
> version that came with snv_101, have 48G of ram, and 24G of swap. The
>
>
>> As you can see, even though the resident size of MySQL is < 40G, the
>> system is still using close to 16G of swap. At first we thought that
>> ZFS arc cache was causing this to happen, but we've limited it to 2G,
> Perhaps this is due to reserved anonymous memory mappings which are
> not r
On Tue, 12 May 2009, Ethan Erchinger wrote:
As you can see, even though the resident size of MySQL is < 40G, the
system is still using close to 16G of swap. At first we thought that
ZFS arc cache was causing this to happen, but we've limited it to 2G,
Perhaps this is due to reserved anonymous
Hi all,
I'm having trouble determining what is using a large amount of swap on a
few of our OpenSolaris systems. These systems run MySQL, the 5.0.65
version that came with snv_101, have 48G of ram, and 24G of swap. The
MySQL instances are configured to use a 36G innodb buffer pool. With
the oth
