Developing or O&M Databases

Managing Databases

1. Log in to the Huawei Cloud console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Choose RDS and MySQL from the drop-down lists in the upper right corner.
6. Locate the MySQL DB instance you want to log in to and click Log In in the Operation column.
   Figure 1 Logging in to a database
   

7. On the top menu bar, click Database Management and click Change to select a database you want to operate.
   Figure 2 Database management
   

8. Click the Objects tab to view objects such as tables, views, stored procedures, events, triggers, and functions.
   Figure 3 Objects
   

   For more operations, see Managing MySQL Databases.

Database O&M

Intelligent O&M is available for paid and free instances. Paid instances can enjoy more value-added functions. For details about how to set an instance as paid, see Setting an Instance as Paid.

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

1. Log in to the Huawei Cloud console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane, choose Intelligent O&M > Instance List.

   Alternatively, on the Overview page, click Go to Intelligent O&M.

5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
6. Locate the target instance and click Details.
7. On the Performance tab page, perform the following operations:
   • Enable monitoring by seconds.
     To improve the instantaneous accuracy of monitoring metrics, you can click Enable Monitoring by Seconds. In the displayed dialog box, toggle on Monitoring by Seconds, specify the interval, and click OK.

     Figure 4 Enabling monitoring by seconds
     
   • Specifying metrics

     You can check metrics and specify metrics to create charts.

     Figure 5 Specifying metrics
     
   • You can select the classic, OOM diagnosis, read replica delay diagnosis, full space diagnosis, CPU jitter diagnosis, and large transaction identification and diagnosis views. Each view corresponds to a batch of preset metrics, which can help you diagnose DB instance problems.
     Figure 6 Querying metrics by view
     
   • 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.

     Figure 7 Performance comparison
     
   • 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.

     Figure 8 Viewing performance metrics
     
   • 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.

     Figure 9 Locating and analysis