cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
Here "always" is selected, showing THP are enabled, this needs to be disable with following command:
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
Dear Concern,
Always my server memory utilization is remain >99%. I have 4 DB server and RAM of the server is (32 GB, 64 GB, 64 GB and 132 GB). In every server always we are getting the memory utilization > 99%. Kindly suggest why this problem is and which parameter will resolve this problem.I am using PostgreSQL 9.1.2 and PostGIS 1.5 version on every Red hat Linux server. Kindly find the "TOP" result, "ulimit -a" result, ("kernel.shmax", "kernel.shmall", "kernel.sem" value) and pg_setting result of one server as below. If you require any other information then inform to me.
[root@CPPMOMA_DB01 ~]# top
top - 12:08:08 up 15 days, 15:45, 5 users, load average: 1.05, 1.19, 1.35
Tasks: 605 total, 1 running, 604 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.9%us, 2.1%sy, 0.0%ni, 78.3%id, 12.7%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 32832364k total, 32621168k used, 211196k free, 77572k buffers[root@CPPMOMA_DB01 ~]# 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) 256323
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 4096
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) 256323
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@CPPMOMA_DB01 ~]#kernel.shmmax = 32212254720kernel.shmall = 1073741824kernel.sem = 250 32000 100 384
postgres=# SELECT name, source, setting FROM pg_settings WHERE source != 'default' AND source != 'override' ORDER by 2, 1;name | source | setting
----------------------------+----------------------+----------------------------------
application_name | client | psql.bin
client_encoding | client | UTF8
archive_command | configuration file | cp %p /dbkup/momacpp_213_live/%f
archive_mode | configuration file | on
autovacuum | configuration file | on
autovacuum_max_workers | configuration file | 3
checkpoint_segments | configuration file | 200
checkpoint_timeout | configuration file | 300
checkpoint_warning | configuration file | 30
DateStyle | configuration file | ISO, MDY
default_text_search_config | configuration file | pg_catalog.english
effective_cache_size | configuration file | 524288
lc_messages | configuration file | en_US.UTF-8
lc_monetary | configuration file | en_US.UTF-8
lc_numeric | configuration file | en_US.UTF-8
lc_time | configuration file | en_US.UTF-8
listen_addresses | configuration file | *
log_destination | configuration file | stderr
log_directory | configuration file | pg_log
logging_collector | configuration file | on
log_line_prefix | configuration file | %t
log_rotation_age | configuration file | 1440
maintenance_work_mem | configuration file | 1638400
max_connections | configuration file | 2000
max_files_per_process | configuration file | 2000
max_wal_senders | configuration file | 5
port | configuration file | 5432
shared_buffers | configuration file | 1572864
temp_buffers | configuration file | 4096
wal_level | configuration file | archive
work_mem | configuration file | 32768
log_timezone | environment variable | Asia/Kolkata
max_stack_depth | environment variable | 2048
TimeZone | environment variable | Asia/Kolkata
(34 rows)
postgres=#
Regards,
Sachin Srivastava
Assistant Technical Lead(Oracle/PostgreSQL) | TSG
Cyient | www.cyient.com
