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 '# Test1#'
3 SET @@GLOBAL.thread_cache_size=3;
4 FLUSH THREADS;
5 select variable_value<=@@global.thread_cache_size from information_schema.global_status where variable_name="Threads_cached";
6 variable_value<=@@global.thread_cache_size
7 1
8 CONNECT conn1,localhost,root,,;
9 CONNECT conn2,localhost,root,,;
10 CONNECT conn3,localhost,root,,;
11 CONNECT conn4,localhost,root,,;
12 connection default;
13 select variable_value<=@@global.thread_cache_size from information_schema.global_status where variable_name="Threads_cached";
14 variable_value<=@@global.thread_cache_size
15 1
16 disconnect conn1;
17 disconnect conn2;
18 disconnect conn3;
19 disconnect conn4;
20 SET @@GLOBAL.thread_cache_size= 1;
21 FLUSH THREADS;
22 CONNECT conn1,localhost,root,,;
23 CONNECT conn2,localhost,root,,;
24 connection default;
25 disconnect conn1;
26 disconnect conn2;
27 SET @@GLOBAL.thread_cache_size = @global_thread_cache_size;