试题详情

Choose two.You have an installation of MySQL 8 on Oracle Linux.
Which statement is true about disk temporary tables for this installation?

AOnly internal temporary tables from the optimizer will be created in tmpdir.

BTemporary tables are created in tmpdir only after they reach tmp_table_size.

CTemporary tables are created in tmpdir only if configured to use MyISAM.

DTemporary tables will use the InnoDB temporary tablespace located in datadir.

ETemporary tables will use the InnoDB temporary tablespace located in /tmp.