Developing or Maintaining Databases

DAS provides Development Tool and intelligent O&M to help you perform routine DB instance O&M and management.

Development Tool works an easy-to-use database client for developers. It provides diverse database development functions, including data and table structure synchronization, online editing, and intelligent prompts for SQL input.

Intelligent O&M is mainly designed for database administrators (DBAs) and provides the following database O&M functions: host and instance performance analysis, slow SQL and full SQL data analysis, real-time database performance analysis and diagnosis, and database history running data analysis, and more.

This section describes how to use DAS for RDS for MySQL instances.

Managing Databases

Log in to the DAS console.
Click in the upper left corner and select a region and project.
Click in the upper left corner, and under Databases, click Data Admin Service.
In the navigation pane on the left, choose Development Tool.
Choose RDS and MySQL from the drop-down lists in the upper right corner.
Locate the MySQL DB instance you want to log in to and click Log In in the Operation column.
On the top menu bar, click Database Management and click Change to select a database you want to operate.
Click the Objects tab to view objects such as tables, views, stored procedures, events, triggers, and functions.

Database O&M

Intelligent O&M is available for paid and free instances. Paid instances can enjoy more value-added functions.

The following describes how to use Intelligent O&M to view performance trend of an RDS for MySQL instance.

Log in to the DAS console.
Click in the upper left corner and select a region and project.
Click in the upper left corner, and under Databases, click Data Admin Service.
In the navigation pane, choose Intelligent O&M > Instance List.
In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
Locate the target instance and click Details.
On the Performance tab page, perform the following operations:
- View the trends in metrics in the same time range on different days.
  You can select Select Date for Comparison, and specify the target comparison date and metrics to view trends in the metrics at the same time on different days.
  
  You can place the pointer over a time point in the trend chart to view the metric at the time point on different days.
- View real-time performance of the instance.
  You can deselect Select Date for Comparison, set a time range or select 1h, 3h, or 12h to view real-time metrics of the instance.
  
  You can place the pointer over a time point in the trend chart to view the metric at this time point.
- Customize the time range you wish to view.
  After clicking , you can drag the mouse on the chart to select a period of time. Then, you can click Analyze to go to the Slow SQL Logs page and analyze slow query logs in the time period.