Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.6.15.23 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. In NDB 7.5, one of:REDO orDD-UNDO. In NDB 7.6, 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

NDB 7.6.6 makes availablelogbuffers table rows reflecting two additional log types 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. (Bug #25822988)