MySQL5.6 5.7 user temporary table comparison

MySQL5.6 5.7 user temporary table comparison

Session-based temporary table
The structure and content of the temporary table generated by default in MySQL5.6 are all in tmpdir


5.6 The temporary tablespace without ibtmp1 is placed under tmpdir. Of course, after the session is interrupted, the two files will disappear. Let's take a look at the 5.7









A temporary table is a user temporary table. The data stored in the temporary table is created by default. The temporary table is an innoDB table. This parameter is available in 5.6 and 5.7.

This article permanently updates the link address: