4 ms·
Aria can be "crashproof" by using what I think is effectively a mini-WAL. "One statement per transaction" is a limitation you need to be able to accept, but -i
by mst 3y ago
Aria can be "crashproof" by using what I think is effectively a mini-WAL.
"One statement per transaction" is a limitation you need to be able to accept, but -if- that's the case the data safety is likely relatively fine.
MyISAM, much like pre-wiredtiger MongoDB, sits firmly in the "probably don't put anything into this you can't recreate" category for me.
Also remember that filesystems are much better at leaving something consistent behind (maybe consistenly broken, but that's still often better for getting things fixed) even after a nasty crash than they used to be - so while the last time I used MyISAM many many years ago we did absolutely get data loss issues, I wouldn't be surprised if we'd've lucked out if we'd had a 21st century filesystem instead of UFS.