Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ndb_index_stat(1) [linux man page]

NDB_INDEX_STAT(1)					       MySQL Database System						 NDB_INDEX_STAT(1)

NAME
ndb_index_stat - NDB index statistics utility SYNOPSIS
ndb_index_stat options DESCRIPTION
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 Options Common to MySQL Cluster Programs(1). Table 17.21. ndb_index_stat Options and Variables: MySQL Cluster NDB 7.2 +---------------------------------+--------------------------------------+-------------------------------------+ |Format | Description | Added / Removed | +---------------------------------+--------------------------------------+-------------------------------------+ | | Name of the database containing the | | | --database=name, | table. | All MySQL 5.5 based releases | | | | | | -d | | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Delete index statistics for the | | | --delete | given table, stopping any | All MySQL 5.5 based releases | | | auto-update | | | | previously configured. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Update index statistics for the | | | --update | given table, restarting any | All MySQL 5.5 based releases | | | auto-update | | | | previously configured. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Print the query cache. | | | --dump | | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Perform a number of random range | | | --query=# | queries on first key attr (must be | All MySQL 5.5 based releases | | | int | | | | unsigned). | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Drop any statistics tables and | | | --sys-drop | events in NDB kernel (all statistics | All MySQL 5.5 based releases | | | are | | | | lost) | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create all statistics tables and | | | --sys-create | events in NDB kernel, if none of | All MySQL 5.5 based releases | | | them | | | | already exist | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create any statistics tables and | | | --sys-create-if-not-exist | events in NDB kernel that do not | All MySQL 5.5 based releases | | | already exist. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Create any statistics tables or | | | --sys-create-if-not-valid | events that do not already exist in | All MySQL 5.5 based releases | | | the | | | | NDB kernel. after | | | | dropping any that are invalid. | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Verify that NDB system index | | | --sys-check | statistics and event tables exist. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Do not apply sys-* options to | | | --sys-skip-tables | tables. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Do not apply sys-* options to | | | --sys-skip-events | events. | All MySQL 5.5 based releases | +---------------------------------+--------------------------------------+-------------------------------------+ | | Turn on verbose output | | | --verbose, | | All MySQL 5.5 based releases | | | | | | -v | | | +---------------------------------+--------------------------------------+-------------------------------------+ | | Set the number of times to perform a | | | --loops=# | 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. o --database=name, -d name +--------------------+------------------+ |Command-Line Format | --database=name | +--------------------+------------------+ | | -d | +--------------------+------------------+ | | Permitted Values | | +---------+--------+ | | Type | string | | +---------+--------+ | | Default | [none] | | +---------+--------+ | | Range | .. | +--------------------+---------+--------+ The name of the database that contains the table being queried. o --delete +--------------------+-------------------+ |Command-Line Format | --delete | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Delete the index statistics for the given table, stopping any auto-update that was previously configured. o --update +--------------------+-------------------+ |Command-Line Format | --update | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Update the index statistics for the given table, and restart any auto-update that previously configured. o --dump +--------------------+-------------------+ |Command-Line Format | --dump | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Dump the contents of the query cache. o --query=# +--------------------+------------------------+ |Command-Line Format | --query=# | +--------------------+------------------------+ | | Permitted Values | | +---------+--------------+ | | Type | numeric | | +---------+--------------+ | | Default | 0 | | +---------+--------------+ | | Range | 0 .. MAX_INT | +--------------------+---------+--------------+ Perform 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. o --sys-drop +--------------------+-------------------+ |Command-Line Format | --sys-drop | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Drop all statistics tables and events in the NDB kernel. This causes all statistics to be lost. o --sys-create +--------------------+-------------------+ |Command-Line Format | --sys-create | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Create all statistics tables and events in the NDB kernel. This works only if none of them exist previously. o sys-create-if-not-exist +--------------------+---------------------------+ |Command-Line Format | --sys-create-if-not-exist | +--------------------+---------------------------+ | | Permitted Values | | +------------+--------------+ | | Type | boolean | | +------------+--------------+ | | Default | true | | +------------+--------------+ | | Range | .. | +--------------------+------------+--------------+ Create any NDB system statistics tables or events (or both) that do not already exist when the program is invoked. o --sys-create-if-not-valid +--------------------+---------------------------+ |Command-Line Format | --sys-create-if-not-valid | +--------------------+---------------------------+ | | Permitted Values | | +------------+--------------+ | | Type | boolean | | +------------+--------------+ | | Default | true | | +------------+--------------+ | | Range | .. | +--------------------+------------+--------------+ Create any NDB system statistics tables or events that do not already exist, after dropping any that are invalid. o --sys-check +--------------------+-------------------+ |Command-Line Format | --sys-check | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Verify that all required system statistics tables and events exist in the NDB kernel. o --sys-skip-tables +--------------------+-------------------+ |Command-Line Format | --sys-skip-tables | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Do not apply any --sys-* options to any statistics tables. o --sys-skip-events +--------------------+-------------------+ |Command-Line Format | --sys-skip-events | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Do not apply any --sys-* options to any events. o --verbose +--------------------+-------------------+ |Command-Line Format | --verbose | +--------------------+-------------------+ | | -v | +--------------------+-------------------+ | | Permitted Values | | +---------+---------+ | | Type | boolean | | +---------+---------+ | | Default | true | | +---------+---------+ | | Range | .. | +--------------------+---------+---------+ Turn on verbose output. o --loops=# +--------------------+------------------------+ |Command-Line Format | --loops=# | +--------------------+------------------------+ | | Permitted Values | | +---------+--------------+ | | Type | numeric | | +---------+--------------+ | | Default | 0 | | +---------+--------------+ | | Range | 0 .. MAX_INT | +--------------------+---------+--------------+ Repeat commands this number of times (for use in testing). COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 NDB_INDEX_STAT(1)
Man Page