21.6.15.23 The ndbinfo logbuffers Table

The logbuffer table provides information on NDB Cluster log buffer usage.

The logbuffers table contains the following columns:

node_id

The ID of this data node.
log_type

Type of log. In NDB 7.5, one of: REDO or DD-UNDO. In NDB 7.6, one of: REDO, DD-UNDO, BACKUP-DATA, or BACKUP-LOG.
log_id

The log ID; for Disk Data undo log files, this is the same as the value shown in the LOGFILE_GROUP_NUMBER column of the Information Schema FILES table as well as the value shown for the log_id column of the ndbinfo logspaces table
log_part

The log part number
total

Total space available for this log
used

Space used by this log

Notes

NDB 7.6.6 makes available logbuffers table rows reflecting two additional log types when performing an NDB backup. One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer used during backup to copy fragments to backup files. The other row has the log type BACKUP-LOG, which displays the amount of log buffer used during the backup to record changes made after the backup has started. One each of these log_type rows is shown in the logbuffers table for each data node in the cluster. These rows are not present unless an NDB backup is currently being performed. (Bug #25822988)