Rechercher dans le manuel MySQL
22.5.10.44 The ndbinfo transporters Table
This table contains information about NDB transporters.
The following table provides information about the columns in
the transporters
table. For each column, the
table shows the name, data type, and a brief description.
Additional information can be found in the notes following the
table.
Table 22.420 Columns of the transporters table
Column Name | Type | Description |
---|---|---|
node_id |
integer | This data node's unique node ID in the cluster |
remote_node_id |
integer | The remote data node's node ID |
status |
string | Status of the connection |
remote_address |
string | Name or IP address of the remote host |
bytes_sent |
integer | Number of bytes sent using this connection |
bytes_received |
integer | Number of bytes received using this connection |
connect_count |
integer | Number of times connection established on this transporter |
overloaded |
boolean (0 or 1) | 1 if this transporter is currently overloaded, otherwise 0 |
overload_count |
integer | Number of times this transporter has entered overload state since connecting |
slowdown |
boolean (0 or 1) | 1 if this transporter is in slowdown state, otherwise 0 |
slowdown_count |
integer | Number of times this transporter has entered slowdown state since connecting |
For each running data node in the cluster, the
transporters
table displays a row showing the
status of each of that node's connections with all nodes in
the cluster, including itself. This
information is shown in the table's
status column, which can have any one of
the following values: CONNECTING
,
CONNECTED
, DISCONNECTING
,
or DISCONNECTED
.
Connections to API and management nodes which are configured but
not currently connected to the cluster are shown with status
DISCONNECTED
. Rows where the
node_id
is that of a data node which is not
currently connected are not shown in this table. (This is
similar omission of disconnected nodes in the
ndbinfo.nodes
table.
The remote_address
is the host name or
address for the node whose ID is shown in the
remote_node_id
column. The
bytes_sent
from this node and
bytes_received
by this node are the numbers,
respectively, of bytes sent and received by the node using this
connection since it was established. For nodes whose status is
CONNECTING
or
DISCONNECTED
, these columns always display
0
.
Assume you have a 5-node cluster consisting of 2 data nodes, 2
SQL nodes, and 1 management node, as shown in the output of the
SHOW
command in the
ndb_mgm client:
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @10.100.10.1 (8.0.19-ndb-8.0.19, Nodegroup: 0, *)
id=2 @10.100.10.2 (8.0.19-ndb-8.0.19, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=10 @10.100.10.10 (8.0.19-ndb-8.0.19)
[mysqld(API)] 2 node(s)
id=20 @10.100.10.20 (8.0.19-ndb-8.0.19)
id=21 @10.100.10.21 (8.0.19-ndb-8.0.19)
There are 10 rows in the transporters
table—5 for the first data node, and 5 for the
second—assuming that all data nodes are running, as shown
here:
- +---------+----------------+---------------+
- +---------+----------------+---------------+
- | 1 | 1 | DISCONNECTED |
- | 1 | 2 | CONNECTED |
- | 1 | 10 | CONNECTED |
- | 1 | 20 | CONNECTED |
- | 1 | 21 | CONNECTED |
- | 2 | 1 | CONNECTED |
- | 2 | 2 | DISCONNECTED |
- | 2 | 10 | CONNECTED |
- | 2 | 20 | CONNECTED |
- | 2 | 21 | CONNECTED |
- +---------+----------------+---------------+
If you shut down one of the data nodes in this cluster using the
command 2 STOP
in the
ndb_mgm client, then repeat the previous
query (again using the mysql client), this
table now shows only 5 rows—1 row for each connection from
the remaining management node to another node, including both
itself and the data node that is currently offline—and
displays CONNECTING
for the status of each
remaining connection to the data node that is currently offline,
as shown here:
- +---------+----------------+---------------+
- +---------+----------------+---------------+
- | 1 | 1 | DISCONNECTED |
- | 1 | 2 | CONNECTING |
- | 1 | 10 | CONNECTED |
- | 1 | 20 | CONNECTED |
- | 1 | 21 | CONNECTED |
- +---------+----------------+---------------+
The connect_count
,
overloaded
,
overload_count
, slowdown
,
and slowdown_count
counters are reset on
connection, and retain their values after the remote node
disconnects. The bytes_sent
and
bytes_received
counters are also reset on
connection, and so retain their values following disconnection
(until the next connection resets them).
The overload state referred to by the
overloaded
and
overload_count
columns occurs when this
transporter's send buffer contains more than
OVerloadLimit
bytes
(default is 80% of
SendBufferMemory
, that
is, 0.8 * 2097152 = 1677721 bytes). When a given transporter is
in a state of overload, any new transaction that tries to use
this transporter fails with Error 1218 (Send Buffers
overloaded in NDB kernel). This affects both scans
and primary key operations.
The slowdown state referenced by the
slowdown
and
slowdown_count
columns of this table occurs
when the transporter's send buffer contains more than 60%
of the overload limit (equal to 0.6 * 2097152 = 1258291 bytes by
default). In this state, any new scan using this transporter has
its batch size reduced to minimize the load on the transporter.
Common causes of send buffer slowdown or overloading include the following:
Data size, in particular the quantity of data stored in
TEXT
columns orBLOB
columns (or both types of columns)Having a data node (ndbd or ndbmtd) on the same host as an SQL node that is engaged in binary logging
Large number of rows per transaction or transaction batch
Configuration issues such as insufficient
SendBufferMemory
Hardware issues such as insufficient RAM or poor network connectivity
See also Section 22.3.3.14, “Configuring NDB Cluster Send Buffer Parameters”.
Deutsche Übersetzung
Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.
Vielen Dank im Voraus.
Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-mysql-cluster-ndbinfo-transporters.html
Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.
Referenzen
Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.