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

Re: Performance of MDB and BDB Please suggest?



Hi,

I feel search is indexed, last time in one of your replies you had mentioned mdb_stat tool and i think the indexes are present.

Any way to debug the problem.

root@tspatca2103> ./mdb_stat /root/haroon/openldap/new1/OnBoardSPR/database/ objectClass
Page size: 4096
Tree depth: 1
Branch pages: 0
Leaf pages: 1
Overflow pages: 0
Entries: 44
root@tspatca2103> ./mdb_stat /root/haroon/openldap/new1/OnBoardSPR/database/ entryCSN
Page size: 4096
Tree depth: 2
Branch pages: 1
Leaf pages: 4
Overflow pages: 0
Entries: 1000016
root@tspatca2103> ./mdb_stat /root/haroon/openldap/new1/OnBoardSPR/database/ entryUUID
Page size: 4096
Tree depth: 3
Branch pages: 33
Leaf pages: 7775
Overflow pages: 0
Entries: 1000016
root@tspatca2103> ./mdb_stat /root/haroon/openldap/new1/OnBoardSPR/database/ msisdn
Page size: 4096
Tree depth: 3
Branch pages: 20
Leaf pages: 4446
Overflow pages: 0
Entries: 400001
root@tspatca2103>


Regards,
Yajuvendra


On Fri, Aug 31, 2012 at 11:05 AM, Howard Chu <hyc@symas.com> wrote:
Yajuvendra Singh wrote:
> Hi,
>
> I did some profiling on the 2.4.32 build and the output of callgrind is
> attached as graph.
>
> below four functions are coming as bottleneck while searching
>
> mdb_cursor_set
> mdb_entry_decode
> mdb_i2dl_insert
> mdb_i2dl_search
>
> Can anyone help why below functions are taking too much CPU. Why
> mdb_entry_decode mdb_cursor_set and mdb_i2dl_search are taking all most all CPU.

Looks like your search is not indexed.

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