Debian Codegraph @

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

raw
1 SET @global_thread_cache_size = @@GLOBAL.thread_cache_size;
2 FLUSH STATUS;
3 '# Test1#'
4 SET @@GLOBAL.thread_cache_size=3;
5 SHOW STATUS LIKE 'Threads_cached';
6 Variable_name Value
7 Threads_cached 0
8 0 Expected
9 ** Connecting conn1 using username 'root' **
10 ** Connecting conn2 using username 'root' **
11 ** Connecting conn3 using username 'root' **
12 ** Connecting conn4 using username 'root' **
13 ** Connection default **
14 SHOW STATUS LIKE 'Threads_cached';
15 Variable_name Value
16 Threads_cached 0
17 0 Expected
18 ** Disconnecting conn1,conn2,conn3,conn4 **
19 SHOW STATUS LIKE 'Threads_cached';
20 Variable_name Value
21 Threads_cached 3
22 3 Expected
23 SET @@GLOBAL.thread_cache_size= 1;
24 ** Connecting conn1 using username 'root' **
25 ** Connecting conn2 using username 'root' **
26 connection default;
27 ** Disconnecting conn1,conn2 **
28 SHOW STATUS LIKE 'Threads_cached';
29 Variable_name Value
30 Threads_cached 1
31 1 Expected
32 SET @@GLOBAL.thread_cache_size = @global_thread_cache_size;