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=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]
Same as
--ndb-connectstring
. -
Command-Line Format --defaults-extra-file=path
Type String Default Value [none]
Read given 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
--loops
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]
Read given path from login file.
-
Command-Line Format --no-login-paths
Skips reading options from the login path file.
--loops=
,number
-l
number
Command-Line Format --loops=#
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 connection string for connecting to ndb_mgmd. Syntax:
[nodeid=
. Overrides entries inid
;][host=]hostname
[:port
]NDB_CONNECTSTRING
andmy.cnf
. -
Command-Line Format --ndb-mgmd-host=connection-string
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.
ndbinfo_select_all is unable to read the following tables: