diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/start_server_low_table_lock.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/start_server_low_table_lock.result | 24 |
1 files changed, 9 insertions, 15 deletions
diff --git a/mysql-test/suite/perfschema/r/start_server_low_table_lock.result b/mysql-test/suite/perfschema/r/start_server_low_table_lock.result index b0f3bbadfdf..981fa297971 100644 --- a/mysql-test/suite/perfschema/r/start_server_low_table_lock.result +++ b/mysql-test/suite/perfschema/r/start_server_low_table_lock.result @@ -4,7 +4,6 @@ information_schema mtr mysql performance_schema -sys test select count(*) from performance_schema.performance_timers; count(*) @@ -19,7 +18,7 @@ select count(*) from performance_schema.setup_timers; count(*) 5 Warnings: -Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. +Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release select * from performance_schema.accounts; select * from performance_schema.cond_instances; select * from performance_schema.events_stages_current; @@ -93,20 +92,15 @@ select * from performance_schema.table_lock_waits_summary_by_table; select * from performance_schema.threads; select * from performance_schema.users; select * from performance_schema.replication_connection_configuration; -select * from performance_schema.replication_connection_status; select * from performance_schema.replication_applier_configuration; select * from performance_schema.replication_applier_status; select * from performance_schema.replication_applier_status_by_coordinator; -select * from performance_schema.replication_applier_status_by_worker; select * from performance_schema.global_status; select * from performance_schema.status_by_thread; select * from performance_schema.status_by_user; select * from performance_schema.status_by_host; select * from performance_schema.status_by_account; select * from performance_schema.session_status; -select * from performance_schema.global_variables; -select * from performance_schema.variables_by_thread; -select * from performance_schema.session_variables; show global variables like "performance_schema%"; Variable_name Value performance_schema ON @@ -121,7 +115,7 @@ performance_schema_events_transactions_history_size 10 performance_schema_events_waits_history_long_size 10000 performance_schema_events_waits_history_size 10 performance_schema_hosts_size 100 -performance_schema_max_cond_classes 80 +performance_schema_max_cond_classes 90 performance_schema_max_cond_instances 1000 performance_schema_max_digest_length 1024 performance_schema_max_file_classes 80 @@ -139,8 +133,8 @@ performance_schema_max_rwlock_instances 5000 performance_schema_max_socket_classes 10 performance_schema_max_socket_instances 1000 performance_schema_max_sql_text_length 1024 -performance_schema_max_stage_classes 150 -performance_schema_max_statement_classes 193 +performance_schema_max_stage_classes 160 +performance_schema_max_statement_classes 222 performance_schema_max_statement_stack 10 performance_schema_max_table_handles 1000 performance_schema_max_table_instances 500 @@ -167,14 +161,14 @@ from performance_schema.table_lock_waits_summary_by_table where OBJECT_SCHEMA='db1' order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME -3 TABLE db1 t1 +6 TABLE db1 t1 flush tables; select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME from performance_schema.table_lock_waits_summary_by_table where OBJECT_SCHEMA='db1' order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME -3 TABLE db1 t1 +6 TABLE db1 t1 select variable_value from information_schema.global_status where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST'; variable_value @@ -196,15 +190,15 @@ from performance_schema.table_lock_waits_summary_by_table where OBJECT_SCHEMA='db1' order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME -6 TABLE db1 t1 -3 TABLE db1 t2 +12 TABLE db1 t1 +6 TABLE db1 t2 flush tables; select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME from performance_schema.table_lock_waits_summary_by_table where OBJECT_SCHEMA='db1' order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME -6 TABLE db1 t1 +12 TABLE db1 t1 0 TABLE db1 t2 select variable_value > 0 from information_schema.global_status where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST'; |