1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| show full processlist;
SELECT * FROM performance_schema.processlist WHERE COMMAND != 'Sleep';
SELECT * FROM performance_schema.replication_group_members;
SELECT * FROM performance_schema.replication_group_member_stats;
SELECT MEMBER_HOST, COUNT_TRANSACTIONS_IN_QUEUE FROM performance_schema.replication_group_members a INNER JOIN performance_schema.replication_group_member_stats b ON a.MEMBER_ID=b.MEMBER_ID;
SELECT * FROM performance_schema.replication_connection_status;
SELECT * FROM performance_schema.replication_applier_status_by_worker;
SELECT * FROM performance_schema.replication_applier_status_by_coordinator;
SELECT * FROM performance_schema.replication_applier_status;
select substring_index(substring_index(GTID_SUBTRACT(RECEIVED_TRANSACTION_SET,@@gtid_executed),':',-1),'-',-1)-substring_index(substring_index(GTID_SUBTRACT(RECEIVED_TRANSACTION_SET,@@gtid_executed),':',-1),'-',1) as trx_to_recover from performance_schema.replication_connection_status where channel_name='group_replication_recovery';
show open tables where in_use>0;
show engine innodb status;
show master status;
SELECT * FROM performance_schema.threads;
SELECT group_replication_set_as_primary('PUT_MEMBER_ID');
SELECT group_replication_set_as_primary('PUT_MEMBER_ID', 4);
select * FROM performance_schema.events_statements_summary_by_user_by_event_name WHERE USER NOT IN ('event_scheduler') AND EVENT_NAME IN ('statement/sql/select','statement/sql/insert','statement/sql/update','statement/sql/delete')
SELECT * FROM performance_schema.setup_consumers WHERE NAME LIKE '%statements%';
|
