Rechercher dans le manuel MySQL
22.5.10.23 The ndbinfo logbuffers Table
The logbuffer table provides information on
NDB Cluster log buffer usage.
The following table provides information about the columns in
the logbuffers table. For each column, the
table shows the name, data type, and a brief description.
Table 22.397 Columns in the logbuffers table
| Column Name | Type | Description |
|---|---|---|
node_id |
integer | The ID of this data node. |
log_type |
string | Type of log. One of: REDO,
DD-UNDO,
BACKUP-DATA, or
BACKUP-LOG. |
log_id |
integer | The log ID. |
log_part |
integer | The log part number. |
total |
integer | Total space available for this log. |
used |
integer | Space used by this log. |
logbuffers table rows reflecting two
additional log types are available 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.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-mysql-cluster-ndbinfo-logbuffers.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
