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,.
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
upvoted 1 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
marklv
4 months, 1 week agomarklv
2 months, 2 weeks agovinhvv
2 months, 2 weeks ago