Re: SQL Server & MySQL

Thanks for the good links.
From just the parts I've read so far, it sounds like MySQL InnoDB is more like Oracle than Postgres or SQL Server.

Kyle

On Sun, Feb 13, 2022 at 9:08 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 2/13/22 11:54, kyle Hailey wrote:
>
>
> Does anyone know of any good books, websites that explain how SQL Server
> and MySQL manage read consistency, i.e creating point in time views of
> data? An explanation like the beginning of Jonathan Lewis' Oracle 8i Book
> would be greatly appreciated. I understand Oracle and Postgres read
> consistency but don't know MySQL or SQL Server.
>
> Thanks
> Kyle
>
> Hi Kyle,
>
> I dunno about the SQL Server, but a decent explanation of MySQL
> concurrency control is here:
>
>
> https://medium.com/_at_ajones1_999/understanding-mysql-multiversion-concurrency-control-6b52f1bd5b7e
>
> Of course, there is always the fine manual:
>
> https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
>
> Jonathan probably knows a bit about SQL Server, he was engaged in the
> architecture debate with Grant Fritchey, a SQL Server guru, a few years
> ago. Here is what I am still able to find from that debate:
>
>
> https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-heap-tables-or-sql-server-clustered-indexes-jonathan-lewis-and-grant-fritchey-live-debate/
>
>
> https://www.red-gate.com/simple-talk/databases/sql-server/learn/oracle-to-sql-server-crossing-the-great-divide-part-1/
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
> -- http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l