Hi all
I have a RHEL5 question / issue that I cant seem to figure out. I'm trying
to eliminate a process (mysql) from swapping out to the swap space. This is
a dedicated
mysql server so nothing else of importance should be using memory or other
but I'm still seeing swap being used and my si / so columns are pretty
active.
Here is some server info.
OS: RHEL5 x86_64
Mem: 8GB
Swap: 4G on VolGroup00/LogVol01
MySQL info:
I have assigned mysql (through the my.cnf file) to use 4G of memory for its
innodb engine (this is all I'm using)
What I have tried thus far..
Step 1:
placed in rc.local
echo 0 > /proc/sys/vm/swappiness
Step 2:
added to /etc/security/limits.conf
mysql soft memlock 4194304
mysql hard memlock 4194304
Step 3:
added to sysctl.conf
vm.nr_hugepages = 2048
Step 4:
upped the nice to -15 for mysql
Here is what I see during run time.
#vmstat 5
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id
wa st
0 0 2047992 45788 137652 485700 17 0 24 882 1219 423 1 1 96
2 0
1 0 2047992 43648 137652 485880 191 0 198 378 1469 627 4 2 89
5 0
0 0 2047992 43036 137656 486204 70 0 77 951 1320 527 2 1 93
4 0
0 0 2047992 46164 137612 483856 176 0 258 547 1434 562 2 2 91
5 0
0 0 2047992 46048 137620 484152 0 0 6 1080 1428 655 3 1 93
2 0
0 0 2047992 44544 137632 485124 9 0 10 448 1390 477 1 1 97
1 0
0 0 2047992 44040 137640 485140 69 0 71 888 1563 729 7 2 89
2 0
0 0 2047992 43552 137640 485280 10 0 14 251 1296 497 1 2 96
1 0
0 1 2047992 43180 137640 485980 12 0 38 1331 1409 584 1 2 94
4 0
#free
total used free shared buffers cached
Mem: 7927572 7879968 47604 0 137672 480292
-/+ buffers/cache: 7262004 665568
Swap: 4095992 2047992 2048000
# cat /proc/meminfo
MemTotal: 7927572 kB
MemFree: 43760 kB
Buffers: 137660 kB
Cached: 482964 kB
SwapCached: 562600 kB
Active: 1682752 kB
Inactive: 293176 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 7927572 kB
LowFree: 43760 kB
SwapTotal: 4095992 kB
SwapFree: 2048000 kB
Dirty: 1460 kB
Writeback: 0 kB
AnonPages: 1214632 kB
Mapped: 7968 kB
Slab: 58692 kB
PageTables: 10968 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 7011200 kB
Committed_AS: 5306572 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 2916 kB
VmallocChunk: 34359733635 kB
HugePages_Total: 1024
HugePages_Free: 1024
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
Ultimatly I'd like to see the entire 4G get locked and that be where mysql
stays but I think the kernel is migrating stuff to swap. Am I making too
much of these numbers or is there something I forgot in sysctl (or other) to
force mysql to stay in RAM as opposed to going to swap?
Any help appreciated.
--
:wq!
kevin.foote
_______________________________________________
rhelv5-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/rhelv5-list
