You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?()A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEB.STOP SLAVE; BEGIN;

题目
You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?()

A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE

B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE

C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE

D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE


相似考题
更多“You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?() ”相关问题
  • 第1题:

    If you don’t like to swim, you _____as well stay at home.

    A)should            B)may            C)can             D)would


    选B,因为might/may as well 或者 just as well 都是表达"不妨,做好...的意思."

  • 第2题:

    – David, you've been losing your temper over nothing lately.– ( ).

    A. I haven’t been getting much sleep either

    B. You’d better not push yourself too hard, or you’ll get sick

    C. I’m sorry. I shouldn’t have blown up like that

    D. You’d better do exercises regularly


    正确答案:C

  • 第3题:

    Do you need any rice? I can get some() you()the supermarket.

    Ato;from

    Bfor;to

    Cfor;from


    B

  • 第4题:

    "You _________ finish your homework before the dinner." said mother.

    A.should

    B.have to

    C.must

    D.would


    参考答案:C

  • 第5题:

    “You ____ have a wrong number,” she said. “There’s no one of that name here.”

    A. need

    B. can

    C. must

    D. would


    正确答案:C
    解析:must have意思是肯定有什么,依题意可得,答案是C。

  • 第6题:

    你最好控制一下上网聊天的时间。(汉译英)

    A.You'd better set a limit for your online chat time.

    B.You'd better set a limit on your online chat time.

    C.You'd better set a limit on your online chatting time.

    D.You'd better set a limit for your online chatting time.


    You'd better set a limit on your online chatting time.