Home -> Mailing Lists -> Oracle-L -> Re: SQL Server & MySQL

Re: SQL Server & MySQL

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Mon, 14 Feb 2022 20:08:14 +0000
Message-ID: <BN6PR13MB1265DAB4F2BEC310936A0C07D8339_at_BN6PR13MB1265.namprd13.prod.outlook.com> 








Not aware of any DL like Oralce-L...


Here is a collection of links. (not sure if you have seen this already..)
https://www.crowdbotics.com/blog/a-compilation-of-reading-material-books-and-blogs-by-mysql-experts



Jeromy Cole's link is pretty good.


https://blog.jcole.us/innodb/







From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of kyle Hailey <kylelf_at_gmail.com>
Sent: Monday, February 14, 2022 2:50 PM


To: Mladen Gogala <gogala.mladen_at_gmail.com>
Cc: ORACLE-L <oracle-l_at_freelists.org>
Subject: Re: SQL Server & MySQL




PS are there any good hangout spots for MySQL (or SQL Server while we are at it) like Oracle-L?





On Sun, Feb 13, 2022 at 9:08 AM Mladen Gogala <gogala.mladen_at_gmail.com<mailto: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<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmedium.com%2F%40ajones1_999%2Funderstanding-mysql-multiversion-concurrency-control-6b52f1bd5b7e&data=04%7C01%7C%7C1aadf50278d3409e235c08d9eff356d7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637804650696553818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=hM9g6sR6XFXUekXjf8fR%2FWIQUMZMeCPVKN1wMQBP5Cw%3D&reserved=0>



Of course, there is always the fine manual:



https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Finnodb-multi-versioning.html&data=04%7C01%7C%7C1aadf50278d3409e235c08d9eff356d7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637804650696553818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=GiSniYt8RLP8x4AVWthm8vAGlabSr780tqcj6H7fK4A%3D&reserved=0>



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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Foracle-databases%2Foracle-heap-tables-or-sql-server-clustered-indexes-jonathan-lewis-and-grant-fritchey-live-debate%2F&data=04%7C01%7C%7C1aadf50278d3409e235c08d9eff356d7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637804650696553818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Ice%2FWt%2FiopHD7uwPvarNbfSnNsyNCxodNC%2B%2F5cVnjhY%3D&reserved=0>



https://www.red-gate.com/simple-talk/databases/sql-server/learn/oracle-to-sql-server-crossing-the-great-divide-part-1/<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Fsql-server%2Flearn%2Foracle-to-sql-server-crossing-the-great-divide-part-1%2F&data=04%7C01%7C%7C1aadf50278d3409e235c08d9eff356d7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637804650696553818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=LG9knRBk8rQa4YtFM7cU48xCwyXchSb21LXdpiqr0pE%3D&reserved=0>



--



Mladen Gogala


Database Consultant


Tel: (347) 321-1217


https://dbwhisperer.wordpress.com<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdbwhisperer.wordpress.com%2F&data=04%7C01%7C%7C1aadf50278d3409e235c08d9eff356d7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637804650696553818%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=zGLwdN4tS5ekhU0zPimbqtCsPYITnaSylWBg5WAlBds%3D&reserved=0>







--



http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 14 2022 - 21:08:14 CET












Original text of this message