Re:The database servers powering Let's Encrypt
by VWWHFSfQ on Thursday January 21, 2021 @01:47PM
(#25862440)
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
Re:The database servers powering Let's Encrypt
by kirugan on Thursday January 21, 2021 @01:37PM
(#25862297)
MyISAM days are gone, no one will seriously consider it as suitable engine in MySQL.
Re:The database servers powering Let's Encrypt
by jeffbee on Thursday January 21, 2021 @02:26PM
(#25862985)
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.
Re:The database servers powering Let's Encrypt
by fipar on Thursday January 21, 2021 @04:51PM
(#25864876)
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).
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.