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
top/vmstat are reporting the swap results. In Solaris, swap and
physical memory can be interchanged, that is physical memory can be
reserved for swap instead of using the swap device. Just out of
curiosity, would you run the following?
1. swap -lh
2. swap -sh
3. prtconf | grep size
4. ps -A -o vsz,rss | awk 'BEGIN {size = 0; rss = 0;} {size += $1; rss
+= $2} END{printf("Size = %d kb, RSS = %d kb\n", size, rss);}'
The first shows how much of the physical swap device has been used. The
second looks at how much swap is used and reserved, versus available.
The third is just a sanity check for the physical memory. The fourth
looks at all of the processes in the system and allows us to see the
total difference between the vsize and the rss.
It may or may not be a bug/policy change. It's also possible that mysql has
a memory leak. It's also possible that the combination of short-run
jobs and infrequently used pages has caused part of mysql's enormous
working set to get paged out in favor of keeping memory available for
other processes to run. (That's part of the reason for #4)
-j
_______________________________________________
perf-discuss mailing list
perf-discuss@opensolaris.org
