求助-关于在linux下informix内存参数配置问题
RedHat Linux安装了Informix 11.50.UC6我的问题是如果将Informix内存配置参数调到大于2G将导致数据库无法正常启动
------------------------------------配置参数摘录如下-------------------------------------------
RESIDENT 0
SHMBASE 0x44000000
SHMVIRTSIZE 800000
SHMADD 200000
EXTSHMADD 200000
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0.000000
SHMNOACCESS @<84>
BUFFERPOOL size=2K,buffers=256000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
-----------------------------------------------------------------------------------------------
$ onstat -p
IBM Informix Dynamic Server Version 11.50.UC6 -- On-Line -- Up 1 days 18:41:21 -- 1431060 Kbytes
如果我将 SHMVIRTSIZE 调整为 2024000 将导致数据库无法启动，这是什么原因呢？
----------------------------------------------------------------------------------------------------------------------------
服务器物理内存8G
$ top
top - 21:57:13 up 259 days,3:39,4 users,load average: 1.00, 1.00, 1.00
Tasks: 211 total, 1 running, 209 sleeping, 0 stopped, 1 zombie
Cpu(s):0.0%us,0.0%sy,0.0%ni,100.0%id,0.0%wa,0.0%hi,0.0%si,0.0%st
Mem: 8281544k total,1330292k used,6951252k free, 181820k buffers
Swap: 16383992k total, 0k used, 16383992k free, 933684k cached
informix版本：
IBM Informix Dynamic Server Version 11.50.UC6
操作系统版本：
informix@dbserver etc]$ lsb_release -a
LSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Release: 5.5
Codename: Tikanga
---------------------------------------------------------------------------------------------------------------------------- 报错信息是啥？ 回复 1# dengchumeng
换个64位版本，UC->FC 可能是系统共享内存参数限制了。
sysctl -a|grep -i shm看看。 首先贴上错误信息
将SHMVIRTSIZE改为大于1024000 或者 将 BUFFERPOOL的 buffers 改为 512000 均导致数据库无法启动
（BUFFERPOOL size=2K,buffers=256000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000）
server:/home/informix/etc>onstat -m
shared memory not initialized for INFORMIXSERVER 'userdb'
Message Log File: /home/informix/tmp/online.log
15:04:00Checkpoint Completed:duration was 0 seconds.
15:04:00Tue Sep 25 - loguniq 32, logpos 0x12ef7018, timestamp: 0x1d59de6 Interval: 5815
15:04:00Maximum server connections 26
15:04:00Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 1911, Llog used 5509
15:04:02IBM Informix Dynamic Server Stopped.
15:04:05IBM Informix Dynamic Server Started.
15:04:05Segment locked: addr=0x44000000, size=1529335808
15:04:05shmat: : out of available data space, check system memory parameters (e.g. MAXMEM).
15:04:05mt_shm_init: can't create virtual segment
15:04:32IBM Informix Dynamic Server Started.
15:04:32Segment locked: addr=0x44000000, size=1285537792
15:04:32shmat: : out of available data space, check system memory parameters (e.g. MAXMEM).
15:04:32mt_shm_init: can't create virtual segment
可能是系统共享内存参数限制了。
sysctl -a|grep -i shm看看。
---------------------------------以下是服务器信息--------------------------------------------------------
# sysctl -a|grep -i shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 268435456
kernel.shmmax = 4294967295
# ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 4194303
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1
#
# cat /proc/sys/kernel/shmmax
4294967295
# cat /proc/sys/kernel/shmmni
4096
# cat /proc/sys/kernel/shmall
268435456
# getconf PAGE_SIZE
4096 大家看怎么样 我认为很好.
页:
[1]