Help Center/ Data Admin Service/ User Guide/ Distributed DDM DB Instance Management (Development Tool)/ Database Management
Updated on 2023-03-07 GMT+08:00
View PDF

Database Management

Function Overview

Table 1 Functions

Function

Description

Database information

Displays the name, IP address, character set, and SQL window of the current database.

Object list

Displays tables only.

Metadata collection

Allows DAS to automatically collects only the data such as database names, table names, and field names in an instance (user data in your tables is not included).

List details

Displays the operation area for each type of object.

You can go to the Database Management page in either of the following ways:

  • Choose Database Management on the top menu bar.
  • In the database list of the Home page, locate the target database and click Manage in the Operation column.

Object List

You can manage distributed DDM instance tables and perform operations including creating, querying, and modifying objects.

For details on how to manage tables, see Table Management.

Metadata Collection

DAS periodically collects the metadata of DB instance databases, tables, and fields and stores the collected data in the DAS database. In addition, it collects only structural metadata, but not data in user tables, which ensures data security. Metadata collection delivers the following advantages:

  • Reduces queries on user databases and the impact on the performance of user databases.
  • Improves the search performance for DB instances that contain a large number of tables and supports pagination queries.
  • If there are too many tables, the system will neither collect metadata nor display tables to minimize impacts on database performance.
  • To ensure stable performance, DAS will temporarily stop collecting data when the instance QPS is over 10,000 or TPS over 1,000.

Procedure

  1. On the Database Management page, enable Auto Metadata Collection in the upper right corner and click the Metadata Collection tab.
  2. On the displayed page, click Collect Now to start the collection. You can also stop the collection or view collection details.

    • Clear Collected Data: Clears the collected data such as metadata, database structure, and table structure.
    • Delete Logs: Deletes logs. Deleted logs cannot be restored. Exercise caution when performing this operation.