Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


25.6.15.43 The ndbinfo logbuffers Table

Thelogbuffer table provides information on NDB Cluster log buffer usage.

Thelogbuffers table contains the following columns:

  • node_id

    The ID of this data node.

  • log_type

    Type of log. One of:REDO,DD-UNDO,BACKUP-DATA, orBACKUP-LOG.

  • log_id

    The log ID; for Disk Data undo log files, this is the same as the value shown in theLOGFILE_GROUP_NUMBER column of the Information SchemaFILES table as well as the value shown for thelog_id column of thendbinfologspaces table

  • log_part

    The log part number

  • total

    Total space available for this log

  • used

    Space used by this log

Notes

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