DMC Management (Legacy)

Last updated: 2021-01-22 18:23:22

    This document describes the features of the legacy version of DMC, such as database/table creation, instance session management, real-time database monitoring, and InnoDB lock wait management.

    Note:

    • If you want to use features such as SQL window and visualized table data editing, you can click Go to new version on the navigation bar at the top to access the new version of DMC.
    • Currently, TencentDB for MySQL v8.0 does not support InnoDB lock wait management or phpMyAdmin.

    Database/Table Creation

    1. Log in to DMC and select Create > Create Database > Add Database or Create > Create Table on the navigation bar at the top.
    2. In the pop-up dialog box, configure the new database/table and click Submit.

      Note:

      For more information on the character set and collation, please see MySQL's official documentation.

      • Database creation dialog box:
      • Table creation dialog box:

    Instance Session Management

    Log in to DMC, select Instance Session on the navigation bar at the top, and enter the instance session management page. You can view the details of all database sessions in the instance from four dimensions: session overview, users, access sources, and databases.
    DMC allows you to kill sessions, facilitating your session management.

    Real-Time Database Monitoring

    Log in to DMC, select Instance Monitoring on the navigation bar at the top, and enter the instance monitoring page. You can view the following monitoring data which is refreshed every four seconds:

    MySQL Status Information InnoDB Row Operation Threads Network
    qps indicates the number of queries responded per second read indicates the number of read rows in the InnoDB storage engine table running indicates the number of active connections, i.e., the number of connections where SQL statements are being executed in(KB) indicates the inbound network traffic of the instance
    tps indicates the number of transactions processed per second insert indicates the number of written rows in the InnoDB storage engine table connected indicates the number of idle connections to the instance, i.e., the number of connections where SQL statements have not been executed out(KB) indicates the outbound network traffic of the instance
    ins indicates the number of INSERT statements executed per second update indicates the number of rows updated in the InnoDB storage engine table - -
    [upd] indicates the number of UPDATE statements executed per second delete indicates the number of rows deleted in the InnoDB storage engine table - -
    del indicates the number of DELETE statements executed per second - - -
    sel indicates the number of SELECT statements executed per second - - -
    [hit%] indicates the cache hit rate, which mainly refers to the hit rate of innodb_buffer_pool - - -

    Built-in phpMyAdmin

    Note:

    TencentDB for MySQL v8.0 does not support phpMyAdmin.

    Log in to DMC, select Go to PMA on the navigation bar at the top, and go to the built-in phpMyAdmin console to manage databases. The phpMyAdmin supports most MySQL features as follows:

    • View and drop/delete databases, tables, views, fields, and indexes.
    • Create, replicate, drop/delete, rename, and change databases, tables, fields, and indexes.
    • Maintain servers, databases, tables, and relevant server configurations.
    • Run and edit SQL statements.
    • Manage stored procedures and triggers.

    DBbrain Intelligent Optimization

    Log in to DMC, select DBbrain Intelligent Optimization on the navigation bar at the top, and go to the DBbrain console.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help