Unix/Linux Go Back    


Linux 2.6 - man page for ndb_index_stat (linux section 1)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


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     |			    |
       |       --database=name, 	 | containing the table.    |	     All MySQL 5.5  |
       |				 |			    |	     based releases |
       |       -d			 |			    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Delete index statistics  |			    |
       |       --delete 		 | for the given table,     |	     All MySQL 5.5  |
       |				 | stopping any auto-update |	     based releases |
       |				 |	       previously   |			    |
       |				 | configured.		    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Update index statistics  |			    |
       |       --update 		 | for the given table,     |	     All MySQL 5.5  |
       |				 | restarting any	    |	     based releases |
       |				 | auto-update		    |			    |
       |				 |	       previously   |			    |
       |				 | configured.		    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Print the query cache.   |			    |
       |       --dump			 |			    |	     All MySQL 5.5  |
       |				 |			    |	     based releases |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Perform a number of	    |			    |
       |       --query=#		 | random range queries on  |	     All MySQL 5.5  |
       |				 | first key attr (must be  |	     based releases |
       |				 | int			    |			    |
       |				 |	       unsigned).   |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Drop any statistics	    |			    |
       |       --sys-drop		 | tables and events in NDB |	     All MySQL 5.5  |
       |				 | kernel (all statistics   |	     based releases |
       |				 | are			    |			    |
       |				 |	       lost)	    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Create all statistics    |			    |
       |       --sys-create		 | tables and events in NDB |	     All MySQL 5.5  |
       |				 | kernel, if none of them  |	     based releases |
       |				 |	       already	    |			    |
       |				 | exist		    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Create any statistics    |			    |
       |       --sys-create-if-not-exist | tables and events in NDB |	     All MySQL 5.5  |
       |				 | kernel that do not	    |	     based releases |
       |				 |	       already	    |			    |
       |				 | exist.		    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Create any statistics    |			    |
       |       --sys-create-if-not-valid | tables or events that do |	     All MySQL 5.5  |
       |				 | not already exist in the |	     based releases |
       |				 |	       NDB kernel.  |			    |
       |				 | after dropping any that  |			    |
       |				 | are invalid. 	    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Verify that NDB system   |			    |
       |       --sys-check		 | index statistics and     |	     All MySQL 5.5  |
       |				 | event tables exist.	    |	     based releases |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Do not apply sys-*	    |			    |
       |       --sys-skip-tables	 | options to tables.	    |	     All MySQL 5.5  |
       |				 |			    |	     based releases |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Do not apply sys-*	    |			    |
       |       --sys-skip-events	 | options to events.	    |	     All MySQL 5.5  |
       |				 |			    |	     based releases |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Turn on verbose output   |			    |
       |       --verbose,		 |			    |	     All MySQL 5.5  |
       |				 |			    |	     based releases |
       |       -v			 |			    |			    |
       +---------------------------------+--------------------------+-----------------------+
       |				 | Set the number of times  |			    |
       |       --loops=#		 | to perform a given	    |	     All MySQL 5.5  |
       |				 | command. Default is 0.   |	     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)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 12:34 AM.