17.4.14 ndb_index_stat — NDB Index Statistics Utility

ndb_index_stat ...

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:

shell> ndb_index_stat -d test mytable
table:mytable index:PRIMARY fragCount:4
sampleVersion:2 loadTime:1336751773 sampleCount:0 keyBytes:0
query cache: valid:1 sampleCount:0 totalBytes:0
times in ms: save: 12.380 sort: 0.001

NDBT_ProgramExit: 0 - OK

The --verbose option provides some additional output, as shown here:

shell> ndb_index_stat -d test mytable --verbose
random seed 1337010518
connected
loop 1 of 1
table:mytable index:PRIMARY fragCount:4
sampleVersion:2 loadTime:1336751773 sampleCount:0 keyBytes:0
read stats
query cache created
query cache: valid:1 sampleCount:0 totalBytes:0
times in ms: save: 20.766 sort: 0.001
disconnected

NDBT_ProgramExit: 0 - OK

shell>

Options

The following table includes options that are specific to the MySQL Cluster ndb_index_stat utility. Additional descriptions are listed following the table. For options common to most MySQL Cluster programs (including ndb_index_stat), see Section 17.4.25, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.

Table 17.21 ndb_index_stat Options and Variables: MySQL Cluster NDB 7.2

FormatDescriptionAdded / Removed

--database=name,

-d

Name of the database containing the table.

All MySQL 5.5 based releases

--delete

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

All MySQL 5.5 based releases

--update

Update index statistics for the given table, restarting any auto-update previously configured.

All MySQL 5.5 based releases

--dump

Print the query cache.

All MySQL 5.5 based releases

--query=#

Perform a number of random range queries on first key attr (must be int unsigned).

All MySQL 5.5 based releases

--sys-drop

Drop any statistics tables and events in NDB kernel (all statistics are lost)

All MySQL 5.5 based releases

--sys-create

Create all statistics tables and events in NDB kernel, if none of them already exist

All MySQL 5.5 based releases

--sys-create-if-not-exist

Create any statistics tables and events in NDB kernel that do not already exist.

All MySQL 5.5 based releases

--sys-create-if-not-valid

Create any statistics tables or events that do not already exist in the NDB kernel. after dropping any that are invalid.

All MySQL 5.5 based releases

--sys-check

Verify that NDB system index statistics and event tables exist.

All MySQL 5.5 based releases

--sys-skip-tables

Do not apply sys-* options to tables.

All MySQL 5.5 based releases

--sys-skip-events

Do not apply sys-* options to events.

All MySQL 5.5 based releases

--verbose,

-v

Turn on verbose output

All MySQL 5.5 based releases

--loops=#

Set the number of times to perform a given command. Default is 0.

All MySQL 5.5 based releases


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 ndb_index_stat system options.

ndb_index_stat system options.  The following options are used to generate and update the statistics tables in the NDB kernel. They cannot be mixed with ndb_index_stat statistics options.