Re: innodb memory usage vs swap

[kevin foote]

Rick - Thanks for any thing you can show / point out here..

System is RHEL5, x86_64, 8G main memory, no ram-disk, 4G swap partition
Mysql Version 5.1.41. Host is dedicated to mysql..


Running as mysql user I get.

-bash-3.2$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 65536
max locked memory (kbytes, -l) 4194304
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 65536
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited


# /etc/security/limits.conf
mysql soft memlock 4194304
mysql hard memlock 4194304

Vmstat report. so shows only 0's .. while si shows some numbers ? odd?
Trying to achieve the all 0's in si and so both .. according to the book.

[]> 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
1 0 2880992 65696 50352 66616 58 0 70 1951 1400 835 6 2 74 18 0
1 0 2880980 64828 50776 67140 14 0 26 894 1415 875 6 2 83 9 0
0 0 2880904 63836 51200 67380 58 0 72 704 1285 685 2 2 85 11 0
0 0 2880864 62720 51440 68096 32 0 41 510 1245 551 4 2 88 6 0
0 0 2880844 61728 51836 68340 39 0 58 1270 1493 961 7 2 85 6 0
1 2 2880372 58256 52236 68656 560 0 570 618 1286 790 9 3 62 26 0
0 1 2879300 51312 52628 69792 1070 0 1092 814 1065 880 29 5 32 34 0
0 0 2878996 48088 53324 70744 332 0 354 1442 1579 1190 10 3 72 14 0
0 0 2878996 46724 53592 71836 0 0 20 1414 1416 692 2 1 93 3 0

[]# sysctl -a | grep ^vm
vm.max_writeback_pages = 1024
vm.flush_mmap_pages = 1
vm.pagecache = 100
vm.min_slab_ratio = 5
vm.min_unmapped_ratio = 1
vm.zone_reclaim_mode = 0
vm.swap_token_timeout = 300 0
vm.legacy_va_layout = 0
vm.vfs_cache_pressure = 100
vm.block_dump = 0
vm.laptop_mode = 0
vm.max_map_count = 65536
vm.percpu_pagelist_fraction = 0
vm.min_free_kbytes = 11318
vm.drop_caches = 0
vm.lowmem_reserve_ratio = 256 256 32
vm.hugetlb_shm_group = 0
vm.nr_hugepages = 2048
vm.swappiness = 0
vm.nr_pdflush_threads = 2
vm.dirty_expire_centisecs = 2999
vm.dirty_writeback_centisecs = 499
vm.mmap_min_addr = 4096
vm.dirty_ratio = 40
vm.dirty_background_ratio = 10
vm.page-cluster = 3
vm.overcommit_ratio = 50
vm.panic_on_oom = 0
vm.overcommit_memory = 0


[]# sysctl -a | grep shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 68719476736


thanks -kevin