Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / ...  / MySQL NDB Cluster 8.0  / NDB Cluster Programs  /  ndbinfo_select_all — Select From ndbinfo Tables

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 allndbinfo 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 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:

$> ndbinfo_select_alltable_name1  [table_name2] [...]

For example:

$> ndbinfo_select_all logbuffers logspaces== logbuffers ==node_id log_type        log_id  log_part        total   used    high5       0       0       0       33554432        262144  06       0       0       0       33554432        262144  07       0       0       0       33554432        262144  08       0       0       0       33554432        262144  0== logspaces ==node_id log_type        log_id  log_part        total   used    high5       0       0       0       268435456       0       05       0       0       1       268435456       0       05       0       0       2       268435456       0       05       0       0       3       268435456       0       06       0       0       0       268435456       0       06       0       0       1       268435456       0       06       0       0       2       268435456       0       06       0       0       3       268435456       0       07       0       0       0       268435456       0       07       0       0       1       268435456       0       07       0       0       2       268435456       0       07       0       0       3       268435456       0       08       0       0       0       268435456       0       08       0       0       1       268435456       0       08       0       0       2       268435456       0       08       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

FormatDescriptionAdded, Deprecated, or Removed

--character-sets-dir=path

Directory containing character sets

REMOVED: 8.0.31

--connect-retries=#

Number of times to retry connection before giving up

(Supported in all NDB releases based on MySQL 8.0)

--connect-retry-delay=#

Number of seconds to wait between attempts to contact management server

(Supported in all NDB releases based on MySQL 8.0)

--connect-string=connection-string,

-c connection_string

Same as --ndb-connectstring

(Supported in all NDB releases based on MySQL 8.0)

--core-file

Write core file on error; used in debugging

REMOVED: 8.0.31

--database=db_name,

-d

Name of database where table is located

(Supported in all NDB releases based on MySQL 8.0)

--defaults-extra-file=path

Read given file after global files are read

(Supported in all NDB releases based on MySQL 8.0)

--defaults-file=path

Read default options from given file only

(Supported in all NDB releases based on MySQL 8.0)

--defaults-group-suffix=string

Also read groups with concat(group, suffix)

(Supported in all NDB releases based on MySQL 8.0)

--delay=#

Set delay in seconds between loops

(Supported in all NDB releases based on MySQL 8.0)

--help,

-?

Display help text and exit

(Supported in all NDB releases based on MySQL 8.0)

--login-path=path

Read given path from login file

(Supported in all NDB releases based on MySQL 8.0)

--loops=#,

-l

Set number of times to perform select

(Supported in all NDB releases based on MySQL 8.0)

--ndb-connectstring=connection-string,

-c

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 8.0)

--ndb-mgmd-host=connection-string,

-c

Same as --ndb-connectstring

(Supported in all NDB releases based on MySQL 8.0)

--ndb-nodeid=#

Set node ID for this node, overriding any ID set by --ndb-connectstring

(Supported in all NDB releases based on MySQL 8.0)

--no-defaults

Do not read default options from any option file other than login file

(Supported in all NDB releases based on MySQL 8.0)

--ndb-optimized-node-selection

Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable

REMOVED: 8.0.31

--parallelism=#,

-p

Set degree of parallelism

(Supported in all NDB releases based on MySQL 8.0)

--print-defaults

Print program argument list and exit

(Supported in all NDB releases based on MySQL 8.0)

--usage,

-?

Display help text and exit; same as --help

(Supported in all NDB releases based on MySQL 8.0)

--version,

-V

Display version information and exit

(Supported in all NDB releases based on MySQL 8.0)


  • --character-sets-dir

    Command-Line Format--character-sets-dir=path
    Removed8.0.31

    Directory containing character sets.

  • --core-file

    Command-Line Format--core-file
    Removed8.0.31

    Write core file on error; used in debugging.

  • --connect-retries

    Command-Line Format--connect-retries=#
    TypeInteger
    Default Value12
    Minimum Value0
    Maximum Value12

    Number of times to retry connection before giving up.

  • --connect-retry-delay

    Command-Line Format--connect-retry-delay=#
    TypeInteger
    Default Value5
    Minimum Value0
    Maximum Value5

    Number of seconds to wait between attempts to contact management server.

  • --connect-string

    Command-Line Format--connect-string=connection-string
    TypeString
    Default Value[none]

    Same as--ndb-connectstring.

  • --defaults-extra-file

    Command-Line Format--defaults-extra-file=path
    TypeString
    Default Value[none]

    Read given file after global files are read.

  • --defaults-file

    Command-Line Format--defaults-file=path
    TypeString
    Default Value[none]

    Read default options from given file only.

  • --defaults-group-suffix

    Command-Line Format--defaults-group-suffix=string
    TypeString
    Default Value[none]

    Also read groups with concat(group, suffix).

  • --delay=seconds

    Command-Line Format--delay=#
    TypeNumeric
    Default Value5
    Minimum Value0
    Maximum ValueMAX_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
    TypeString
    Default Value[none]

    Read given path from login file.

  • --loops=number,-lnumber

    Command-Line Format--loops=#
    TypeNumeric
    Default Value1
    Minimum Value0
    Maximum ValueMAX_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
    TypeString
    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
    TypeString
    Default Value[none]

    Same as--ndb-connectstring.

  • --ndb-nodeid

    Command-Line Format--ndb-nodeid=#
    TypeInteger
    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
    Removed8.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: