MySQL 8.4 Release Notes
ndbinfo_select_all 是一个客户端程序，用于从 ndbinfo 数据库中的一个或多个表中选择所有行和列ndbinfo_select_all is a client program that
selects all rows and columns from one or more tables in the
ndbinfo database
并非所有在 mysql 客户端中可用的 ndbinfo 表都可以被此程序读取（详见本节后面部分）。此外，ndbinfo_select_all 可以显示一些 ndbinfo 内部表的信息，这些表无法通过 SQL 访问，包括 tables 和 columns 元表。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.
要使用 ndbinfo_select_all 从一个或多个 ndbinfo 表中进行选择，调用程序时需要提供表的名称，如下所示：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
$>
可与 ndbinfo_select_all 一起使用的选项显示在下表中。表格之后提供了更多说明。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=path--character-sets-dir=path包含字符集的目录。Directory containing character sets.
命令行格式Command-Line Format --core-file错误时生成核心文件；用于调试。Write core file on error; used in debugging.
命令行格式Command-Line Format --connect-retries=#类型Type 整数Integer 默认值Default Value 12最小值Minimum Value 0最大值Maximum Value 12放弃之前重试连接的次数。Number of times to retry connection before giving up.
命令行格式Command-Line Format --connect-retry-delay=#类型Type 整数Integer 默认值Default Value 5最小值Minimum Value 0最大值Maximum Value 5尝试联系管理服务器之间等待的秒数。Number of seconds to wait between attempts to contact management server.
命令行格式Command-Line Format --connect-string=connection-string类型Type 字符串String 默认值Default Value [none][none]与
--ndb-connectstring相同。Same as--ndb-connectstring.命令行格式Command-Line Format --defaults-extra-file=path--defaults-extra-file=path类型Type 字符串String 默认值Default Value [none][none]在读取全局文件之后读取给定文件。Read given file after global files are read.
命令行格式Command-Line Format --defaults-file=path类型Type 字符串String 默认值Default Value [none][none]仅从指定文件读取默认选项。Read default options from given file only.
命令行格式Command-Line Format --defaults-group-suffix=string类型Type 字符串String 默认值Default Value [none][none]也读取组合了 concat(group, suffix) 的组。Also read groups with concat(group, suffix).
--delay=seconds--delay=seconds命令行格式Command-Line Format --delay=#类型Type 数字Numeric 默认值Default Value 5最小值Minimum Value 0最大值Maximum Value MAX_INTMAX_INT此选项设置执行循环之间的等待秒数。如果
--loops设置为 0 或 1，则不会产生效果。This option sets the number of seconds to wait between executing loops. Has no effect if--loopsis set to 0 or 1.命令行格式Command-Line Format --help--help显示帮助文本并退出。Display help text and exit.
命令行格式Command-Line Format --login-path=path类型Type 字符串String 默认值Default Value [none][none]从登录文件读取给定路径。Read given path from login file.
命令行格式Command-Line Format --no-login-paths跳过从登录路径文件读取选项。Skips reading options from the login path file.
--loops=,number-lnumber命令行格式Command-Line Format --loops=#类型Type 数字Numeric 默认值Default Value 1最小值Minimum Value 0最大值Maximum Value MAX_INTMAX_INT此选项设置执行 select 的次数。使用
--delay来设置循环之间的时间间隔。This option sets the number of times to execute the select. Use--delayto set the time between loops.命令行格式Command-Line Format --ndb-connectstring=connection-string类型Type 字符串String 默认值Default Value [none][none]设置用于连接到 ndb_mgmd 的连接字符串。语法：
[nodeid=。覆盖id;][host=]hostname[:port]NDB_CONNECTSTRING和my.cnf中的条目。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-string类型Type 字符串String 默认值Default Value [none][none]与
--ndb-connectstring相同。Same as--ndb-connectstring.命令行格式Command-Line Format --ndb-nodeid=#类型Type 整数Integer 默认值Default Value [none][none]为此节点设置节点 ID，覆盖任何由 --ndb-connectstring 设置的 ID。Set node ID for this node, overriding any ID set by --ndb-connectstring.
--ndb-optimized-node-selection命令行格式Command-Line Format --ndb-optimized-node-selection启用事务节点选择的优化。默认启用；使用
--skip-ndb-optimized-node-selection来禁用。Enable optimizations for selection of nodes for transactions. Enabled by default; use--skip-ndb-optimized-node-selectionto disable.命令行格式Command-Line Format --no-defaults--no-defaults除了登录文件之外，不从任何配置文件读取默认选项。Do not read default options from any option file other than login file.
命令行格式Command-Line Format --print-defaults打印程序参数列表然后退出。Print program argument list and exit.
命令行格式Command-Line Format --usage显示帮助文本并退出；同 --help。Display help text and exit; same as --help.
命令行格式Command-Line Format --version显示版本信息并退出。Display version information and exit.
ndbinfo_select_all 无法读取以下表：ndbinfo_select_all is unable to read the following tables: