mariadb/mysql-test/suite/multi_source
Monty 25b5c63905 MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps
This commit adds 3 new status variables to 'show all slaves status':

- Master_last_event_time ; timestamp of the last event read from the
  master by the IO thread.
- Slave_last_event_time ; Master timestamp of the last event committed
  on the slave.
- Master_Slave_time_diff: The difference of the above two timestamps.

All the above variables are NULL until the slave has started and the
slave has read one query event from the master that changes data.

- Added information_schema.slave_status, which allows us to remove:
   - show_master_info(), show_master_info_get_fields(),
     send_show_master_info_data(), show_all_master_info()
   - class Sql_cmd_show_slave_status.
   - Protocol::store(I_List<i_string_pair>* str_list) as it is not
     used anymore.
- Changed old SHOW SLAVE STATUS and SHOW ALL SLAVES STATUS to
  use the SELECT code path, as all other SHOW ... STATUS commands.

Other things:
- Xid_log_time is set to time of commit to allow slave that reads the
  binary log to calculate Master_last_event_time and
  Slave_last_event_time.
  This is needed as there is not 'exec_time' for row events.
- Fixed that Load_log_event calculates exec_time identically to
  Query_event.
- Updated RESET SLAVE to reset Master/Slave_last_event_time
- Updated SQL thread's update on first transaction read-in to
  only update Slave_last_event_time on group events.
- Fixed possible (unlikely) bugs in sql_show.cc ...old_format() functions
  if allocation of 'field' would fail.

Reviewed By:
Brandon Nesterenko <brandon.nesterenko@mariadb.com>
Kristian Nielsen <knielsen@knielsen-hq.org>
2024-07-25 08:57:27 -06:00
..
change_master.result Failed change master could leave around old relay log files 2021-09-14 13:43:50 +03:00
change_master.test Failed change master could leave around old relay log files 2021-09-14 13:43:50 +03:00
disabled.def MDEV-20101 Assertion failure on select @@global.'m2'.replicate_ignore_table; 2019-08-05 16:03:33 +04:00
gtid.cnf MDEV-26: Global Transaction ID. 2013-02-27 18:38:42 +01:00
gtid.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid_ignore_duplicates.cnf MDEV-8354: out-of-order error with --gtid-ignore-duplicates and row-based replication 2015-06-24 16:52:50 +02:00
gtid_ignore_duplicates.result Merge branch '11.2' into 11.4 2024-05-21 19:38:51 +02:00
gtid_ignore_duplicates.test Merge branch '11.2' into 11.4 2024-05-21 19:38:51 +02:00
gtid_slave_pos.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid_slave_pos.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
info_logs-master.opt MDEV-5277 - Ensure that all MySQL 5.6 options are supported by the 2013-11-25 18:49:40 +04:00
info_logs.result MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps 2024-07-25 08:57:27 -06:00
info_logs.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
load_data.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
load_data.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
mdev-8874.cnf MDEV-8874 Replication filters configured in my.cnf are ignored if slave reset and reconfigured 2019-06-27 09:54:20 +05:30
mdev-8874.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-8874.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-9544.cnf MDEV-9544 FLUSH [RELAY] LOGS does not rotate logs for a named slave 2017-06-05 13:11:10 +05:30
mdev-9544.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-9544.test Merge branch '11.3' into 11.4 2024-02-15 13:53:21 +01:00
multi_parallel.cnf Mdev-10664 Add statuses about optimistic parallel replication stalls 2018-04-19 16:04:23 +05:30
multi_parallel.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multi_parallel.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multi_parallel_loop.inc Mdev-10664 Add statuses about optimistic parallel replication stalls 2018-04-19 16:04:23 +05:30
multi_source_slave_alias_replica.result MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps 2024-07-25 08:57:27 -06:00
multi_source_slave_alias_replica.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multisource.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multisource.test Move mysql-test-run/extra/rpl_tests to suite/rpl/include 2018-03-29 13:59:44 +03:00
multisource_for_channel.result Revert "MDEV-7850: Extend GTID Binlog Events with Thread Id" 2024-02-05 05:56:53 -07:00
multisource_for_channel.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
my.cnf test.cnf files should !include default_my.cnf 2024-02-03 11:22:20 +01:00
relaylog_events.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
relaylog_events.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
replicate_rewrite_db_dynamic.cnf MDEV-15530: Variable replicate_rewrite_db cannot be found in "show global variables" 2022-10-21 14:49:05 -06:00
replicate_rewrite_db_dynamic.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
replicate_rewrite_db_dynamic.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
reset_slave.result Merge branch '11.2' into 11.4 2024-05-21 19:38:51 +02:00
reset_slave.test Revert "MDEV-7850: Extend GTID Binlog Events with Thread Id" 2024-02-05 05:56:53 -07:00
simple.result MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps 2024-07-25 08:57:27 -06:00
simple.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
skip_counter.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
skip_counter.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
status_vars.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
status_vars.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
syntax.result MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps 2024-07-25 08:57:27 -06:00
syntax.test MDEV-4865 Change related to --log option/variable was merged partially 2013-08-13 13:35:36 +02:00