MySQL Forums
Forum List  »  InnoDB

Re: innodb memory usage vs swap
Posted by: kevin foote
Date: September 10, 2010 09:44AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
6477
September 08, 2010 10:35PM
2166
September 10, 2010 12:01AM
Re: innodb memory usage vs swap
4342
September 10, 2010 09:44AM
2163
September 10, 2010 09:59AM
2153
September 10, 2010 12:26PM
6321
September 10, 2010 11:14PM
2906
September 14, 2010 08:42AM
2248
September 14, 2010 09:44AM
2223
September 14, 2010 08:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.