EVOLUTION-MANAGER

Edit File: start_server_off.result

show databases; Database information_schema mtr mysql performance_schema test select count(*) from performance_schema.performance_timers; count(*) 0 select count(*) from performance_schema.setup_consumers; count(*) 0 select count(*) > 3 from performance_schema.setup_instruments; count(*) > 3 0 select count(*) from performance_schema.setup_timers; count(*) 0 show engine PERFORMANCE_SCHEMA status; show status like "performance_schema%"; show status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 Performance_schema_cond_instances_lost 0 Performance_schema_digest_lost 0 Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 Performance_schema_file_instances_lost 0 Performance_schema_hosts_lost 0 Performance_schema_locker_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 Performance_schema_socket_classes_lost 0 Performance_schema_socket_instances_lost 0 Performance_schema_stage_classes_lost 0 Performance_schema_statement_classes_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 show variables like "performance_schema"; Variable_name Value performance_schema OFF select * from performance_schema.setup_consumers; NAME ENABLED select * from performance_schema.setup_instruments; NAME ENABLED TIMED select * from performance_schema.setup_actors; HOST USER ROLE select * from performance_schema.setup_objects; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED select * from performance_schema.setup_timers; NAME TIMER_NAME insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES'); ERROR HY000: Invalid performance_schema usage insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole'); 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'; delete from performance_schema.setup_objects; select * from performance_schema.setup_actors; HOST USER ROLE update performance_schema.setup_actors set HOST = 'myhost'; delete from performance_schema.setup_actors; truncate performance_schema.events_stages_history_long; truncate performance_schema.events_statements_history_long; truncate performance_schema.events_waits_history_long; truncate performance_schema.setup_objects; truncate performance_schema.setup_actors;