3 ms·
It's funny how the author seems to have gone out of their way to avoid mentioning MySQL in the list of database systems which utilize MVCC. Just saying.
by jaytaylor 14y ago
It's funny how the author seems to have gone out of their way to avoid mentioning MySQL in the list of database systems which utilize MVCC.
Just saying.
- awj 14y agoIn its default configuration, MySQL doesn't support MVCC. It's the InnoDB storage engine that does, and you have to (know you need to) go out of your way to get it. Just saying.
- jaytaylor 14y agoThat's a good point. I still find the omission amusing.
- awj 14y agoYeah, it is. Even if you add the caveat of "MySQL supports it (with the InnoDB storage engine)", it seems ridiculous to omit MySQL from the list.
- jordanthoms 14y agoInnoDB is the default now.
- ftwinnovations 14y agoBut, were you just saying?
- awj 14y agoIndeed it is. According to the manual this is true as of MySQL 5.5, so sometime in 2010 it switched. Good to know.
- fdr 14y agoI do happen to know the author. He worked in, as I understand it, an MSSQL environment beforehand, but interestingly he didn't mention that either. My guess: his thinking was MVCC-implementing databases that could fit the category: "an archetypal proprietary RDBMS, an archetypal embedded database, an archetypal document database/'NoSQL'" for some point in time. The people going so far to even hit that page already know about client-server, open source, OLTP SQL databases and maybe even some of their shared techniques. In this list, InnoDB technically should be in the 'embedded database' category. Point being: I think it's awfully assumptive to presume a conspiracy against MySQL, old feuds aside. The world is just very large and this tries to draw a shape around a bigger part of it.