NDB Cluster Internals / NDB Cluster Management Client DUMP Commands

Chapter 2 NDB Cluster Management Client DUMP Commands

Table of Contents

2.1 DUMP 1
2.2 DUMP 13
2.3 DUMP 14
2.4 DUMP 15
2.5 DUMP 16
2.6 DUMP 17
2.7 DUMP 18
2.8 DUMP 19
2.9 DUMP 20
2.10 DUMP 21
2.11 DUMP 22
2.12 DUMP 23
2.13 DUMP 24
2.14 DUMP 25
2.15 DUMP 70
2.16 DUMP 400
2.17 DUMP 401
2.18 DUMP 402
2.19 DUMP 403
2.20 DUMP 406
2.21 DUMP 502
2.22 DUMP 503
2.23 DUMP 504
2.24 DUMP 505
2.25 DUMP 506
2.26 DUMP 908
2.27 DUMP 935
2.28 DUMP 1000
2.29 DUMP 1001
2.30 DUMP 1223
2.31 DUMP 1224
2.32 DUMP 1225
2.33 DUMP 1226
2.34 DUMP 1228
2.35 DUMP 1229
2.36 DUMP 1332
2.37 DUMP 1333
2.38 DUMP 2300
2.39 DUMP 2301
2.40 DUMP 2302
2.41 DUMP 2303
2.42 DUMP 2304
2.43 DUMP 2305
2.44 DUMP 2308
2.45 DUMP 2315
2.46 DUMP 2350
2.47 DUMP 2352
2.48 DUMP 2353
2.49 DUMP 2354
2.50 DUMP 2355
2.51 DUMP 2356
2.52 DUMP 2357
2.53 DUMP 2398
2.54 DUMP 2399
2.55 DUMP 2400
2.56 DUMP 2401
2.57 DUMP 2402
2.58 DUMP 2403
2.59 DUMP 2404
2.60 DUMP 2405
2.61 DUMP 2406
2.62 DUMP 2500
2.63 DUMP 2501
2.64 DUMP 2502
2.65 DUMP 2503 (OBSOLETE)
2.66 DUMP 2504
2.67 DUMP 2505
2.68 DUMP 2506 (OBSOLETE)
2.69 DUMP 2507
2.70 DUMP 2508
2.71 DUMP 2512
2.72 DUMP 2513
2.73 DUMP 2514
2.74 DUMP 2515
2.75 DUMP 2516
2.76 DUMP 2517
2.77 DUMP 2550
2.78 DUMP 2553
2.79 DUMP 2554
2.80 DUMP 2555
2.81 DUMP 2556
2.82 DUMP 2557
2.83 DUMP 2600
2.84 DUMP 2601
2.85 DUMP 2602
2.86 DUMP 2603
2.87 DUMP 2604
2.88 DUMP 2605
2.89 DUMP 2606
2.90 DUMP 2607
2.91 DUMP 2608
2.92 DUMP 2609
2.93 DUMP 2610
2.94 DUMP 2611
2.95 DUMP 2612
2.96 DUMP 4000
2.97 DUMP 4001
2.98 DUMP 5900
2.99 DUMP 7000
2.100 DUMP 7001
2.101 DUMP 7002
2.102 DUMP 7003
2.103 DUMP 7004
2.104 DUMP 7005
2.105 DUMP 7006
2.106 DUMP 7007
2.107 DUMP 7008
2.108 DUMP 7009
2.109 DUMP 7010
2.110 DUMP 7011
2.111 DUMP 7012
2.112 DUMP 7013
2.113 DUMP 7014
2.114 DUMP 7015
2.115 DUMP 7016
2.116 DUMP 7017
2.117 DUMP 7018
2.118 DUMP 7019
2.119 DUMP 7020
2.120 DUMP 7021
2.121 DUMP 7022
2.122 DUMP 7023
2.123 DUMP 7024
2.124 DUMP 7026
2.125 DUMP 7027
2.126 DUMP 7032
2.127 DUMP 7033
2.128 DUMP 7034
2.129 DUMP 7080
2.130 DUMP 7090
2.131 DUMP 7099
2.132 DUMP 8004
2.133 DUMP 8005
2.134 DUMP 8010
2.135 DUMP 8011
2.136 DUMP 8013
2.137 DUMP 9800
2.138 DUMP 9801
2.139 DUMP 9988
2.140 DUMP 9989
2.141 DUMP 9992
2.142 DUMP 9993
2.143 DUMP 10000
2.144 DUMP 10001
2.145 DUMP 10002
2.146 DUMP 10003
2.147 DUMP 11000
2.148 DUMP 11001
2.149 DUMP 12001
2.150 DUMP 12002
2.151 DUMP 12009
2.152 DUMP 103003
2.153 DUMP 103004
2.154 DUMP 103005
2.155 DUMP 13000
2.156 DUMP 130001
2.157 DUMP 13002
2.158 DUMP 13003
2.159 DUMP 14000
2.160 DUMP 14001
2.161 DUMP 14002
2.162 DUMP 14003
2.163 DUMP 30000
2.164 DUMP 100000
2.165 DUMP 100001
2.166 DUMP 100002
2.167 DUMP 100003
2.168 DUMP 100004
2.169 DUMP 100005
2.170 DUMP 100006
2.171 DUMP 100007
2.172 DUMP 100999
2.173 DUMP 101000
2.174 DUMP 101999
2.175 DUMP 102000
2.176 DUMP 102999
2.177 DUMP 103000
2.178 DUMP 103001
2.179 DUMP 103002
2.180 DUMP 104000
2.181 DUMP 104001
2.182 DUMP 104002
2.183 DUMP 104003
2.184 DUMP 104004

Warning

Never use these commands on a production NDB Cluster except under the express direction of MySQL Technical Support. Oracle will not be held responsible for adverse results arising from their use under any other circumstances!

DUMP commands can be used in the NDB management client (ndb_mgm) to dump debugging information to the cluster log. They are documented here, rather than in the MySQL Manual, for the following reasons:

They are intended only for use in troubleshooting, debugging, and similar activities by MySQL developers, QA, and support personnel.
Due to the way in which DUMP commands interact with memory, they can cause a running NDB Cluster to malfunction or even to fail completely when used.
The formats, arguments, and even availability of these commands are not guaranteed to be stable. All of this information is subject to change at any time without prior notice.
For the preceding reasons, DUMP commands are neither intended nor warranted for use in a production environment by end-users.

General syntax:

ndb_mgm> node_id DUMP code [arguments]

This causes the contents of one or more NDB registers on the node with ID node_id to be dumped to the cluster log. The registers affected are determined by the value of code. Some (but not all) DUMP commands accept additional arguments; these are noted and described where applicable.

Individual DUMP commands are listed by their code values in the sections that follow.

Each listing includes the following information:

The code value
The relevant NDB kernel block or blocks (see Chapter 4, NDB Kernel Blocks, for information about these)
The DUMP code symbol where defined; if undefined, this is indicated using a triple dash: ---.
Sample output; unless otherwise stated, it is assumed that each DUMP command is invoked as shown here:
```
ndb_mgm> 2 DUMP code
```
Generally, this is from the cluster log; in some cases, where the output may be generated in the node log instead, this is indicated. Where the DUMP command produces errors, the output is generally taken from the error log.
Where applicable, additional information such as possible extra arguments, warnings, state or other values returned in the DUMP command' output, and so on. Otherwise its absence is indicated with “[N/A]”.

Note

DUMP command codes are not necessarily defined sequentially. For example, codes 2 through 12 are currently undefined, and so are not listed. However, individual DUMP code values are subject to change, and there is no guarantee that a given code value will continue to be defined for the same purpose (or defined at all, or undefined) over time.

There is also no guarantee that a given DUMP code—even if currently undefined—will not have serious consequences when used on a running NDB Cluster.

For information concerning other ndb_mgm client commands, see Commands in the NDB Cluster Management Client.

Note

DUMP codes in the following ranges are currently unused and thus unsupported:

3000 to 5000
6000 to 7000
13000 and higher

PREV HOME UP NEXT