Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 111

You have an installation of MySQL 8 on Oracle Linux.

Consider the outputs:

Which statement is true about disk temporary tables for this installation?

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

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

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

Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

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

Correct Answer: D

In MySQL 8, temporary tables are first created in memory and then, if they exceed the `tmp_table_size` limit, they are converted to disk-based tables. The `tmp_table_size` is set to 16777216 bytes (16 MB), indicating that if a temporary table grows beyond this size, it will be moved to disk storage. This means that temporary tables are created in `tmpdir` only after they reach the `tmp_table_size` limit.

Discussion

marklvOption: B

B, innodb has its own temporary tablespace

marklv

Sorry, innodb does use datadir for temporary tablespace. D is correct. When the size for the temporary table is large enough it switches to disk from memory,.

vinhvv

https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html tmp_table_size: From MySQL 8.0.28, tmp_table_size defines the maximum size of any individual in-memory internal temporary table created by the TempTable storage engine. When the tmp_table_size limit is reached, MySQL automatically converts the in-memory internal temporary table to an InnoDB on-disk internal temporary table