Hi,
I am having some strange problems woth sapdb performance. Although I got a
lot of tips and read a lot of papers about configuring SAPDB i dont think it
is wrking as I need.
(Probably is my fault, but I hope to be easir with MaxDB).
Is there any tutorial on "How to migrate from SAPDB 7.403.32 to MaxDB
<maxdb@lists.mysql.com>
Do you think I should try more configurarion parameters or upgrade the
database is really necessary
My configurantion parameters:
KERNELVERSION string KERNEL 7.4.3 BUILD 032-121-068-842
INSTANCE_TYPE string OLTP
MAXARCHIVELOGS int 2
MAXDATADEVSPACES int 11
MAXBACKUPDEVS int 2
LOG_MIRRORED string NO
MAXUKPS int 1024
MAXCPU int 3
MAXUSERTASKS int 300
MAXSERVERTASKS int 21
_MAXTRANS int 1292
_LOCK_REGIONS int
MAXLOCKS int 40000
DEADLOCK_DETECTION int 4
SESSION_TIMEOUT int 900
REQUEST_TIMEOUT int 180
_PAGE_SIZE int 8192
_PACKET_SIZE int 36864
_MINREPLY_SIZE int 4096
_CAT_CACHE_MINSIZE int 262144
CAT_CACHE_SUPPLY int 49152
INIT_ALLOCATORSIZE int 237568
CACHE_SIZE int 196608
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
MEMTASK int 406
MEMUKP int 293
MEMPROC int 229
SHOW_MAX_STACK_USE string NO
LOG_SEGMENT_SIZE int 12373
My Hardware :
cpuinfo:
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) XEON(TM) CPU 2.00GHz
stepping : 4
cpu MHz : 1997.236
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) XEON(TM) CPU 2.00GHz
stepping : 4
cpu MHz : 1997.236
bogomips : 3989.50
free -m:
total used free shared buffers cached
Mem: 2026 1976 49 0 13 325
-/+ buffers/cache: 1637 388
Swap: 517 269 247
Please, If I am doing something wrong, please tell me.
Thank you very much !
--
Daniel Castro - דניאל
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
