mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
128 lines
4 KiB
Text
128 lines
4 KiB
Text
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
|