Skip to Content
0
Former Member
May 27, 2009 at 02:44 PM

MAXDB too slow !!

380 Views

Hello,

We are running MaxDB 7.6.06.03

on CentOS 5.3 with 16 GB RAM

MaxDB seems to be consuming the whole RAM ! the 16 GB

"
MemTotal:     16440216 kB
MemFree:        508564 kB
Buffers:        288496 kB
Cached:        3269404 kB
SwapCached:      12764 kB
Active:       12115428 kB
Inactive:      2377076 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:     16440216 kB
LowFree:        508564 kB
SwapTotal:    12289716 kB
SwapFree:     12163328 kB
Dirty:            4240 kB
Writeback:           0 kB
AnonPages:    10933132 kB
Mapped:         121976 kB
Slab:          1216804 kB
PageTables:     164460 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
CommitLimit:  20509824 kB
Committed_AS: 23502340 kB
VmallocTotal: 34359738367 kB
VmallocUsed:    275992 kB
VmallocChunk: 34359462263 kB
HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0
Hugepagesize:     2048 kB
"

is this normal for Maxdb please ?

Configuration Parameters:

Cashe_size 1548032
Instance_tyoe OLTP
Log_Mirrored NO
Log_Segment_size 21333
Maxbackupdevs 2
MaxCPU 2
Maxdatavolumes 40040
Maxlogvolumes 2
Maxusertaks 500
MCOD NO


Data Area: 
Volumes 2
totalsize 30.000,000 MB


Log Area

No. of log Volumes 1
Total Size 500,00 MB



ache Sizes Size 
    
I/O Buffer Cache 12.094,00 MB 
    Data Cache 12.090,58 MB 
    Converter 2,39 MB 
    Misc. 1,03 MB 
Catalog Cache 250,50 MB 
Sequence Cache 0,01 MB 
 
   Cache Accesses 
  Accesses Successful Unsuccessful Hit Rate 
          
Data Cache 1.257.150.612 1.256.627.690 522.922 99,96% 
    SQL Data 1.257.089.604 1.256.566.682 522.922 99,96% 
    OMS Data 0 0 0 100,00% 
    History/Undo 61.008 61.008 0 100,00% 
Catalog Cache 26.144.043 25.192.771 952.028 96,36% 
Sequence Cache 0 0 0 100,00% 
 
 
Cache-Specific Parameter Settings 
  Value 
    
CACHE_SIZE 12.094,00 MB 
CAT_CACHE_SUPPLY 250,50 MB

Thanks alot for any help in advance