Antw: Re: Efficient way to count number of entries in a database?

2017-11-15 Thread Ulrich Windl
>>> Karsten Heymann schrieb am 14.11.2017 um 15:26 >>> in Nachricht : > Hi Ulrich, > > 2017-11-14 12:40 GMT+01:00 Ulrich Windl : > >> >>> Karsten Heymann schrieb: >> > is there a more efficient way to count how many entries a ldap database >> has >> > than >> > >> > slapcat -b | grep ^dn: | w

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Karsten Heymann
Hi Quanah, 2017-11-14 16:46 GMT+01:00 Quanah Gibson-Mount : > mdb_stat -s id2e /path/to/mdb/db | grep Entries > Entries: 3993833 > That's exactly what I needed. Thanks a lot! btw for those using debian as well, mdb_stat is in the lmdb-utils package BR Karsten

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Michael Ströder
Karsten Heymann wrote: > 2017-11-14 16:21 GMT+01:00 Michael Ströder How many entries do you have in your DB? > > Currently about 1.5Mio. Way too many for using slapo-noopsrch. So Quanah's suggestion with mdb_stat is more suitable. Ciao, Michael. smime.p7s Description: S/MIME Cryptographi

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Quanah Gibson-Mount
--On Tuesday, November 14, 2017 4:35 PM +0100 Karsten Heymann wrote: Currently about 1.5Mio. If you have access to the system and have mdb_stat available, the easiest method is to simply query the database directly: mdb_stat -s id2e /path/to/mdb/db | grep Entries Entries: 3993833 --Qua

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Karsten Heymann
Hi Michael, 2017-11-14 16:21 GMT+01:00 Michael Ströder : > > Also my monitoring script does that: > https://www.stroeder.com/pylib/slapd_checkmk.py Interesting, I will have a look, especially as we might use checkmk as well. > How many entries do you have in your DB? > Currently about 1.5Mio.

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Michael Ströder
Karsten Heymann wrote: > is there a more efficient way to count how many entries a ldap database > has than You could try using contrib overlay slapo-noopsrch and then use noop search request control. But if you have many entries you will run into search timeout. ldapsearch -E 1.3.6.1.4.1.4203.66

Re: Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Karsten Heymann
Hi, 2017-11-14 15:37 GMT+01:00 Ulrich Windl : > I avoided mdb so far I can only recommend it. Its handling is so much simpler. BR Karsten

Re: Efficient way to count number of entries in a database?

2017-11-14 Thread Karsten Heymann
Hi Ulrich, 2017-11-14 12:40 GMT+01:00 Ulrich Windl : > >>> Karsten Heymann schrieb: > > is there a more efficient way to count how many entries a ldap database > has > > than > > > > slapcat -b | grep ^dn: | wc -l > > Here olmBDBDNCache from cn=Database 1,cn=Databases,cn=Monitor seems to be >