- 17.4 MySQL Cluster Programs
- 17.4.1 ndbd — The MySQL Cluster Data Node Daemon
- 17.4.2 ndbinfo_select_all — Select From ndbinfo Tables
- 17.4.3 ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- 17.4.4 ndb_mgmd — The MySQL Cluster Management Server Daemon
- 17.4.5 ndb_mgm — The MySQL Cluster Management Client
- 17.4.6 ndb_config — Extract MySQL Cluster Configuration Information
- 17.4.7 ndb_cpcd — Automate Testing for NDB Development
- 17.4.8 ndb_delete_all — Delete All Rows from an NDB Table
- 17.4.9 ndb_desc — Describe NDB Tables
- 17.4.10 ndb_drop_index — Drop Index from an NDB Table
- 17.4.11 ndb_drop_table — Drop an NDB Table
- 17.4.12 ndb_error_reporter — NDB Error-Reporting Utility
- 17.4.13 ndb_index_stat — NDB Index Statistics Utility
- 17.4.14 ndb_print_backup_file — Print NDB Backup File Contents
- 17.4.15 ndb_print_schema_file — Print NDB Schema File Contents
- 17.4.16 ndb_print_sys_file — Print NDB System File Contents
- 17.4.17 ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log
- 17.4.18 ndb_restore — Restore a MySQL Cluster Backup
- 17.4.19 ndb_select_all — Print Rows from an NDB Table
- 17.4.20 ndb_select_count — Print Row Counts for NDB Tables
- 17.4.21 ndb_show_tables — Display List of NDB Tables
- 17.4.22 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 17.4.23 ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 17.4.24 Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs
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_stattable-ddatabase
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.24, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.
Table 17.20. ndb_index_stat Options and Variables: MySQL 5.1, MySQL Cluster NDB 6.3-7.1
| Format | Description | Added / Removed |
|---|---|---|
| Name of the database containing the table. | All MySQL 5.1 based releases |
| Delete index statistics for the given table, stopping any auto-update previously configured. | All MySQL 5.1 based releases |
| Update index statistics for the given table, restarting any auto-update previously configured. | All MySQL 5.1 based releases |
| Print the query cache. | All MySQL 5.1 based releases |
| Perform a number of random range queries on first key attr (must be int unsigned). | All MySQL 5.1 based releases |
| Drop any statistics tables and events in NDB kernel (all statistics are lost) | All MySQL 5.1 based releases |
| Create all statistics tables and events in NDB kernel, if none of them already exist | All MySQL 5.1 based releases |
| Create any statistics tables and events in NDB kernel that do not already exist. | All MySQL 5.1 based releases |
| Create any statistics tables or events that do not already exist in the NDB kernel. after dropping any that are invalid. | All MySQL 5.1 based releases |
| Verify that NDB system index statistics and event tables exist. | All MySQL 5.1 based releases |
| Do not apply sys-* options to tables. | All MySQL 5.1 based releases |
| Do not apply sys-* options to events. | All MySQL 5.1 based releases |
| Turn on verbose output | All MySQL 5.1 based releases |
| Set the number of times to perform a given command. Default is 0. | All MySQL 5.1 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.
-
Command-Line Format --database=name-dPermitted Values Type stringDefault [none]Range ..The name of the database that contains the table being queried.
-
Command-Line Format --deletePermitted Values Type booleanDefault trueRange ..Delete the index statistics for the given table, stopping any auto-update that was previously configured.
-
Command-Line Format --updatePermitted Values Type booleanDefault trueRange ..Update the index statistics for the given table, and restart any auto-update that previously configured.
-
Command-Line Format --dumpPermitted Values Type booleanDefault trueRange ..Dump the contents of the query cache.
-
Command-Line Format --query=#Permitted Values Type numericDefault 0Range 0 .. MAX_INTPerform random range queries on first key attribute (must be int unsigned).
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.
-
Command-Line Format --sys-dropPermitted Values Type booleanDefault trueRange ..Drop all statistics tables and events in the NDB kernel. This causes all statistics to be lost.
-
Command-Line Format --sys-createPermitted Values Type booleanDefault trueRange ..Create all statistics tables and events in the NDB kernel. This works only if none of them exist previously.
-
Command-Line Format --sys-create-if-not-existPermitted Values Type booleanDefault trueRange ..Create any NDB system statistics tables or events (or both) that do not already exist when the program is invoked.
-
Command-Line Format --sys-create-if-not-validPermitted Values Type booleanDefault trueRange ..Create any NDB system statistics tables or events that do not already exist, after dropping any that are invalid.
-
Command-Line Format --sys-checkPermitted Values Type booleanDefault trueRange ..Verify that all required system statistics tables and events exist in the NDB kernel.
-
Command-Line Format --sys-skip-tablesPermitted Values Type booleanDefault trueRange ..Do not apply any
--sys-*options to any statistics tables. -
Command-Line Format --sys-skip-eventsPermitted Values Type booleanDefault trueRange ..Do not apply any
--sys-*options to any events. -
Command-Line Format --verbose-vPermitted Values Type booleanDefault trueRange ..Turn on verbose output.
-
Command-Line Format --loops=#Permitted Values Type numericDefault 0Range 0 .. MAX_INTRepeat commands this number of times (for use in testing).
User Comments
Add your own comment.