diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/start_server_off.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/start_server_off.result | 114 |
1 files changed, 46 insertions, 68 deletions
diff --git a/mysql-test/suite/perfschema/r/start_server_off.result b/mysql-test/suite/perfschema/r/start_server_off.result index 9c5dfbb4bd2..06af389a857 100644 --- a/mysql-test/suite/perfschema/r/start_server_off.result +++ b/mysql-test/suite/perfschema/r/start_server_off.result @@ -4,7 +4,6 @@ information_schema mtr mysql performance_schema -sys test select count(*) from performance_schema.performance_timers; count(*) @@ -18,8 +17,8 @@ count(*) > 4 select count(*) from performance_schema.setup_timers; count(*) 0 -<<<<<<< HEAD -======= +Warnings: +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,72 +92,66 @@ 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 OFF -performance_schema_accounts_size 0 -performance_schema_digests_size 0 -performance_schema_events_stages_history_long_size 0 -performance_schema_events_stages_history_size 0 -performance_schema_events_statements_history_long_size 0 -performance_schema_events_statements_history_size 0 -performance_schema_events_transactions_history_long_size 0 -performance_schema_events_transactions_history_size 0 -performance_schema_events_waits_history_long_size 0 -performance_schema_events_waits_history_size 0 -performance_schema_hosts_size 0 -performance_schema_max_cond_classes 0 -performance_schema_max_cond_instances 0 -performance_schema_max_digest_length 0 -performance_schema_max_file_classes 0 -performance_schema_max_file_handles 0 -performance_schema_max_file_instances 0 -performance_schema_max_index_stat 0 -performance_schema_max_memory_classes 0 -performance_schema_max_metadata_locks 0 -performance_schema_max_mutex_classes 0 -performance_schema_max_mutex_instances 0 -performance_schema_max_prepared_statements_instances 0 -performance_schema_max_program_instances 0 -performance_schema_max_rwlock_classes 0 -performance_schema_max_rwlock_instances 0 -performance_schema_max_socket_classes 0 -performance_schema_max_socket_instances 0 -performance_schema_max_sql_text_length 0 -performance_schema_max_stage_classes 0 -performance_schema_max_statement_classes 0 -performance_schema_max_statement_stack 0 -performance_schema_max_table_handles 0 -performance_schema_max_table_instances 0 -performance_schema_max_table_lock_stat 0 -performance_schema_max_thread_classes 0 -performance_schema_max_thread_instances 0 -performance_schema_session_connect_attrs_size 0 -performance_schema_setup_actors_size 0 -performance_schema_setup_objects_size 0 -performance_schema_users_size 0 ->>>>>>> 258e16fa2de... WIP 5.7 P_S +performance_schema_accounts_size 100 +performance_schema_digests_size 200 +performance_schema_events_stages_history_long_size 1000 +performance_schema_events_stages_history_size 10 +performance_schema_events_statements_history_long_size 1000 +performance_schema_events_statements_history_size 10 +performance_schema_events_transactions_history_long_size 1000 +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 90 +performance_schema_max_cond_instances 1000 +performance_schema_max_digest_length 1024 +performance_schema_max_file_classes 80 +performance_schema_max_file_handles 32768 +performance_schema_max_file_instances 10000 +performance_schema_max_index_stat 5000 +performance_schema_max_memory_classes 320 +performance_schema_max_metadata_locks 10000 +performance_schema_max_mutex_classes 210 +performance_schema_max_mutex_instances 5000 +performance_schema_max_prepared_statements_instances 100 +performance_schema_max_program_instances 5000 +performance_schema_max_rwlock_classes 50 +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 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 +performance_schema_max_table_lock_stat 500 +performance_schema_max_thread_classes 50 +performance_schema_max_thread_instances 200 +performance_schema_session_connect_attrs_size 2048 +performance_schema_setup_actors_size 100 +performance_schema_setup_objects_size 100 +performance_schema_users_size 100 show engine PERFORMANCE_SCHEMA status; show global status like "performance_schema%"; select * from information_schema.engines where engine = "PERFORMANCE_SCHEMA"; ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS PERFORMANCE_SCHEMA YES Performance Schema NO NO NO -show global status like "performance_schema%"; +show status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 @@ -204,17 +197,11 @@ OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED select * from performance_schema.setup_timers; NAME TIMER_NAME 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 insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES'); -<<<<<<< HEAD -ERROR HY000: Invalid performance_schema usage -insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole'); ERROR HY000: Invalid performance_schema usage -======= -ERROR HY000: Invalid performance_schema usage. insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole', 'YES', 'YES'); -ERROR HY000: Invalid performance_schema usage. ->>>>>>> 258e16fa2de... WIP 5.7 P_S +ERROR HY000: Invalid performance_schema usage select * from performance_schema.setup_objects; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED update performance_schema.setup_objects set OBJECT_NAME = 'myobject'; @@ -228,8 +215,6 @@ truncate performance_schema.events_statements_history_long; truncate performance_schema.events_waits_history_long; truncate performance_schema.setup_objects; truncate performance_schema.setup_actors; -select @@global.show_compatibility_56 into @show_compatibility_56_save; -set global show_compatibility_56 = OFF; show global status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 @@ -294,10 +279,3 @@ Performance_schema_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 -show global variables like "show_compatibility_56"; -Variable_name Value -show_compatibility_56 OFF -show session variables like "show_compatibility_56"; -Variable_name Value -show_compatibility_56 OFF -set @@global.show_compatibility_56 = @show_compatibility_56_save; |