17127.78
18463.38

Table 5: Performance in relation to nsslapd-cachesize/nsslapd-cachememsize for various database sizes

Number of Entries

Searches per second with

Searches per second with

in the Database

cachememsize 100% or max,

cachememsize default,

 

cachesize -1,

cachesize 1,

 

dbcachesize 100% or max

dbcachesize 100% or max

100

19597.22

12049.68

10,000

19169.68

11314.75

100,000

18983.23

11399.68

250,000

18545.38

11056.25

500,000

18487.29

11048.27

1,000,000

18398.92

10817.41

From Table 5, you can see from the second column that if all the entries are cached in the entry cache (cachesize of -1, unlimited entries), and if all the pages are cached in the dbcache, then the search throughput changes minimally, no matter how big the database is. So, the number of database entries does not affect performance as long as all entries are cached. However, as shown from the third column, if only a very small percentage of entries can be held in cache (cachesize of 1), the search throughput for different sizes of databases also varies minimally. So, if dbcachesize is big enough to hold all the pages, then the average exact search throughput for any size of database with HPDS 8.1 will be between around 18398 to 19597 operations/second, depending on the number of entries present in the database (the size of the entry cache). If the cache size is restricted to minimize the number of entries in cache, the average search throughput drops considerably, ranging from around 10817 to 12049 operations/second.

Data collection 5: (Access log on compared to Access log off)

This set of data is collected to show how logging can affect the performance.

Server: Montvale-based test configuration 8 CPUs @1.6GHz each

Number of entries: 500K

Number of client threads: 128

HPDS parameter settings: nsslapd-dbcachesize and nsslapd-cachememsize are big enough to cache all the entries, and nsslapd-threadnumber is set to 6.

Table 6 shows that by turning the access log off, the exact search throughput can increase about 4% in a Montvale-based test bed.

Table 6: Performance in relation to nsslapd-accesslog setting: (on or off) Access log on or off Searches per second

ON

OFF

Data collection 6: (SSL connection enabled compared to SSL connection disabled)

This set of data is collected to show the performance impact if SSL connection is enabled or disabled.

Server: Montvale-based test configuration 8 CPUs @1.6GHz each

Number of entries: 500K

Number of client threads: 128

HPDS parameter settings: assume nsslapd-dbcachesize and nsslapd-cachememsize are big enough to cache all the entries. nsslapd-threadnumber is set to 6.

Special setting in client: “Bind for every operation” option is selected.

15