求助-关于在linux下informix内存参数配置问题

dengchumeng

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
-----------------------------------------------------------------------------------------------

[informix@dbserver etc]$ onstat -p

IBM Informix Dynamic Server Version 11.50.UC6     -- On-Line -- Up 1 days 18:41:21 -- 1431060 Kbytes

如果我将 SHMVIRTSIZE 调整为 2024000 将导致数据库无法启动，这是什么原因呢？


----------------------------------------------------------------------------------------------------------------------------
服务器物理内存8G
[informix@dbserver etc]$ 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
----------------------------------------------------------------------------------------------------------------------------

liaosnet

报错信息是啥？

3sane

回复 1# dengchumeng


    换个64位版本，UC->FC

george002

可能是系统共享内存参数限制了。
sysctl -a|grep -i shm看看。

dengchumeng

首先贴上错误信息
将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:00  Checkpoint Completed:  duration was 0 seconds.
15:04:00  Tue Sep 25 - loguniq 32, logpos 0x12ef7018, timestamp: 0x1d59de6 Interval: 5815

15:04:00  Maximum server connections 26
15:04:00  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 1911, Llog used 5509

15:04:02  IBM Informix Dynamic Server Stopped.

15:04:05  IBM Informix Dynamic Server Started.
15:04:05  Segment locked: addr=0x44000000, size=1529335808
15:04:05  shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM).

15:04:05  mt_shm_init: can't create virtual segment

15:04:32  IBM Informix Dynamic Server Started.
15:04:32  Segment locked: addr=0x44000000, size=1285537792
15:04:32  shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM).

15:04:32  mt_shm_init: can't create virtual segment

dengchumeng

可能是系统共享内存参数限制了。
sysctl -a|grep -i shm看看。
---------------------------------以下是服务器信息--------------------------------------------------------
[root@server ~]# sysctl -a|grep -i shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 268435456
kernel.shmmax = 4294967295

[root@server ~]# 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

[root@server ~]#

[root@server ~]# cat /proc/sys/kernel/shmmax
4294967295

[root@server ~]# cat /proc/sys/kernel/shmmni
4096

[root@server ~]# cat /proc/sys/kernel/shmall
268435456

[root@server ~]# getconf PAGE_SIZE
4096

hansion3406

大家看怎么样 我认为很好.