18.4.14 ndb_index_stat — NDB Index Statistics Utility

ndb_index_stat provides per-fragment
statistical information about indexes on NDB
tables. This includes cache version and age, number of index
entries per partition, and memory consumption by indexes.

Usage

To obtain basic index statistics about a given
NDB table, invoke
ndb_index_stat as shown here, with the name
of the table as the first argument and the name of the database
containing this table specified immediately following it, using
the --database
(-d) option:

ndb_index_stat table -d database

In this example, we use ndb_index_stat to
obtain such information about an NDB table
named mytable in the test
database:

ndb_index_stat statistics options.
The following options are used to generate index statistics.
They work with a given table and database. They cannot be
mixed with system options (see
ndb_index_stat system options).

--database=name,
-d name

Command-Line Format

--database=name

Permitted Values

Type

string

Default

[none]

Min Value

Max Value

The name of the database that contains the table being
queried.

--delete

Command-Line Format

--delete

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Delete the index statistics for the given table, stopping
any auto-update that was previously configured.

--update

Command-Line Format

--update

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Update the index statistics for the given table, and restart
any auto-update that was previously configured.

ndb_index_stat system options.
The following options are used to generate and update the
statistics tables in the NDB kernel. None of these options can
be mixed with statistics options (see
ndb_index_stat statistics options).

--sys-drop

Command-Line Format

--sys-drop

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Drop all statistics tables and events in the NDB kernel.
This causes all statistics to be lost.

--sys-create

Command-Line Format

--sys-create

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Create all statistics tables and events in the NDB kernel.
This works only if none of them exist previously.

sys-create-if-not-exist

Command-Line Format

--sys-create-if-not-exist

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Create any NDB system statistics tables or events (or both)
that do not already exist when the program is invoked.

--sys-create-if-not-valid

Command-Line Format

--sys-create-if-not-valid

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Create any NDB system statistics tables or events that do
not already exist, after dropping any that are invalid.

--sys-check

Command-Line Format

--sys-check

Permitted Values

Type

boolean

Default

false

Min Value

Max Value

Verify that all required system statistics tables and events
exist in the NDB kernel.