tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
DocumentationTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptionmax_user_connections

max_user_connections

PDF
Focus Mode
Font Size
Last updated: 2026-03-27 17:46:53

Feature Description

max_user_connections is used to set the maximum number of connections for a single user (0 means no limit on the number of connections). When the number of concurrent connections for a user exceeds the value of max_user_connections, the server will reject new connection requests from that user.
When adjusting the max_user_connections parameter, you need to consider the following factors:
System resources: Set appropriate values according to the actual resource situation of the server. When resources are sufficient, the value of max_user_connections can be appropriately increased to improve the system's concurrent processing capacity. In the case of resource shortage, the value of max_user_connections needs to be reduced to avoid resource exhaustion.
Application requirements: Set appropriate values according to the actual needs of the application. For high-concurrency applications, the value of max_user_connections may need to be increased to meet concurrent requirements. For low-concurrency applications, the value of max_user_connections can be reduced to save system resources.
User management: Set appropriate values according to the actual needs and permissions of users. For users with special permissions, the value of max_user_connections may need to be increased to meet their special needs. For ordinary users, the value of max_user_connections can be reduced to limit their resource usage.

Attribute Description

Required
Description
Parameter Type
UINT
Default Value
0
Value Range
0 ~ 4294967295
Effective Scope
GLOBAL
SESSION
Restart Required
No
Previous Topic: max_prepared_stmt_countNext Topic: net_read_timeout

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback