Debian Codegraph @

mysql-test/suite/sys_vars/t/max_user_connections_func.test

raw
1 ############# mysql-test\t\max_user_connections_func.test ####################
2 # #
3 # Variable Name: max_user_connections #
4 # Scope: SESSION #
5 # Access Type: Dynamic #
6 # Data Type: NUMERIC #
7 # Default Value: - #
8 # Values: 1-4294967295 #
9 # #
10 # #
11 # Creation Date: 2008-03-02 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable "max_user_connections #
15 # that checks behavior of this variable in the following ways #
16 # * Functionality based on different values #
17 # #
18 # Reference: #
19 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
20 # option_mysqld_max_user_connections #
21 # #
22 # Modified: 2008-07-10 HHUNGER: Inserted wait condition #
23 # #
24 ##############################################################################
25
26 --echo ** Setup **
27 --echo
28 #
29 # Setup
30 #
31
32
33 SET @default_max_user_connections = @@global.max_user_connections;
34
35 ###################################
36 #Setting value max_user_connection#
37 ###################################
38
39 Set Global max_user_connections=2;
40
41 --echo '#--------------------FN_DYNVARS_114_01-------------------------#'
42 ########################################
43 #Should not make more then 2 connection#
44 ########################################
45
46 --echo ** Connecting conn1 using username 'root' **
47 CONNECT (conn1,localhost,root,,);
48
49 --echo ** Connecting conn2 using username 'root' **
50 CONNECT (conn2,localhost,root,,);
51
52 --echo ** Connecting conn3 using username 'root' **
53 --disable_query_log
54 --Error ER_TOO_MANY_USER_CONNECTIONS
55 CONNECT (conn3,localhost,root,,);
56 --enable_query_log
57 --echo Expected error "too many connections"
58
59 --echo ** Disconnecting conn1 **
60 DISCONNECT conn1;
61
62 --echo ** Poll till disconnected conn1 disappears from processlist
63 let $wait_condition= SELECT count(id) <= 2
64 FROM information_schema.processlist WHERE user = 'root';
65 --source include/wait_condition.inc
66
67 --echo '#--------------------FN_DYNVARS_114_02-------------------------#'
68 #####################################################
69 #Set value to 3 and see if 3 connections can be made#
70 #####################################################
71
72 Set Global max_user_connections=3;
73 --echo ** Connecting conn5 using username 'root' **
74 CONNECT (conn5,localhost,root,,);
75 --echo ** Connecting conn6 using username 'root' **
76 CONNECT (conn6,localhost,root,,);
77
78 #
79 # Cleanup
80 #
81
82 --echo ** Connection default **
83 CONNECTION default;
84
85 --echo ** Disconnecting conn5, conn6 **
86 DISCONNECT conn2;
87 DISCONNECT conn5;
88 DISCONNECT conn6;
89
90 SET @@global.max_user_connections = @default_max_user_connections;
91