注册

达梦数据库内存占用过高

毛政华 2026/08/20 62 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8
【操作系统】:麒麟V10
【CPU】:8
【内存】:32
【问题描述】*:
dmserver 进程内存占用过高,一直下不来,见图:
image.png
下面是dm.ini中memory相关的参数配置
MAX_OS_MEMORY = 80 #100Maximum Percent Of OS Memory
MEMORY_POOL = 2000 #2000Memory Pool Size In Megabyte
MEMORY_TARGET = 5000 #3000Memory Share Pool Target Size In Megabyte
MEMORY_EXTENT_SIZE = 1 #Memory Extent Size In Megabyte
MEMORY_LEAK_CHECK = 0 #Memory Pool Leak Checking Flag
MEMORY_MAGIC_CHECK = 1 #Memory Pool Magic Checking Flag
MEMORY_BAK_POOL = 4 #Memory Backup Pool Size In Megabyte
HUGE_MEMORY_PERCENTAGE = 50 #50Maximum percent of HUGE buffer that can be allocated to work as common memory pool
HUGE_BUFFER = 80 #80Initial Huge Buffer Size In Megabytes
HUGE_BUFFER_POOLS = 4 #number of Huge buffer pools
BUFFER = 8000 #Initial System Buffer Size In Megabytes
BUFFER_POOLS = 16 #37number of buffer pools
FAST_POOL_PAGES = 9999 #number of pages for fast pool
FAST_ROLL_PAGES = 1000 #number of pages for fast roll pages
KEEP = 8 #system KEEP buffer size in Megabytes
RECYCLE = 1000 #1000system RECYCLE buffer size in Megabytes
RECYCLE_POOLS = 41 #41Number of recycle buffer pools
ROLLSEG = 1 #system ROLLSEG buffer size in Megabytes
ROLLSEG_POOLS = 19 #Number of rollseg buffer pools
MULTI_PAGE_GET_NUM = 1 #Maximum number of pages for each read of buffer
PRELOAD_SCAN_NUM = 0 #The number of pages scanned continuously to start preload task
PRELOAD_EXTENT_NUM = 0 #The number of clusters preloaded for the first time
SORT_BUF_SIZE = 2 #maximum sort buffer size in Megabytes
SORT_BLK_SIZE = 1 #maximum sort blk size in Megabytes
SORT_BUF_GLOBAL_SIZE = 2000 #maximum global sort buffer size in Megabytes
SORT_FLAG = 0 #choose method of sort
HAGR_HASH_SIZE = 100000 #hash table size for hagr
HJ_BUF_GLOBAL_SIZE = 2000 #2000maximum hash buffer size for all hash join in Megabytes
HJ_BUF_SIZE = 250 #250maximum hash buffer size for single hash join in Megabytes
HJ_BLK_SIZE = 1 #hash buffer size allocated each time for hash join in Megabytes
HAGR_BUF_GLOBAL_SIZE = 2000 #maximum buffer size for all hagr in Megabytes
HAGR_BUF_SIZE = 250 #maximum buffer size for single hagr in Megabytes
HAGR_BLK_SIZE = 1 #buffer size allocated each time for hagr in Megabytes
MTAB_MEM_SIZE = 8 #memory table size in Kilobytes
FTAB_MEM_SIZE = 0 #file table package size in Kilobytes
MMT_GLOBAL_SIZE = 4000 #memory map table global size in megabytes
MMT_SIZE = 0 #memory map table size in megabytes
MMT_FLAG = 1 #ways of storing bdta data in memory map table
DICT_BUF_SIZE = 50 #dictionary buffer size in Megabytes
HFS_CACHE_SIZE = 160 #hfs cache size in Megabytes, used in huge horizon table for insert, update,delete
VM_STACK_SIZE = 256 #VM stack size in Kilobytes
VM_POOL_SIZE = 64 #VM pool size in Kilobytes
VM_POOL_TARGET = 8192 #VM pool target size in Kilobytes
SESS_POOL_SIZE = 64 #session pool size in Kilobytes
SESS_POOL_TARGET = 8192 #session pool target size in Kilobytes
RT_HEAP_TARGET = 8192 #runtime heap target size in Kilobytes
VM_MEM_HEAP = 0 #Whether to allocate memory to VM from HEAP
RFIL_RECV_BUF_SIZE = 16 #redo file recover buffer size in Megabytes
N_MEM_POOLS = 1 #number of memory pools
COLDATA_POOL_SIZE = 0 #coldata pool size for each worker group
HAGR_DISTINCT_HASH_TABLE_SIZE = 10000 #Size of hagr distinct hash table
CNNTB_HASH_TABLE_SIZE = 100 #Size of hash table in connect-by operation
GLOBAL_RTREE_BUF_SIZE = 100 #The total size of buffer for rtree
SINGLE_RTREE_BUF_SIZE = 10 #The size of buffer for single rtree
SORT_OPT_SIZE = 0 #once max memory size of radix sort assist count array
DFS_BUF_FLUSH_OPT = 0 #Whether to flush buffer page in opt mode for DFS storage

有没有大佬可以看下,有哪些参数优化后可以降低内存使用率

回答 0
暂无回答
扫一扫
联系客服