Would switching to InnoDB from MyISAM improve performance of comments table?
MyISAM locks the whole page for writes and is not ACID compliant, while InnoDB sticks to locking rows as you point out, and is ACID compliant. This makes it sturdier when you’ve a lot of writes, as in faster and less prone to data corruption. It’s slower for reads in my experience, though it handles … Read more