I have a table that consists of an
int primary key and
text column and serving primarily in a "read" role. There are currently only about 40,000 rows, but in time, I expect there to be an additional 500,000 rows per year. This is on a system with perhaps 10 active users per day, so very low-impact.
With MyISAM, the table is less than 4MB. With InnoDB, it is over 7MB.
If disk space is a concern, is MyISAM really so untrustworthy that I should use InnoDB over MyISAM?