User configuration item
This document mainly introduces related configuration items at the User level. The configuration of the User level is mainly effective for a single user. Each user can set their own User property. Does not affect each other.
View configuration itemsβ
After the FE is started, on the MySQL client, use the following command to view the User configuration items:
SHOW PROPERTY [FOR user] [LIKE key pattern]
The specific syntax can be queried through the command: help show property;.
Set configuration itemsβ
After FE is started, on the MySQL client, modify the User configuration items with the following command:
SET PROPERTY [FOR'user'] 'key' = 'value' [,'key' ='value']
The specific syntax can be queried through the command: help set property;.
User-level configuration items will only take effect for the specified users, and will not affect the configuration of other users.
Application examplesβ
-
Modify the max_user_connections of user Billie
Use
SHOW PROPERTY FOR 'Billie' LIKE '%max_user_connections%';to check that the current maximum number of links for Billie users is 100.Use
SET PROPERTY FOR 'Billie' 'max_user_connections' = '200';to modify the current maximum number of connections for Billie users to 200.
Configuration item listβ
max_user_connectionsβ
The maximum number of user connections, the default value is 100 In general, this parameter does not need to be changed unless the number of concurrent queries exceeds the default value.
max_query_instancesβ
The maximum number of instances that the user can use at a certain point in time, The default value is -1, negative number means use default_max_query_instances config.
