The max_connections value in MySQL instance monitoring often shows as 1000 because this is the default or statically configured maximum number of concurrent connections allowed by the MySQL server, unless explicitly modified. Monitoring tools typically display the configured value (static or dynamic) rather than the real-time usage or dynamically adjusted limit.
For example, if you haven't changed the max_connections parameter in the MySQL configuration file (my.cnf or my.ini), the default value is usually 151 for most MySQL versions, but some managed services or pre-configured instances may set it to 1000 for performance or compatibility reasons. The monitoring panel reflects this configured value, not the current active connections or any runtime adjustments.
To verify or modify the actual max_connections value, you can run:
SHOW VARIABLES LIKE 'max_connections';
If you need to adjust it dynamically (without restarting MySQL), use:
SET GLOBAL max_connections = 2000;
However, dynamic changes may reset after a server restart unless applied permanently in the configuration file.
In Tencent Cloud's managed MySQL services (like TencentDB for MySQL), the max_connections value can be configured through the console or API, and monitoring tools will still display the configured limit unless explicitly set to show real-time usage. If you need finer control, consider using Tencent Cloud's Database Audit or Performance Monitoring services to track connection trends.