3 ms·
MySQL's InnoDB is MVCC as well, at least when used with transaction isolation. That said, MySQL does have more mature replication options built-in.
by paulryanrogers 7y ago
MySQL's InnoDB is MVCC as well, at least when used with transaction isolation.
That said, MySQL does have more mature replication options built-in.
- Xamayon 7y agoI wasn't aware of that, but given the transaction capabilities, it makes sense. I primarily use InnoDB and have never had any similar performance issues, so I havn't looked into it heavily... MySQL InnoDB tables handle the use case much much better, so just guessing but it's probably a difference in how the indexes handle updates/multiple versions and how the query planner works for dirty indexes.