3 ms·
It is quite likely unless you've meticulously avoided it that MySQL is using ISAM on-disk temp tables in the service of your queries.
by jeffbee 6y ago
It is quite likely unless you've meticulously avoided it that MySQL is using ISAM on-disk temp tables in the service of your queries.
- kirugan 6y agoI didn't know that, thanks!
- fipar 6y agoActually, that shouldn't be the case since 5.7: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_internal_tmp_disk_storage_engine https://dev.mysql.com/doc/refman/5.7/en/server-system-variab... (and related: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_default_tmp_storage_engine https://dev.mysql.com/doc/refman/5.7/en/server-system-variab...) And on 8 MyISAM is mostly gone, not even the 'mysql' schema uses it. Edit: Originally linked only to default_tmp_storage_engine).