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; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVEC.STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVED.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?()

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


相关考题:

Your little girl is becoming very rude. You ________ scold her. A.mayB.canC.ought toD.need

May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t

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

7. If I _______ you,l_______ take an umbrella with me.A. was ; shouldB. was ; wouldC. were ; willD. were ; would

Ifyoudon’tliketoswim,you_____aswellstayathome.A)shouldB)mayC)canD)would

"You _________ finish your homework before the dinner." said mother. A.shouldB.have toC.mustD.would

– David, you've been losing your temper over nothing lately.– ( ).A. I haven’t been getting much sleep eitherB. You’d better not push yourself too hard, or you’ll get sickC. I’m sorry. I shouldn’t have blown up like thatD. You’d better do exercises regularly

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

Do you need any rice? I can get some() you()the supermarket.Ato;fromBfor;toCfor;from

你最好控制一下上网聊天的时间。(汉译英)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.