MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
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
ndb_select_count [-cconnection_string
] -ddb_name
tbl_name
[,tbl_name2
[, ...]]
The following table includes options that are specific to the NDB Cluster native backup restoration program ndb_select_count. Additional descriptions follow the table. For options common to most NDB Cluster programs (including ndb_select_count), see Section 21.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.
Table 21.296 Command-line options for the ndb_select_count program
Format | Description | Added, Deprecated, or Removed |
---|---|---|
|
Name of the database in which the table is found | All MySQL 5.7 based releases |
|
Degree of parallelism | All MySQL 5.7 based releases |
|
Lock type | All MySQL 5.7 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.
shell> ./ndb_select_count -c localhost -d ctest1 fish dogs
6 records in table fish
4 records in table dogs
NDBT_ProgramExit: 0 - OK