40 lines
896 B
Plaintext
40 lines
896 B
Plaintext
flush status;
|
|
SET @saved_thread_cache_size = @@global.thread_cache_size;
|
|
set global thread_cache_size = 0;
|
|
show global variables like "thread_cache_size";
|
|
Variable_name Value
|
|
thread_cache_size 0
|
|
select @id_increment;
|
|
@id_increment
|
|
1
|
|
select @thread_id_increment;
|
|
@thread_id_increment
|
|
1
|
|
select @id_increment;
|
|
@id_increment
|
|
1
|
|
select @thread_id_increment;
|
|
@thread_id_increment
|
|
1
|
|
set global thread_cache_size = 100;
|
|
show global variables like "thread_cache_size";
|
|
Variable_name Value
|
|
thread_cache_size 100
|
|
select @id_increment;
|
|
@id_increment
|
|
1
|
|
select @thread_id_increment;
|
|
@thread_id_increment
|
|
1
|
|
select @id_increment;
|
|
@id_increment
|
|
1
|
|
select @thread_id_increment;
|
|
@thread_id_increment
|
|
1
|
|
set global thread_cache_size = @saved_thread_cache_size;
|
|
show global status like "performance_schema_thread%";
|
|
Variable_name Value
|
|
Performance_schema_thread_classes_lost 0
|
|
Performance_schema_thread_instances_lost 0
|