- 论坛徽章:
- 1
|
bufwaits 9167010 太高是buf 少了？
还是RA_PAGES 32 太大？
还是因为数据库做的 unbuffer log 的原因呀？
数据库独用分区 用的 p570 4C 逻辑cpu是8个，NUMCPUVPS 5 是否合适？
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
这2个配的太小，配成多少比较合适？
数据库 的 字符集设的是 zh_CN.5488
客户端设置为
CLIENT_LOCALE=ZH_CN.GB18030-2000
DB_LOCALE=ZH_CN.GB18030-2000
LOCPATH=/usr/lib/nls/loc
SERVER_LOCALE=ZH_CN.GB18030-2000
感觉有汉字插入报错，是否需要重新导入数据库？
数据库的配置如下，请各位兄弟拍砖
- $ onstat -c
- Informix Dynamic Server Version 9.40.FC1 -- On-Line -- Up 17 days 15:57:44 s
- Configuration File: /informix/etc/onconfig
- #**************************************************************************
- #
- # INFORMIX SOFTWARE, INC.
- #
- # Title: onconfig.std
- # Description: Informix Dynamic Server Configuration Parameters
- #
- #**************************************************************************
- # Root Dbspace Configuration
- ROOTNAME rootdbs # Root dbspace name
- ROOTPATH /informix/dbs/rootdbs # Path for device containing root dbspace
- ROOTOFFSET 4 # Offset of root dbspace into device (Kbytes)
- ROOTSIZE 1000000 # Size of root dbspace (Kbytes)
- # Disk Mirroring Configuration Parameters
- MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
- MIRRORPATH # Path for device containing mirrored root
- MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
- # Physical Log Configuration
- PHYSDBS phydbs # Location (dbspace) of physical log
- PHYSFILE 1000000 # Physical log file size (Kbytes)
- # Logical Log Configuration
- LOGFILES 19 # Number of logical log files
- LOGSIZE 30000 # Logical log size (Kbytes)
- # Diagnostics
- MSGPATH /informix/online.log # System message log file path
- CONSOLE /dev/console # System console message path
- # To automatically backup logical logs, edit alarmprogram.sh and set
- # BACKUPLOGS=Y
- #ALARMPROGRAM /informix/etc/alarmprogram.sh # Alarm program path
- #ALARMPROGRAM /informix/etc/log_full.sh # Alarm program path
- ALARMPROGRAM /informix/etc/no_log.sh # Alarm program path
- TBLSPACE_STATS 1 # Maintain tblspace statistics
- # System Archive Tape Device
- TAPEDEV /dev/null # Tape device path
- TAPEBLK 32 # Tape block size (Kbytes)
- TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
- # Log Archive Tape Device
- #LTAPEDEV /dev/rmt0 # Log tape device path
- LTAPEDEV /dev/null # Log tape device path
- LTAPEBLK 32 # Log tape block size (Kbytes)
- LTAPESIZE 1024000 # Max amount of data to put on log tape (Kbytes)
- # Optical
- STAGEBLOB # Informix Dynamic Server staging area
- # System Configuration
- SERVERNUM 0 # Unique id corresponding to a OnLine instance
- DBSERVERNAME www # Name of default database server
- DBSERVERALIASES # List of alternate dbservernames
- DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
- RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
- MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
- NUMCPUVPS 5 # Number of user (cpu) vps, 20080127 2 -> 7
- SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
- NOAGE 1 # Process aging, 20080127 0 -> 1
- AFF_SPROC 0 # Affinity start processor
- AFF_NPROCS 0 # Affinity number of processors
- # Shared Memory Parameters
- LOCKS 4000000 # Maximum number of locks
- BUFFERS 800000 # Maximum number of shared buffers
- NUMAIOVPS # Number of IO vps
- PHYSBUFF 128 # Physical log buffer size (Kbytes)
- LOGBUFF 128 # Logical log buffer size (Kbytes)
- CLEANERS 1 # Number of buffer cleaner processes
- SHMBASE 0x700000000000000 # Shared memory base address
- SHMVIRTSIZE 8000 # initial virtual shared memory segment size
- SHMADD 8192 # Size of new shared memory segments (Kbytes)
- SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
- CKPTINTVL 300 # Check point interval (in sec)
- LRUS 8 # Number of LRU queues
- LRU_MAX_DIRTY 60.000000 # LRU percent dirty begin cleaning limit
- LRU_MIN_DIRTY 50.000000 # LRU percent dirty end cleaning limit
- TXTIMEOUT 0x12c # Transaction timeout (in sec)
- STACKSIZE 64
- # Dynamic Logging
- # DYNAMIC_LOGS:
- # 2 : server automatically add a new logical log when necessary. (ON)
- # 1 : notify DBA to add new logical logs when necessary. (ON)
- # 0 : cannot add logical log on the fly. (OFF)
- #
- # When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
- # because the server can add new logical logs during long transaction rollback.
- # However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
- # can be set to smaller values.
- #
- # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
- # to avoid long transaction rollback hanging the server due to lack of logical
- # log space, i.e. 50/60 or lower.
- DYNAMIC_LOGS 2
- LTXHWM 70
- LTXEHWM 80
- # System Page Size
- # BUFFSIZE - OnLine no longer supports this configuration parameter.
- # To determine the page size used by OnLine on your platform
- # see the last line of output from the command, 'onstat -b'.
- # Recovery Variables
- # OFF_RECVRY_THREADS:
- # Number of parallel worker threads during fast recovery or an offline restore.
- # ON_RECVRY_THREADS:
- # Number of parallel worker threads during an online restore.
- OFF_RECVRY_THREADS 10 # Default number of offline worker threads
- ON_RECVRY_THREADS 1 # Default number of online worker threads
- # Data Replication Variables
- DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
- DRTIMEOUT 30 # DR network timeout (in sec)
- DRLOSTFOUND /informix/etc/dr.lostfound # DR lost+found file path
- # CDR Variables
- CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
- CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
- CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (K)
- CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 m)
- CDR_SERIAL 0,0 # Serial Column Sequence
- CDR_DBSPACE # dbspace for syscdr database
- CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
- CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces
- # CDR_MAX_DYNAMIC_LOGS
- # -1 => unlimited
- # 0 => disable dynamic log addition
- # >0 => limit the no. of dynamic log additions with the specified value.
- # Max dynamic log requests that CDR can make within one server session.
- CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default
- # Backup/Restore variables
- BAR_BSALIB_PATH /usr/tivoli/tsm/client/informix/bin64/bsashr10.o
- BAR_ACT_LOG /informix/bar_act.log # ON-Bar Log file - not in /tmp please
- BAR_DEBUG_LOG /informix/bar_dbug.log
- # ON-Bar Debug Log - not in /tmp please
- BAR_MAX_BACKUP 1
- BAR_RETRY 1
- BAR_NB_XPORT_COUNT 10
- BAR_XFER_BUF_SIZE 31
- RESTARTABLE_RESTORE on
- BAR_PROGRESS_FREQ 0
- # Informix Storage Manager variables
- ISM_DATA_POOL ISMData
- ISM_LOG_POOL ISMLogs
- # Read Ahead Variables
- RA_PAGES 32 # Number of pages to attempt to read ahead, 2002
- RA_THRESHOLD # Number of pages left before next group
- # DBSPACETEMP:
- # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
- # that the OnLine SQL Engine will use to create temp tables etc.
- # If specified it must be a colon separated list of dbspaces that exist
- # when the OnLine system is brought online. If not specified, or if
- # all dbspaces specified are invalid, various ad hoc queries will create
- # temporary files in /tmp instead.
- DBSPACETEMP tmpdbs # Default temp dbspaces
- # DUMP*:
- # The following parameters control the type of diagnostics information which
- # is preserved when an unanticipated error condition (assertion failure) occurs
- # during OnLine operations.
- # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
- DUMPDIR /tmp # Preserve diagnostics in this directory
- DUMPSHMEM 1 # Dump a copy of shared memory
- DUMPGCORE 0 # Dump a core image using 'gcore'
- DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
- DUMPCNT 1 # Number of shared memory or gcore dumps for
- # a single user's session
- FILLFACTOR 90 # Fill factor for building indexes
- # method for OnLine to use when determining current time
- USEOSTIME 0 # 0: use internal time(fast), 1: get time from )
- # Parallel Database Queries (pdq)
- MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
- DS_MAX_QUERIES # Maximum number of decision support queries
- DS_TOTAL_MEMORY # Decision support memory (Kbytes)
- DS_MAX_SCANS 1048576 # Maximum number of decision support scans
- DATASKIP off # List of dbspaces to skip
- # OPTCOMPIND
- # 0 => Nested loop joins will be preferred (where
- # possible) over sortmerge joins and hash joins.
- # 1 => If the transaction isolation mode is not
- # "repeatable read", optimizer behaves as in (2)
- # below. Otherwise it behaves as in (0) above.
- # 2 => Use costs regardless of the transaction isolation
- # mode. Nested loop joins are not necessarily
- # preferred. Optimizer bases its decision purely
- # on costs.
- OPTCOMPIND 2 # To hint the optimizer
- DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0
- ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT,T
- OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
- # HETERO_COMMIT (Gateway participation in distributed transactions)
- # 1 => Heterogeneous Commit is enabled
- # 0 (or any other value) => Heterogeneous Commit is disabled
- HETERO_COMMIT 0
- SBSPACENAME # Default smartblob space name - this is where s
- # go if no sbspace is specified when the smartblob is
- # created. It is also used by some datablades as
- # the location to put their smartblobs.
- SYSSBSPACENAME # Default smartblob space for use by the Inform
- # Server. This is used primarily for Informix Server
- # system statistics collection.
- BLOCKTIMEOUT 3600 # Default timeout for system block
- SYSALARMPROGRAM /informix/etc/evidence.sh # System Alarm program path
- # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
- OPT_GOAL -1
- ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything)
- #
- # The following are default settings for enabling Java in the database.
- # Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.
- #VPCLASS jvp,num=1 # Number of JVPs to start with
- JVPJAVAHOME /usr/informix/extend/krakatoa/jre
- # JRE installation root directory
- JVPHOME /usr/informix/extend/krakatoa # Krakatoa installation directory
- JVPPROPFILE /usr/informix/extend/krakatoa/.jvpprops # JVP property file
- JDKVERSION 1.3 # JDK version supported by this server
- # The path to the JRE libraries relative to JVPJAVAHOME
- JVPJAVALIB /bin
- # The JRE libraries to use for the Java VM
- JVPJAVAVM hpi:jvm:java:net:zip:jpeg
- # use JVPARGS to change Java VM configuration
- #To display jni call
- #JVPARGS -verbose:jni
- # Classpath to use upon Java VM start-up (use _g version for debugging)
- #JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa_g.jar:/usr/informix/extenr
- JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extendr
- $
|
|
免费注册
发表于 2008-02-17 16:55
