1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
set @save_log_warnings=@@log_warnings, @save_max_connections=@@max_connections;
SET GLOBAL log_warnings=4;
SET GLOBAL max_connections=10;
connect tmp_con1,localhost,root,,;
connect tmp_con2,localhost,root,,;
connect tmp_con3,localhost,root,,;
connect tmp_con4,localhost,root,,;
connect tmp_con5,localhost,root,,;
connect tmp_con6,localhost,root,,;
connect tmp_con7,localhost,root,,;
connect tmp_con8,localhost,root,,;
connect con1,localhost,root,,;
SELECT 1;
1
1
connect con2,localhost,root,,;
SELECT 2;
2
2
ERROR HY000: Too many connections
connection default;
SELECT 0;
0
0
show status like "Threads_connected";
Variable_name Value
Threads_connected 11
SET GLOBAL log_warnings=@save_log_warnings;
SET GLOBAL max_connections=@save_max_connections;
|
