A.mysql> SET GLOBAL sort_buffer_size=256000;

B.mysql> SET SESSION sort_buffer_size=256000;

C.mysql> CONF T; do global sort_buffer_size=256000;

D.mysql> system sort_buffer_size=256000;

E.mysql> SET VARIABLE sort_buffer_size=256000;

A.setting -mysql_secure_configuration to enable paranoid mode

B.setting specific grant privileges to limit remote authentication

C.using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

D.using SSL when transporting data over remote networks

E.setting -skip-networking when remote connections are not required

A.log-bin

B.apply-log

C.binlog_format=STATEMENT

D.gtid_enable

E.bonlog_format=ROW

A.Change the table to use HASH indexes instead of BTREE indexes.

B.Set the value of innodb_adaptive_hash_index to zero.

C.Increase the size of the InnoDB buffer pool.

D.Deactivate the query cache.

E.Increase the value of the innodb_lock_wait_timeout option.

F.Increase the value of the innodb_read_io_threads option.

A.--tab

B.--single-transaction

C.--quick

D.--skip-buffer