This section describes how to obtain statistics for table data volume.
Prerequisites
You have access permissions to DMS and you have logged on to the DMS console.
Backgroud
This example uses the MySQL database.
Procedure
Log on to the DMS console.
Select a MySQL database and click Log On to Database.
On the top menu bar, choose Tools > Table Data Amount. The Table Data Amount page is displayed, as shown below.
This page shows the information about all user tables on the current instance, including the database, table names, storage engine, number of rows, row length (measured in bytes), data, indexes, all, creation time, and character set sorting rule.
You can filter the statistics on table data volumes based on a range of criteria, such as database name, table name, total table size (in MB), number of table rows, global sorting, and storage engine. You can also perform the paging, refresh, and reset operations, as shown below.