5 ms·
MyISAM days are gone, no one will seriously consider it as suitable engine in MySQL.
by kirugan 6y ago
MyISAM days are gone, no one will seriously consider it as suitable engine in MySQL.
- jeffbee 6y agoIt 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).