Using the lmdb database backend: Difference between revisions

From SambaWiki
Line 22: Line 22:


=== Calculating space used ===
=== Calculating space used ===
As discussed in the article [https://symas.com/understanding-lmdb-database-file-sizes-and-memory-utilization/ lmdb memory utilisation and file sizes], the size of the database on disk does not reflect the actual space used. To calculate space used.
As discussed in the article [https://symas.com/understanding-lmdb-database-file-sizes-and-memory-utilization/ lmdb memory utilisation and file sizes], the size of the database on disk does not reflect the actual space used. To calculate space uses, use the <code>mdb_stat</code> tool:


# mdb_stat -ne 'CN=CONFIGURATION,DC=ADDOM,DC=SAMBA,DC=EXAMPLE,DC=COM.ldb'
Run: mdb_stat -ne file

Environment Info
Map address: (nil)
Map size: 8589934592
Page size: 4096
Max pages: 2097152
Number of pages used: 2013
Last transaction ID: 4
Max readers: 100000
Number of readers used: 3
Status of Main DB
Tree depth: 3
Branch pages: 26
Leaf pages: 1267
Overflow pages: 661
Entries: 7315

The space used is:
<code>
Page size * (Branch pages + Leaf pages + Overflow pages
</code>

Revision as of 02:15, 1 April 2020

LMDB back end

Samba can use an LMDB back end instead of the default TDB back end. The LMDB back end permits database sizes greater than 4Gb.

Enabling LMDB

The LMDB backend can be enabled when provisioning or joining a domain using the --backend-store=mdb option. The maximum size of the database files defaults to 8Gb, this can be changed with the --backend-store-size

Notes

High virtual memory allocation

LMDB uses memory mapped files so if using the default database size of 8Gb the virtual memory reported by htop for Samba processes is typically 40Gb or 80Gb. This is normal and is not normally a concern, see the following article on lmdb memory utilisation and file sizes.

Database file sizes

Identifying an LMDB file

All Samba LMDB data files have an associated lock file with the extension .ldb-lock and the data file has a .ldb extension.

Calculating space used

As discussed in the article lmdb memory utilisation and file sizes, the size of the database on disk does not reflect the actual space used. To calculate space uses, use the mdb_stat tool:

# mdb_stat -ne 'CN=CONFIGURATION,DC=ADDOM,DC=SAMBA,DC=EXAMPLE,DC=COM.ldb'
Environment Info
  Map address: (nil)
  Map size: 8589934592
  Page size: 4096
  Max pages: 2097152
  Number of pages used: 2013
  Last transaction ID: 4
  Max readers: 100000
  Number of readers used: 3
Status of Main DB
  Tree depth: 3
  Branch pages: 26
  Leaf pages: 1267
  Overflow pages: 661
  Entries: 7315

The space used is:

 Page size * (Branch pages + Leaf pages + Overflow pages