Hacker News Reader

>> We currently use MariaDB, with the InnoDB database engine.

It is kind of funny how long InnoDB was the most reliable storage engine. I am not sure if MyISAM is still trying to catch up, it used to be much worse than InnoDB. With the emergence of RocksDB there are multiple options today.

View on HN

The only thing I ever used MyISAM tables for was for storing blobs and full-text search on documents. If your data is mostly read only then it's a decent option out of the box. But if you do even mildly frequent updates then you'll quickly run into problems with the table level locking instead of the row level locking offered by InnoDB

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

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.

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).

I didn't know that, thanks!

Reply on news.ycombinator.com