A.setting the --local-infile=0option when starting mysqld

B.executing REVOKE FILE FROM *_*

C.setting the --open-files-limit=0option when starting mysqld

D.executing REVOKE LOAD FROM *.*

E.executing REVOKE FILE ON *_* FROM ' '@'%'

F.setting the --local-service=0option when starting mysqld

A.query cache

B.thread cache

C.read buffer

D.internal temporary table

E.sort buffer

F.InnoDB buffer pool instance

A.Both the affected transactions will be rolled back.

B.The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

C.One of the affected transactions will be rolled back, the other is allowed to proceed.

D.The transaction isolation level determines which transaction is rolled back.

E.The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

A.The query read data from the data file rather than directly from the buffer pool.

B.The time the query took is the sum of all timer_waitvalues.

C.The query did not find its table in the table definition cache.

D.The event with event_id = 8945is a child of the event with event_id=8944.

A.to prevent schema changes from propagating to the slave before they are validated

B.to allow a backup to be created under reduced load

C.to allow for point-in-time recovery on the slave

D.to allow the remaining events to be processed on the slave while not receiving new events from the master

E.to prevent any transaction experiencing a deadlock