[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#7455) MDB database grows without bound



quanah@OpenLDAP.org wrote:
> Full_Name: Quanah Gibson-Mount
> Version: 2.4.33
> OS: Linux 2.6
> URL: ftp://ftp.openldap.org/incoming/
> Submission from: (NULL) (74.196.25.250)
>
>
> I have a very small DB (about 25MB from a fresh slapadd).  However, the data.mdb
> file grows by about 50MB a day.  I.e., the database size on disk *doubles* every
> day.  It is now up to 571MB in size after
>
>
> Here is the DB after a fresh slapadd:
> zimbra@zre-ldap002:~/data/ldap/mdb/db$ du -c -h data.mdb
> 25M     data.mdb
>
> Here is the DB on the production server:
> [zimbra@ldap01-zcs db]$ du -c -h data.mdb
> 571M    data.mdb

Based on the mdb_stat output you pasted, this is simply a case of overflow 
pages not reusing freelist pages. The significant info here is the freelist 
info and the number of overflow pages used in the id2e database.

   Environment Info
     Map address: (nil)
     Map size: 85899345920
     Page size: 4096
     Max pages: 20971520
     Number of pages used: 146230
     Last transaction ID: 192037
     Max readers: 126
     Number of readers used: 10
   Freelist Status
     Tree depth: 3
     Branch pages: 7
     Leaf pages: 668
     Overflow pages: 32
     Entries: 10671
     Free pages: 141005
   Status of Main DB
     Tree depth: 1
     Branch pages: 0
     Leaf pages: 1
     Overflow pages: 0
     Entries: 38
     ...
   Status of ad2i
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 20
     Overflow pages: 0
     Entries: 976
   Status of cn
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 231
     Overflow pages: 0
     Entries: 30224
   Status of displayName
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 91
     Overflow pages: 0
     Entries: 13625
   Status of dn2i
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 114
     Overflow pages: 0
     Entries: 5935
   Status of entryCSN
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 37
     Overflow pages: 0
     Entries: 2967
   Status of entryUUID
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 26
     Overflow pages: 0
     Entries: 2967
   Status of givenName
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 24
     Overflow pages: 0
     Entries: 3318
   Status of id2e
     Tree depth: 3
     Branch pages: 7
     Leaf pages: 721
     Overflow pages: 1937
     Entries: 2968
   Status of mail
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 141
     Overflow pages: 0
     Entries: 33250
   Status of objectClass
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 9
     Overflow pages: 0
     Entries: 9353
   Status of sn
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 53
     Overflow pages: 0
     Entries: 7502
   Status of uid
     Tree depth: 2
     Branch pages: 1
     Leaf pages: 13
     Overflow pages: 0
     Entries: 3148
     ...


-- 
   -- Howard Chu
   CTO, Symas Corp.           http://www.symas.com
   Director, Highland Sun     http://highlandsun.com/hyc/
   Chief Architect, OpenLDAP  http://www.openldap.org/project/