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.
Note:
For more information on the character set and collation, please see MySQL's official documentation.
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.
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 | - | - | - |
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:
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?