Daniel, Set MAXCPU to the total number of processor cores you have, e.g. single processor/single core MAXCPU=1, single processor/dual core MAXCPU=2, dual processor/single core MAXCPU=2. Hyperthreading does not count as a core.
Daniel Quoting Daniel Castro <[EMAIL PROTECTED]>: > Hi guys, > > I have a 1Gb Server RAM, with a lot of disc free space (92Gb) : > > processor : 0 > vendor_id : GenuineIntel > cpu family : 15 > model : 4 > model name : Intel(R) Xeon(TM) CPU 3.20GHz > stepping : 3 > cpu MHz : 3200.787 > cache size : 2048 KB > physical id : 0 > siblings : 2 > core id : 0 > cpu cores : 1 > fdiv_bug : no > hlt_bug : no > f00f_bug : no > coma_bug : no > fpu : yes > fpu_exception : yes > cpuid level : 5 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca > cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni > monitor ds_cpl cid cx16 xtpr > bogomips : 6406.87 > > processor : 1 > vendor_id : GenuineIntel > cpu family : 15 > model : 4 > model name : Intel(R) Xeon(TM) CPU 3.20GHz > stepping : 3 > cpu MHz : 3200.787 > cache size : 2048 KB > physical id : 0 > siblings : 2 > core id : 0 > cpu cores : 1 > fdiv_bug : no > hlt_bug : no > f00f_bug : no > coma_bug : no > fpu : yes > fpu_exception : yes > cpuid level : 5 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca > cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni > monitor ds_cpl cid cx16 xtpr > bogomips : 6400.82 > > > A sapdb database with 30-40 users using it. This server is just for the > database. > I am doing something wrong, because the database is slow: > > KERNELVERSION string KERNEL 7.4.3 BUILD 032-121-068-842 > INSTANCE_TYPE string OLTP > MCOD string NO > ALIGN int 16 > _SERVERDB_FOR_SAP string YES > _UNICODE string NO > DEFAULT_CODE string ASCII > DATE_TIME_FORMAT string INTERNAL > CONTROLUSERID string DBM > CONTROLPASSWORD crypt > MAXARCHIVELOGS int 2 > MAXDATADEVSPACES int 11 > LOG_BACKUP_TO_PIPE string NO > MAXBACKUPDEVS int 2 > BACKUP_BLOCK_CNT int 8 > LOG_MIRRORED string NO > LOG_MODE string SINGLE > _MAXDEVSPACES int 14 > _MULT_IO_BLOCK_CNT int 8 > _DELAY_LOGWRITER int 0 > LOG_IO_QUEUE int 50 > _RESTART_TIME int 600 > MAXUKPS int 1024 > MAXCPU int 2 > MAXUSERTASKS int 150 > _TREE_RGNS int 8 > _TRANS_RGNS int 8 > _TAB_RGNS int 8 > _OMS_REGIONS int 0 > _OMS_RGNS int 25 > OMS_HEAP_LIMIT int 0 > OMS_HEAP_COUNT int 1 > OMS_HEAP_BLOCKSIZE int 10000 > OMS_HEAP_THRESHOLD int 100 > OMS_VERS_THRESHOLD int 2097152 > HEAP_CHECK_LEVEL int 0 > _ROW_RGNS int 8 > IOSERVERTASKS int > _MIN_SERVER_DESC int 21 > MAXSERVERTASKS int 21 > _ESTIM_MAXTRANS int 3 > _MAXTRANS int 692 > _LOCK_REGIONS int > MAXLOCKS int 13000 > _LOCK_SUPPLY_BLOCK int 100 > DEADLOCK_DETECTION int 4 > _LOCK_SUPPLY_SEGMS int > _ROWLOCK_HASHLIST int > _TABLOCK_HASHLIST int > _TRANS_ENTRIES int > _TRANS_HASHLIST int > SESSION_TIMEOUT int 900 > OMS_STREAM_TIMEOUT int 30 > REQUEST_TIMEOUT int 180 > _IOPROCS_PER_DEV int 2 > _IOPROCS_FOR_PRIO int 0 > _USE_IOPROCS_ONLY string NO > _IOPROCS_SWITCH int 2 > UKPS int 5 > _USER_PER_UKP int > _SERVER_PER_UKP int > LRU_FOR_SCAN string NO > _PAGE_SIZE int 8192 > _PACKET_SIZE int 36864 > _MINREPLY_SIZE int 4096 > MAXMBDATASIZE int > _MBLOCK_DATA_SIZE int 32768 > _MBLOCK_QUAL_SIZE int 8192 > MINMBLOCKSTACKSIZE int > _MBLOCK_STACK_SIZE int 16384 > _WORKSTACK_SIZE int 8192 > _WORKDATA_SIZE int 8192 > MINCATCACHESIZE int > _CAT_CACHE_MINSIZE int 262144 > CAT_CACHE_SUPPLY int 24576 > INIT_ALLOCATORSIZE int 237568 > _TASKCLUSTER_01 string tw;al;ut;2000*sv,100*bup;10*ev,10*gc; > _TASKCLUSTER_02 string ti,100*dw;75*us; > _TASKCLUSTER_03 string equalize > _DYN_TASK_STACK string NO > _MP_RGN_QUEUE string YES > _MP_RGN_DIRTY_READ string YES > _MP_RGN_BUSY_WAIT string YES > _MP_DISP_LOOPS int 2 > _MP_DISP_PRIO string YES > XP_MP_RGN_LOOP int 0 > MP_RGN_LOOP int 100 > _MP_RGN_PRIO string YES > MAXRGN_REQUEST int 3000 > _PRIO_BASE_U2U int 100 > _PRIO_BASE_IOC int 80 > _PRIO_BASE_RAV int 80 > _PRIO_BASE_REX int 40 > _PRIO_BASE_COM int 10 > _PRIO_FACTOR int 80 > _DELAY_COMMIT string NO > _SVP_1_CONV_FLUSH string NO > _MAXGARBAGE_COLL int 0 > _MAXTASK_STACK int 400 > _DW_IO_AREA_SIZE int 50 > _DW_IO_AREA_FLUSH int 50 > _FBM_DEVSP_COMPR int 50 > _FBM_DEVSP_BALANCE int 10 > _FBM_LOW_IO_RATE int 10 > CACHE_SIZE int 98304 > _DW_LRU_TAIL_FLUSH int 25 > XP_DATA_CACHE_RGNS int 0 > _DATA_CACHE_RGNS int 32 > CONVERTER_REGIONS int 8 > _MAXDATAWRITER int 32 > DYND_B12_DW_IO_BUF int > SEQUENCE_CACHE int 1 > _IDXFILE_LIST_SIZE int 2048 > DYNP_B49_IDXSIZE int > _SERVER_DESC_CACHE int 174 > _SERVER_CMD_CACHE int 22 > DEVNO_BIT_COUNT int 8 > SAVE_QUEUE_SIZE int > AUTOSAVE_QUEUE int > PAGES_PER_DATACACH int > B20_DATACACHE_HEAD int > TREEHASHLIST int 0 > B20_DATACACHE_PIDQ int > B20_DATACACHE_CB int > OPTIM_MAX_MERGE int 500 > OPTIM_INV_ONLY string YES > OPTIM_CACHE string NO > OPTIM_JOIN_FETCH int 0 > JOIN_SEARCH_LEVEL int 0 > JOIN_MAXTAB_LEVEL4 int 16 > JOIN_MAXTAB_LEVEL9 int 5 > _READAHEAD_BLOBS int 25 > RUNDIRECTORY string /dados/HE > OPMSG1 string /dev/console > OPMSG2 string /dev/null > _KERNELDIAGFILE string knldiag > KERNELDIAGSIZE int 800 > _EVENTFILE string knldiag.evt > _EVENTSIZE int 0 > _MAXEVENTTASKS int 1 > _MAXEVENTS int 100 > _KERNELTRACEFILE string knltrace > TRACE_PAGES_TI int 2 > TRACE_PAGES_GC int 0 > TRACE_PAGES_AL int 5 > TRACE_PAGES_DW int 3 > TRACE_PAGES_US int 10 > TRACE_PAGES_UT int 5 > TRACE_PAGES_SV int 5 > TRACE_PAGES_EV int 2 > TRACE_PAGES_BUP int 0 > _MAXBACKUPTASKS int > KERNELTRACESIZE int 1716 > _AK_DUMP_ALLOWED string YES > _KERNELDUMPFILE string knldump > _RTEDUMPFILE string rtedump > _UTILITY_PROTFILE string dbm.utl > UTILITY_PROTSIZE int 100 > _BACKUP_HISTFILE string dbm.knl > _BACKUP_MED_DEF string dbm.mdf > _MAX_MESSAGE_FILES int 0 > DYND_B12_VTRACE int > DYND_B20_DATACACHE int > DYND_K38_AUTOSAVE int > DYND_K38_SAVE int > DYND_K57_KB_PAGES int > DYNP_A51_CACHE int > _EVENT_ALIVE_CYCLE int 0 > DYNP_A42_PARSEID int > DYNP_B12_DATA_WRIT int > DYNP_B20_DATACACHE int > DYNP_B77_TREE_LOCK int > DYNP_K38_AUTOSAVE int > DYNP_K38_SAVE_GLOB int > _K51_LOCK_AUX1 int > _K51_LOCK_AUX2 int > DYNP_K51_LOCK_LIST int > DYNP_K90_SERVER int > _SHMCHUNK int 32 > DYNP_B930_HISTORY int > _SHAREDDYNDATA int 98607 > _SHAREDDYNPOOL int 19098 > PROCSW int > U1 int 1256 > S1 int 1048 > D1 int 304 > B1 int 152 > I1 int 384 > P1 int 392 > P2 int 43 > PT int 16 > PD int 40 > PB int 24 > IT int 24 > ID int 384 > IB int 192 > IDT int 24 > IBT int 12 > GW int 336580 > _SHMKERNEL int 822454 > COMSEG/S_SIZE int > MEMTASK int 406 > MEMUKP int 293 > MEMPROC int 229 > CODE int 2557 > ARCHIVE_LOG_? string > ARCHIVE_LOG_001 string LOG_001 > ARCHIVE_TYPE_? string > ARCHIVE_TYPE_001 string F > ARCHIVE_SIZE_? int > ARCHIVE_SIZE_001 int 35840 > M_ARCHIVE_LOG_? string > M_ARCHIVE_TYPE_? string > DATADEV_? string > DATADEV_0001 string DAT_0001 > DATA_TYPE_? string > DATA_TYPE_0001 string F > DATA_SIZE_? int > DATA_SIZE_0001 int 262144 > __PARAM_CHANGED___ int 0 > __PARAM_VERIFIED__ string 2006-07-10 14:21:54 > DIAG_HISTORY_NUM int 2 > DIAG_HISTORY_PATH string /dados/HE/DIAGHISTORY > _DIAG_SEM int 1 > SHOW_MAX_STACK_USE string NO > LOG_SEGMENT_SIZE int 11946 > _COMMENT string > SUPPRESS_CORE string YES > FORMATTING_MODE string PARALLEL > FORMAT_DATAVOLUME string YES > OFFICIAL_NODE string > LOAD_BALANCING_CHK int 0 > LOAD_BALANCING_DIF int 10 > LOAD_BALANCING_EQ int 5 > EXPAND_COM_TRACE string NO > SYMBOL_DEMANGLING string NO > USE_OPEN_DIRECT string NO > USE_COROUTINES string NO > USE_STACK_ON_STACK string YES > USE_UCONTEXT string YES > MIN_RETENTION_TIME int 60 > MAX_RETENTION_TIME int 480 > CNSTVIEW_RW_SYNC string NO > > Can you help me or give me any ideas? > I cannot change the erp system. > All the stations access with the dba user. > > Best regards, > > -- > Daniel Castro > Website: http://danielti.no-ip.info:2139 > MSN: [EMAIL PROTECTED] > Skype: danielti2005 > ICQ : 316727989 > Jabber: danielti > Linux User: 387864 > AOL User: Danielti2005 > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria > ---------------------------------------------------------------------- This mail sent through Horde-Toaster (http://qmailtoaster.clikka.com/) -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
