MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.
Table 23.44 Command-line options for the ndb_select_count program
Format | Description | Added, Deprecated, or Removed |
---|---|---|
|
Name of database in which table is found | (Supported in all MySQL 8.0 based releases) |
|
Degree of parallelism | (Supported in all MySQL 8.0 based releases) |
|
Lock type | (Supported in all MySQL 8.0 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