All Products
Search
Document Center

Table data statistics

Last Updated: Jun 08, 2019

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

  1. Log on to the DMS console.

  2. Select a MySQL database and click Log On to Database.

  3. On the top menu bar, choose Tools > Table Data Amount. The Table Data Amount page is displayed, as shown below.

    Table data amount

  4. 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.

  5. 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.