diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/thread_cache.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/thread_cache.result | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/thread_cache.result b/mysql-test/suite/perfschema/r/thread_cache.result new file mode 100644 index 00000000..8c39f4dd --- /dev/null +++ b/mysql-test/suite/perfschema/r/thread_cache.result @@ -0,0 +1,57 @@ +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 +connect con1, localhost, root, , ; +connect con2, localhost, root, , ; +connection default; +select @id_increment; +@id_increment +1 +select @thread_id_increment; +@thread_id_increment +1 +disconnect con2; +connection default; +connect con3, localhost, root, , ; +disconnect con3; +disconnect con1; +connection default; +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 +connect con1, localhost, root, , ; +connect con2, localhost, root, , ; +connection default; +select @id_increment; +@id_increment +1 +select @thread_id_increment; +@thread_id_increment +1 +disconnect con2; +connection default; +connect con3, localhost, root, , ; +disconnect con3; +disconnect con1; +connection default; +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 |