Debian Codegraph @

mysql-test/suite/sys_vars/r/max_user_connections_func.result

raw
1 ** Setup **
2
3 SET @default_max_user_connections = @@global.max_user_connections;
4 Set Global max_user_connections=2;
5 '#--------------------FN_DYNVARS_114_01-------------------------#'
6 ** Connecting conn1 using username 'root' **
7 ** Connecting conn2 using username 'root' **
8 ** Connecting conn3 using username 'root' **
9 ERROR 42000: User root already has more than 'max_user_connections' active connections
10 Expected error "too many connections"
11 ** Disconnecting conn1 **
12 ** Poll till disconnected conn1 disappears from processlist
13 '#--------------------FN_DYNVARS_114_02-------------------------#'
14 Set Global max_user_connections=3;
15 ** Connecting conn5 using username 'root' **
16 ** Connecting conn6 using username 'root' **
17 ** Connection default **
18 ** Disconnecting conn5, conn6 **
19 SET @@global.max_user_connections = @default_max_user_connections;