phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
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)