AnalyticDB for MySQL clusters have no hard connection limit, but too many connections on a low-spec cluster can exhaust system resources and disrupt service. Use the console or SQL to check who is connected and how many connections are open.
Both methods show only current connections and client IPs. Historical connection data is not supported.
View connections in the console
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters, then click the ID of the target cluster.
In the left-side navigation pane, click Diagnostics and Optimization > SQL Diagnostics and Optimization.
Click the Connection Information tab.
The tab shows the users, client IPs, and connection counts for the cluster.
View connections using SQL
All three queries use the INFORMATION_SCHEMA.KEPLER_CONNECTION_INFO_MERGED table, which tracks active connections for the Data Warehouse Edition cluster.
The table exposes the following columns:
| Column | Description |
|---|---|
user | The database user that opened the connection |
access_ip | The client IP address |
Query the total number of connections
To see the total number of active connections, run:
SELECT COUNT(*) FROM INFORMATION_SCHEMA.KEPLER_CONNECTION_INFO_MERGED;Example output:
+-----------+
| count(*) |
+-----------+
| 9 |
+-----------+Query connections by user
To see how many connections each database user has opened, sorted from highest to lowest, run:
SELECT COUNT(*) AS connection_count, user
FROM INFORMATION_SCHEMA.KEPLER_CONNECTION_INFO_MERGED
GROUP BY user
ORDER BY connection_count DESC;Example output:
+----------------+--------+
|connection_count| user |
+----------------+--------+
| 4 | kepler |
+----------------+--------+
| 4 | test |
+----------------+--------+
| 1 | aurora |
+----------------+--------+Query connections by client IP
To see how many connections each client IP has opened, sorted from highest to lowest, run:
SELECT COUNT(*) AS connection_count, access_ip
FROM INFORMATION_SCHEMA.KEPLER_CONNECTION_INFO_MERGED
GROUP BY access_ip
ORDER BY connection_count DESC;Example output:
+----------------+---------------+
|connection_count| access_ip |
+----------------+---------------+
| 4 | 192.168.XX.XX |
+----------------+---------------+
| 3 | 100.104.XX.XX |
+----------------+---------------+
| 1 | 100.104.XX.XX |
+----------------+---------------+
| 1 | 100.104.XX.XX |
+----------------+---------------+