MySQL 8.4 Release Notes
25.5.2 ndbinfo_select_all — Select From ndbinfo 表
ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ndbinfo database
Not all ndbinfo tables available in the mysql client can be read by this program (see later in this section). In addition, ndbinfo_select_all can show information about some tables internal to ndbinfo which cannot be accessed using SQL, including the tables and columns metadata tables.
To select from one or more ndbinfo tables using ndbinfo_select_all, it is necessary to supply the names of the tables when invoking the program as shown here:
$> ndbinfo_select_all table_name1 [table_name2] [...]For example:
$> ndbinfo_select_all logbuffers logspaces
== logbuffers ==
node_id log_type log_id log_part total used high
5 0 0 0 33554432 262144 0
6 0 0 0 33554432 262144 0
7 0 0 0 33554432 262144 0
8 0 0 0 33554432 262144 0
== logspaces ==
node_id log_type log_id log_part total used high
5 0 0 0 268435456 0 0
5 0 0 1 268435456 0 0
5 0 0 2 268435456 0 0
5 0 0 3 268435456 0 0
6 0 0 0 268435456 0 0
6 0 0 1 268435456 0 0
6 0 0 2 268435456 0 0
6 0 0 3 268435456 0 0
7 0 0 0 268435456 0 0
7 0 0 1 268435456 0 0
7 0 0 2 268435456 0 0
7 0 0 3 268435456 0 0
8 0 0 0 268435456 0 0
8 0 0 1 268435456 0 0
8 0 0 2 268435456 0 0
8 0 0 3 268435456 0 0
$>Options that can be used with ndbinfo_select_all are shown in the following table. Additional descriptions follow the table.
-
Command-Line Format --character-sets-dir=pathDirectory containing character sets.
-
Command-Line Format --core-fileWrite core file on error; used in debugging.
-
Command-Line Format --connect-retries=#Type Integer Default Value 12Minimum Value 0Maximum Value 12Number of times to retry connection before giving up.
-
Command-Line Format --connect-retry-delay=#Type Integer Default Value 5Minimum Value 0Maximum Value 5Number of seconds to wait between attempts to contact management server.
-
Command-Line Format --connect-string=connection-stringType String Default Value [none]Same as
--ndb-connectstring. -
Command-Line Format --defaults-extra-file=pathType String Default Value [none]Read given file after global files are read.
-
Command-Line Format --defaults-file=pathType String Default Value [none]Read default options from given file only.
-
Command-Line Format --defaults-group-suffix=stringType String Default Value [none]Also read groups with concat(group, suffix).
-
Command-Line Format --delay=#Type Numeric Default Value 5Minimum Value 0Maximum Value MAX_INTThis option sets the number of seconds to wait between executing loops. Has no effect if
--loopsis set to 0 or 1. -
Command-Line Format --helpDisplay help text and exit.
-
Command-Line Format --login-path=pathType String Default Value [none]Read given path from login file.
-
Command-Line Format --no-login-pathsSkips reading options from the login path file.
-
--loops=,number-lnumberCommand-Line Format --loops=#Type Numeric Default Value 1Minimum Value 0Maximum Value MAX_INTThis option sets the number of times to execute the select. Use
--delayto set the time between loops. -
Command-Line Format --ndb-connectstring=connection-stringType String Default Value [none]Set connection string for connecting to ndb_mgmd. Syntax:
[nodeid=. Overrides entries inid;][host=]hostname[:port]NDB_CONNECTSTRINGandmy.cnf. -
Command-Line Format --ndb-mgmd-host=connection-stringType String Default Value [none]Same as
--ndb-connectstring. -
Command-Line Format --ndb-nodeid=#Type Integer Default Value [none]Set node ID for this node, overriding any ID set by --ndb-connectstring.
-
--ndb-optimized-node-selectionCommand-Line Format --ndb-optimized-node-selectionEnable optimizations for selection of nodes for transactions. Enabled by default; use
--skip-ndb-optimized-node-selectionto disable. -
Command-Line Format --no-defaultsDo not read default options from any option file other than login file.
-
Command-Line Format --print-defaultsPrint program argument list and exit.
-
Command-Line Format --usageDisplay help text and exit; same as --help.
-
Command-Line Format --versionDisplay version information and exit.
ndbinfo_select_all is unable to read the following tables: