MySQL 5.7.5: GTID_EXECUTED系统表（上）

Gtid是从5.6开始推出的杀手级特性，通过GTID特性，极大的提升了主备切换的效率和一致性，

 在MySQL5.7.5里引入了一个新的系统表GTID_EXECUTED： 

 root@mysql 11:29:40>SHOW CREATE TABLE mysql.gtid_executed\G

 *************************** 1. row ***************************

        Table: gtid_executed

 Create Table: CREATE TABLE `gtid_executed` (

   `source_uuid` char(36) NOT NULL COMMENT ‘uuid of the source where the transaction was originally executed.’,

   `interval_start` bigint(20) NOT NULL COMMENT ‘First number of interval.’,

   `interval_end` bigint(20) NOT NULL COMMENT ‘Last number of interval.’,

   PRIMARY KEY (`source_uuid`,`interval_start`)

 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 1 row in set (0.00 sec)

原载于：联动北方

全文：http://bbs.landingbj.com/t-0-248696-1.html