问题描述：
[单选]
A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event．用户删除了表中的错误行，而您正在准备时间点恢复，跳过删除事件。The server is configured with:You have identified that the DELETE statement to skip has the Global Transaction Identifier （GTID） ‘dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with:mysqlbinlog –exclude-gtids=’dbbe07da-fe25-11e2-b6c7-0800274aa49e:5’ binlog．000002 | mysqlHowever all events were skipped instead of just the one deleting the wrong row．但是，所有事件都被跳过，而不仅仅是删除错误行的事件。What is the reason for this？这是什么原因？
A．mysql binlog ignores arguments to –exclude-gtids -it means ignore all events with GTIDs.
B．The server keeps track of which GTIDs have already been executed and skips those. 服务器跟踪哪些gtid已经被执行，并跳过那些。
C．Enforce_gtid_consistency is set to ON.
D．Gtid_mode must be set to AUTO during point in time recoveries.
参考答案：查看无
答案解析：无
☆收藏
答案解析：无
☆收藏
上一篇：You have been notified that the ‘apps’ ． ‘reports’ table has been accidentally truncated．You have single file mysqldump backup available taken prior to the truncate． The backup contains all the tables from the instance， and the ‘apps’ ． ‘reports’ table must be restored without affecting the other remaining databases and tables．已通知您“应用程序”。“reports”表被意外截断。在截断之前，您有一个可用的mysqldump备份文件。备份包含实例中的所有表和“apps”。“reports”表必须在不影响其他剩余数据库和表的情况下还原。Which restore option is suitable in this scenario？ 在这种情况下，哪个恢复选项是合适的？
下一篇：What are three methods to reduce MySQL server exposure to remote connections？（）有哪三种方法可以减少MySQL服务器对远程连接的暴露？
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.对于气体灭火系统，当启动气体 2.以下关于消防水泵接合器的保养 3.消防水泵接合器安装后要（）进