diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/no_threads.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/no_threads.result | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/suite/perfschema/r/no_threads.result b/mysql-test/suite/perfschema/r/no_threads.result index f78667f4f01..21991b15931 100644 --- a/mysql-test/suite/perfschema/r/no_threads.result +++ b/mysql-test/suite/perfschema/r/no_threads.result @@ -6,17 +6,20 @@ drop table if exists test.t1; truncate table performance_schema.events_waits_current; truncate table performance_schema.events_waits_history; truncate table performance_schema.events_waits_history_long; -show variables like "thread_handling"; +show global variables like "thread_handling"; Variable_name Value thread_handling no-threads +show status like "Performance_schema_thread_instances_lost"; +Variable_name Value +Performance_schema_thread_instances_lost 0 create table test.t1(a int) engine=MYISAM; -show variables like "performance_schema"; +show global variables like "performance_schema"; Variable_name Value performance_schema ON -show variables like "performance_schema_max_thread%"; +show global variables like "performance_schema_max_thread%"; Variable_name Value performance_schema_max_thread_classes 50 -performance_schema_max_thread_instances 10 +performance_schema_max_thread_instances 50 select count(*) from performance_schema.threads where name like "thread/sql/main"; count(*) @@ -29,16 +32,16 @@ select event_name, operation, left(source, locate(":", source)) as short_source from performance_schema.events_waits_current; event_name operation short_source -wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: +wait/synch/mutex/mysys/THR_LOCK_myisam lock select event_name, operation, left(source, locate(":", source)) as short_source from performance_schema.events_waits_history; event_name operation short_source -wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: +wait/synch/mutex/mysys/THR_LOCK_myisam lock select event_name, operation, left(source, locate(":", source)) as short_source from performance_schema.events_waits_history_long; event_name operation short_source -wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: +wait/synch/mutex/mysys/THR_LOCK_myisam lock update performance_schema.setup_instruments set enabled='YES'; drop table test.t1; |