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

Re: size of DB files not decreasing

--On September 29, 2008 9:19:00 PM +0530 Nikhil Mishra <ls.niks@gmail.com> wrote:

hello all ,

While deleting the entries from openldap- Database I see that there is no change in the file size . I did an external checkpoint using db_checkpoint -1 and db_archive -d . The changes are reflected fro an add operation but it is not reflected for delete .

I have a requirement where I need to externally poll the size of DB for
openldap .
But delete operation is not making any changes to actual DB file size .
I am not sure if its a BDB limitation or something to do with the way
openldap is being configured .

Please help in understanding .

This is fairly common with all databases -- Deleted data is marked, but the space is not recovered without reloading the DB. What happens is the next time you add a new entry, that region is reused for the new entry, so the DB also won't grow until you exceed what you've deleted.



Quanah Gibson-Mount
Principal Software Engineer
Zimbra, Inc
Zimbra ::  the leader in open source messaging and collaboration