1flush status; 2SET @saved_thread_cache_size = @@global.thread_cache_size; 3set global thread_cache_size = 0; 4show variables like "thread_cache_size"; 5Variable_name Value 6thread_cache_size 0 7select @id_increment; 8@id_increment 91 10select @thread_id_increment; 11@thread_id_increment 121 13select @id_increment; 14@id_increment 151 16select @thread_id_increment; 17@thread_id_increment 181 19set global thread_cache_size = 100; 20show variables like "thread_cache_size"; 21Variable_name Value 22thread_cache_size 100 23select @id_increment; 24@id_increment 251 26select @thread_id_increment; 27@thread_id_increment 281 29select @id_increment; 30@id_increment 311 32select @thread_id_increment; 33@thread_id_increment 341 35set global thread_cache_size = @saved_thread_cache_size; 36show status like "performance_schema_thread%"; 37Variable_name Value 38Performance_schema_thread_classes_lost 0 39Performance_schema_thread_instances_lost 0 40