diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/rpl_gtid_func.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/rpl_gtid_func.result | 128 |
1 files changed, 128 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/rpl_gtid_func.result b/mysql-test/suite/perfschema/r/rpl_gtid_func.result new file mode 100644 index 00000000..de4b1ea1 --- /dev/null +++ b/mysql-test/suite/perfschema/r/rpl_gtid_func.result @@ -0,0 +1,128 @@ +include/master-slave.inc +[connection master] +connection master; +drop table if exists test.marker; +create table test.marker(a int) engine=innodb; +insert into test.marker values (1); +select * from test.marker; +a +1 +truncate table performance_schema.events_waits_history_long; +truncate table performance_schema.events_statements_summary_by_digest; +update performance_schema.setup_instruments +set enabled='YES', timed='YES'; +connection slave; +truncate table performance_schema.events_waits_history_long; +truncate table performance_schema.events_statements_summary_by_digest; +update performance_schema.setup_instruments +set enabled='YES', timed='NO'; +connection master; +select * from performance_schema.setup_instruments +where timed='NO' and name not like "memory/%"; +NAME ENABLED TIMED +select "This better be in the master" as in_master_digest; +in_master_digest +This better be in the master +insert into performance_schema.setup_objects +values ('TABLE', 'master', 'foo', 'YES', 'YES'); +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +EVENT % % YES YES +EVENT information_schema % NO NO +EVENT mysql % NO NO +EVENT performance_schema % NO NO +FUNCTION % % YES YES +FUNCTION information_schema % NO NO +FUNCTION mysql % NO NO +FUNCTION performance_schema % NO NO +PROCEDURE % % YES YES +PROCEDURE information_schema % NO NO +PROCEDURE mysql % NO NO +PROCEDURE performance_schema % NO NO +TABLE % % YES YES +TABLE information_schema % NO NO +TABLE master foo YES YES +TABLE mysql % NO NO +TABLE performance_schema % NO NO +TRIGGER % % YES YES +TRIGGER information_schema % NO NO +TRIGGER mysql % NO NO +TRIGGER performance_schema % NO NO +select digest_text, count_star +from performance_schema.events_statements_summary_by_digest +where digest_text like "%in_%_digest%"; +digest_text count_star +SELECT ? AS `in_master_digest` 1 +insert into test.marker values (2); +connection slave; +select * from test.marker; +a +1 +2 +select * from performance_schema.setup_instruments +where timed='YES'; +NAME ENABLED TIMED +select "This better be in the slave" as in_slave_digest; +in_slave_digest +This better be in the slave +insert into performance_schema.setup_objects +values ('TABLE', 'slave', 'foo', 'YES', 'YES'); +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +EVENT % % YES YES +EVENT information_schema % NO NO +EVENT mysql % NO NO +EVENT performance_schema % NO NO +FUNCTION % % YES YES +FUNCTION information_schema % NO NO +FUNCTION mysql % NO NO +FUNCTION performance_schema % NO NO +PROCEDURE % % YES YES +PROCEDURE information_schema % NO NO +PROCEDURE mysql % NO NO +PROCEDURE performance_schema % NO NO +TABLE % % YES YES +TABLE information_schema % NO NO +TABLE mysql % NO NO +TABLE performance_schema % NO NO +TABLE slave foo YES YES +TRIGGER % % YES YES +TRIGGER information_schema % NO NO +TRIGGER mysql % NO NO +TRIGGER performance_schema % NO NO +select digest_text, count_star +from performance_schema.events_statements_summary_by_digest +where digest_text like "%in_%_digest%"; +digest_text count_star +SELECT ? AS `in_slave_digest` 1 +connection master; +delete from performance_schema.setup_objects +where object_schema='master'; +connection slave; +delete from performance_schema.setup_objects +where object_schema='slave'; +select * from performance_schema.setup_objects; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +EVENT mysql % NO NO +EVENT performance_schema % NO NO +EVENT information_schema % NO NO +EVENT % % YES YES +FUNCTION mysql % NO NO +FUNCTION performance_schema % NO NO +FUNCTION information_schema % NO NO +FUNCTION % % YES YES +PROCEDURE mysql % NO NO +PROCEDURE performance_schema % NO NO +PROCEDURE information_schema % NO NO +PROCEDURE % % YES YES +TABLE mysql % NO NO +TABLE performance_schema % NO NO +TABLE information_schema % NO NO +TABLE % % YES YES +TRIGGER mysql % NO NO +TRIGGER performance_schema % NO NO +TRIGGER information_schema % NO NO +TRIGGER % % YES YES +include/rpl_end.inc |