[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/