3 ms·
Define 'easy to trash'. I've been using MyISAM without problems for years now.
by chrisbolt 17y ago
Define 'easy to trash'. I've been using MyISAM without problems for years now.
- acl 17y agoI'm curious about this too -- I've used MyISAM for many projects without a problem.
- idlewords 17y agoThe two ways I've experienced: 1. Yank power cord while db writes are happening. 2. Grow the tables over a couple of GB in size.
- spudlyo 17y agoMyISAM is like the ext2 filesystem. You crash and you end up spending a long time doing an fsck, where you have to verify the consistency by walking all the data structures. InnoDB is more like ext3, where you can make things consistent by replaying the changes in the journal. Doing repair on a large MyISAM table can take hours and hours.