2.2. Monitoring Database Activity
Note
Some of the counters for Directory Server database attributes monitored by server use 64-bit integers, even on 32-bit systems (entry cache hits, entry cache tries, the current cache size, and the maximum cache size). On high-volume systems, this keeps the counters from rolling too quickly and skewing monitoring data.
2.2.1. Monitoring Database Activity Using the Command Line
To monitor the current activity of a database:
# dsconf -D "cn=Directory Manager" ldap://server.example.com monitor backend
The following table describes the attributes the command returns:
Attribute | Description |
---|---|
readonly | Indicates whether the database is in read-only mode (1 ) or in read-write mode (0 ). |
entrycachehits | The total number of successful entry cache lookups. The value is the total number of times the server could retrieve an entry from the entry cache without reloading it from the database. |
entrycachetries | The total number of entry cache lookups since you started the instance. The value is the total number, since the instance has been started, {DS} tried to retrieve entry from the entry cache. |
entrycachehitratio |
The number of entry cache tries to successful entry cache lookups. This number is based on the total lookups and hits since you last started the instance. The closer the entry cache hit ratio is to 100%, the better.
Whenever an operation attempts to find an entry that is not present in the entry cache, the server needs to access the database to obtain the entry. Thus, as this ratio drops towards zero, the number of disk accesses increases, and directory search performance decreases. To improve this ratio, increase the size of the entry cache of the database.
To improve this ratio, increase the size of the entry cache by increasing the value of the
nsslapd-cachememsize attribute in the cn= database_name, cn=ldbm database,cn=plugins,cn=config entry.
|
currententrycachesize |
The total size, in bytes, of directory entries currently present in the entry cache.
To increase the size of the entries which can be present in the cache, increase the value of the
nsslapd-cachememsize attribute in the cn= database_name, cn=ldbm database,cn=plugins,cn=config entry.
|
maxentrycachesize |
The maximum size, in bytes, of directory entries that {DS} can maintain in the entry cache.
To increase the size of the entries which can be present in the cache, increase the value of the
nsslapd-cachememsize attribute in the cn= database_name, cn=ldbm database,cn=plugins,cn=config entry.
|
currententrycachecount | The current number of entries stored in the entry cache of a given backend. |
maxentrycachecount |
The maximum number of entries stored in the entry cache of a database.
To tune this value, increase the value of the
nsslapd-cachesize attribute in the cn=database_name,cn=ldbm database,cn=plugins,cn=config
|
dncachehits | The number of times the server could process a request by obtaining a normalized distinguished name (DN) from the DN cache rather than normalizing it again. |
dncachetries | The total number of DN cache accesses since you started the instance. |
dncachehitratio | The ratio of cache tries to successful DN cache hits. The closer this value is to 100%, the better. |
currentdncachesize |
The total size, in bytes, of DN currently present in the DN cache.
To increase the size of the entries which can be present in the DN cache, increase the value of the
nsslapd-dncachememsize attribute in the cn= database_name, cn=ldbm database,cn=plugins,cn=config entry.
|
maxdncachesize |
The maximum size, in bytes, of DNs that {DS} can maintain in the DN cache.
To increase the size of the entries which can be present in the cache, increase the value of the
nsslapd-dncachememsize attribute in the cn= database_name, cn=ldbm database,cn=plugins,cn=config entry.
|
currentdncachecount | The number of DNs currently present in the DN cache. |
maxdncachecount | The maximum number of DNs allowed in the DN cache. |
2.2.2. Monitoring Database Activity Using the Web Console
To monitor the database activity using the Web Console:
- Open the Directory Server user interface in the web console. For details, see Logging Into Directory Server Using the Web Console section in the Red Hat Directory Server Administration Guide.
- Select the instance.
- On thetab, select the database entry to display.
- Select Entry Cache to display the performance values of the entry cache:The following table describes the fields visible on this tab:
Table 2.4. Fields on the Entry Cache Tab Field Name Description Entry Cache Hit Ratio Ratio that indicates the number of entry cache tries to successful entry cache lookups. This number is based on the total lookups and hits since the directory was last started. The closer this value is to 100%, the better. Whenever an operation attempts to find an entry that is not present in the entry cache, the directory has to perform a disk access to obtain the entry. Thus, as this ratio drops towards zero, the number of disk accesses increases, and directory search performance drops.To improve this ratio, increase the size of the entry cache by increasing the value of thensslapd-cachememsize
attribute in thecn=
database_name,cn=ldbm database,cn=plugins,cn=config
entry for the database.Entry Cache Tries The total number of entry cache lookups since the directory was last started. That is, the total number of entries requested since server startup. Entry Cache Hits The total number of successful entry cache lookups. That is, the total number of times the server could process a search request by obtaining data from the cache rather than by going to disk. Entry Cache Max Size The size of the entry cache in bytes maintained by the directory.This value is managed by thensslapd-cachememsize
attribute in thecn=
database_name,cn=ldbm database,cn=plugins,cn=config
entry for the database.Entry Cache Current Size The number of directory entries currently present in the entry cache. Entry Cache Max Entries DEPRECATED.The maximum number of directory entries that can be maintained in the entry cache.Do not attempt to manage the cache size by setting a maximum number of allowed entries. This can make it difficult for the host to allocate RAM effectively. Manage the cache size by setting the amount of RAM available to the cache, using thensslapd-cachememsize
attribute.Entry Cache Count The number of directory entries currently present in the entry cache. - Select DN Cache for performance values on the DN cache.