Database Management

Updated on 2023-03-07 GMT+08:00

View PDF

Function Overview

**Table 1** Functions
Function	Description
Sidebar	Consists of six types of objects (tables, views, stored procedures, events, triggers, and functions).
Database information	Displays the name, IP address, character set, SQL window, and data dictionary of the current database.
Metadata Collection	Allows DAS to automatically collect only the data such as database names, table names, and field names in an instance (data in your tables is not included). NOTE: 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.
List details	Displays the operation area for each type of object.

NOTE:

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 tables, views, stored procedures, events, triggers, and functions of the MySQL DB instances. The main operations include creating, querying, and modifying objects.

For details on how to manage tables, see Table Management.
For details on how to manage views, see View Management.
For details on how to manage events, see Event Management.
For details on how to manage stored procedures, see Stored Procedure Management.
For details on how to manage functions, see Function Management.
For details on how to manage triggers, see Trigger Management.