All Products
Search

This Product

    :Table data statistics

    Document Center

    :Table data statistics

    Last Updated:Nov 22, 2018

    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.