Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.2 Reference Manual  / ...  / MySQL NDB Cluster 9.2  / 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.

  • --character-sets-dir

    Command-Line Format--character-sets-dir=path

    Directory containing character sets.

  • --core-file

    Command-Line Format--core-file

    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.

  • --no-login-paths

    Command-Line Format--no-login-paths

    Skips reading options from the login path 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 connection string for connecting tondb_mgmd. Syntax:[nodeid=id;][host=]hostname[:port]. Overrides entries inNDB_CONNECTSTRING andmy.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

    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: