25.5.2 ndbinfo_select_all — Select From ndbinfo Tables (original) (raw)

25.5.2 ndbinfo_select_all — Select From ndbinfo Tables

ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in thendbinfo database

Not all ndbinfo tables available in themysql 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 withndbinfo_select_all are shown in the following table. Additional descriptions follow the table.

Table 25.25 Command-line options used with the program ndbinfo_select_all

• --character-sets-dir

  Command-Line Format	--character-sets-dir=path
  Removed	8.0.31
  Directory containing character sets.

• --core-file

  Command-Line Format	--core-file
  Removed	8.0.31
  Write core file on error; used in debugging.

• --connect-retries

  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.

• --connect-retry-delay

  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.

• --connect-string

  Command-Line Format	--connect-string=connection-string
  Type	String
  Default Value	[none]
  Same as--ndb-connectstring.

• --defaults-extra-file

  Command-Line Format	--defaults-extra-file=path
  Type	String
  Default Value	[none]
  Read given file after global files are read.

• --defaults-file

  Command-Line Format	--defaults-file=path
  Type	String
  Default Value	[none]
  Read default options from given file only.

• --defaults-group-suffix

  Command-Line Format	--defaults-group-suffix=string
  Type	String
  Default Value	[none]
  Also read groups with concat(group, suffix).

• --delay=seconds

  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.

• --help

  Command-Line Format	--help
  Display help text and exit.

• --login-path

  Command-Line Format	--login-path=path
  Type	String
  Default Value	[none]
  Read given path from login 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.

• --ndb-connectstring

  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.

• --ndb-mgmd-host

  Command-Line Format	--ndb-mgmd-host=connection-string
  Type	String
  Default Value	[none]
  Same as--ndb-connectstring.

• --ndb-nodeid

  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
  Removed	8.0.31
  Enable optimizations for selection of nodes for transactions. Enabled by default; use--skip-ndb-optimized-node-selection to disable.

• --no-defaults

  Command-Line Format	--no-defaults
  Do not read default options from any option file other than login file.

• --print-defaults

  Command-Line Format	--print-defaults
  Print program argument list and exit.

• --usage

  Command-Line Format	--usage
  Display help text and exit; same as --help.

• --version

  Command-Line Format	--version
  Display version information and exit.

ndbinfo_select_all is unable to read the following tables:

• arbitrator_validity_detail
• arbitrator_validity_summary
• cluster_locks
• cluster_operations
• cluster_transactions
• disk_write_speed_aggregate_node
• locks_per_fragment
• memory_per_fragment
• memoryusage
• operations_per_fragment
• server_locks
• server_operations
• server_transactions
• table_info