[kirugan]

MyISAM days are gone, no one will seriously consider it as suitable engine in MySQL.

[jeffbee]

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.

[fipar]

Actually, that shouldn't be the case since 5.7: 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-variab...)

And on 8 MyISAM is mostly gone, not even the 'mysql' schema uses it.

Edit: Originally linked only to default_tmp_storage_engine).

[kirugan]

I didn't know that, thanks!