| 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; |