gtid_executed为空

回答: 当gtid_executed为空时，可以手动设置gtid_purged变量。此时，gtid_purged会被更新为和gtid_executed相同的值。gtid_purged用于记录已经被清除了的binlog事务集合，它是gtid_executed的子集。只有在gtid_executed为空时才能手动设置gtid_purged。执行RESET MASTER时，gtid_purged也会被置空，即始终保持gtid_purged是gtid_executed的子集。\[2\]
#### 引用[.reference_title]
- *1* [MySQL Gtid_executed和Gtid_purged修改时机](https://blog.csdn.net/m0_37389157/article/details/120493774)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [mysql主从GTID不一致问题gtid_executed，gtid_purged ,Retrieved_Gtid_Set,Executed_Gtid_Set（I）](https://blog.csdn.net/Michaelwubo/article/details/126225861)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]