ndbinfo_select_allis a client program that selects all rows and columns from one or more tables in thendbinfo
database
Not allndbinfo
tables available in themysql客户通过这个程序可以读取。此外,ndbinfo_select_allcan show information about some tables internal tondbinfo
which cannot be accessed using SQL, including thetables
andcolumns
metadata tables.
To select from one or morendbinfo
tables usingndbinfo_select_all, it is necessary to supply the names of the tables when invoking the program as shown here:
shell> ndbinfo_select_alltable_name1[table_name2] [...]
For example:
shell> 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 shell>
Options that can be used withndbinfo_select_all下表所示。附加备注说明iptions follow the table.
Table 21.23 Command-line options used with the program ndbinfo_select_all
Format | Description | Added, Deprecated, or Removed |
---|---|---|
Directory containing character sets | (Supported in all NDB releases based on MySQL 5.7) |
|
Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 5.7) |
|
Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 5.7) |
|
Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 5.7) |
|
Name of database where table is located | (Supported in all NDB releases based on MySQL 5.7) |
|
阅读计划投入en file after global files are read | (Supported in all NDB releases based on MySQL 5.7) |
|
Read default options from given file only | (Supported in all NDB releases based on MySQL 5.7) |
|
Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 5.7) |
|
Set delay in seconds between loops | (Supported in all NDB releases based on MySQL 5.7) |
|
Display help text and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
阅读计划投入en path from login file | (Supported in all NDB releases based on MySQL 5.7) |
|
Set number of times to perform select | (Supported in all NDB releases based on MySQL 5.7) |
|
Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf | (Supported in all NDB releases based on MySQL 5.7) |
|
Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 5.7) |
|
Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable | (Supported in all NDB releases based on MySQL 5.7) |
|
Set degree of parallelism | (Supported in all NDB releases based on MySQL 5.7) |
|
Print program argument list and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 5.7) |
|
Display version information and exit | (Supported in all NDB releases based on MySQL 5.7) |
-
Command-Line Format --character-sets-dir=path
Directory containing character sets.
-
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]
Same as
--ndb-connectstring
. -
Command-Line Format --core-file
Write core file on error; used in debugging.
-
Command-Line Format --defaults-extra-file=path
Type String Default Value [none]
阅读计划投入en file after global files are read.
-
Command-Line Format --defaults-file=path
Type String Default Value [none]
Read default options from given file only.
-
Command-Line Format --defaults-group-suffix=string
Type String Default Value [none]
Also read groups with concat(group, suffix).
-
Command-Line Format --delay=#
Type Numeric Default Value 5
Minimum Value 0
Maximum Value MAX_INT
This option sets the number of seconds to wait between executing loops. Has no effect if
——循环
is set to 0 or 1. -
Command-Line Format --help
Display help text and exit.
-
Command-Line Format --login-path=path
Type String Default Value [none]
阅读计划投入en path from login file.
-
Command-Line Format ——循环=#
Type Numeric Default Value 1
Minimum Value 0
Maximum Value MAX_INT
This option sets the number of times to execute the select. Use
--delay
to set the time between loops. -
Command-Line Format --ndb-connectstring=connection-string
Type String Default Value [none]
Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf.
-
Command-Line Format ——ndb-mgmd-host =连接字符串
Type 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-selection
Command-Line Format --ndb-optimized-node-selection
Enable optimizations for selection of nodes for transactions. Enabled by default; use
--skip-ndb-optimized-node-selection
to disable.-
Command-Line Format --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
Display help text and exit; same as
--help
. -
Command-Line Format --version
Display version information and exit.