- 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_select_count prints the number of rows in
one or more NDB tables. With a
single table, the result is equivalent to that obtained by using
the MySQL statement SELECT COUNT(*) FROM
.
tbl_name
Usage
ndb_select_count [-cconnect_string] -ddb_nametbl_name[,tbl_name2[, ...]]
The following table includes options that are specific to the MySQL Cluster native backup restoration program ndb_select_count. Additional descriptions follow the table. For options common to most MySQL Cluster programs (including ndb_select_count), see Section 17.4.24, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.
Table 17.24. ndb_select_count Options and Variables: MySQL Cluster NDB 7.2
| Format | Description | Added / Removed |
|---|---|---|
| Name of the database in which the table is found | All MySQL 5.5 based releases |
| Degree of parallelism | All MySQL 5.5 based releases |
| Lock type | All MySQL 5.5 based releases |
You can obtain row counts from multiple tables in the same database by listing the table names separated by spaces when invoking this command, as shown under Sample Output.
Sample Output
shell> ./ndb_select_count -c localhost -d ctest1 fish dogs
6 records in table fish
4 records in table dogs
NDBT_ProgramExit: 0 - OK
User Comments
Add your own comment.