SHOW TABLECOUNT returns the number of rows and the attributes of all tables.
SHOW TABLECOUNT [<table>]
Specifying a table name will return only the information related to this table.
Number of lines in the table
The type of object:
|The analyzer mode of the table, as described in optimizer-analyzer-mode.
|Boolean indicating if this table has lines inserted or deleted and that needs to be committed.
|Number of lines in the table, if we perform a COMMIT on the table (always equal to 'lines' in case need_commit is false).
|Boolean indicating if this table should be compacted, as described in compact-tables. We consider the table's hyperindexes need compaction when the index_tombstone_percent is above 40%.
|Percentage of tombstone lines in all the hyperindexes of this table. Tombstone lines are lines that have been deleted but are still occupying space in the hyperindexes.