Page 1 of 1

LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 6:56 am
by Mechanix
Hi,

today I´ve noticed that the ldap DB is about 80Gig but I can´t figure out how it could grow like that because I have only about 20 Mailboxes. This is a huge problem when rsync-ing the Zimbra LXC container as it takes about 30 minutes tu copy the db file.
Any hints are highly appreciated. Thank you.

ZCS 8.7


Code: Select all

/opt/zimbra/data/ldap/mdb/db# du -c -h data.mdb
81G     data.mdb
81G     total

Re: LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 7:13 am
by DualBoot
This is just an allocation, this is not the real size.

Re: LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 7:34 am
by Mechanix
Thank you for your reply. But shouldn´t

Code: Select all

du -c -h
give me the actual size?

Code: Select all

/data/ldap/mdb/db$ ls -lskh
total 81G
 81G -rw------- 1 zimbra zimbra  80G Sep 27 09:30 data.mdb
8.0K -rw------- 1 zimbra zimbra 8.0K Sep 27 09:34 lock.mdb

Re: LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 8:19 am
by phoenix
This is an old 'problem' that you could have answered yourself by searching and, as already mentioned, it's an allocated space not the used space: viewtopic.php?f=15&t=8514&p=155935&hilit=data.mdb+80gb#p155935

Re: LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 8:23 am
by brick__
Hello Mechanix,

Here's a link to zimbra documentation.
You'll find a wikipedia link in there to what a sparse file is and how to actually detect it.

Re: LDAP DB is huge (80Gig)

Posted: Tue Sep 27, 2016 8:53 am
by Mechanix
Thank you all for your replies.