6
160

In-depth Explanation of Geohashing as well as MongoDB Geo Spatial Practical Example

Master MySQL Locks: Record Lock, Next-Key Lock, Gap Lock, and More Explained

MySql Select for Share and Select for Update Explained (Shared Lock and Exclusive Lock)

MySql - Repeatable Read and Serializable Isolation (Phantom Read by Examples)

MySql - Read Uncommitted and Read Committed (Dirty Read and Non-repeatable Read by Examples)

Machine Learning Chapter 1 - The fundamentals of Machine Learning

In this video, I will dive deep into the fundamentals of Machine Learning, exploring key concepts, real-world applications, and common challenges using insights from Chapter 1 of the book "Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow". Whether you're just starting out or brushing up on your skills, this guide will help you understand fundamentals of Machine Learning.

Переглядів: 39

Відео

In-depth Explanation of Geohashing as well as MongoDB Geo Spatial Practical Example

In-depth Explanation of Geohashing as well as MongoDB Geo Spatial Practical Example

In-depth Explanation of Geohashing as well as MongoDB Geo Spatial Practical Example

Переглядів 24День тому

We’ll starting with an in-depth explanation of Geohashing, how can we utilize it and build on top of it. We’ll also explore geospatial capabilities in enterprise databases like MySQL, PostgreSQL, and MongoDB, including a real-world example of why Redfin migrated from MySQL to PostgreSQL for better GIS performance. Finally, I’ll showcase a hands-on demo using MongoDB’s geospatial queries, includ...

Master MySQL Locks: Record Lock, Next-Key Lock, Gap Lock, and More Explained

Master MySQL Locks: Record Lock, Next-Key Lock, Gap Lock, and More Explained

Master MySQL Locks: Record Lock, Next-Key Lock, Gap Lock, and More Explained

Переглядів 2014 днів тому

This video will provide you with foundational knowledge about MySQL locks, with a focus on Next-Key Locks and Gap Locks. We’ll walk through the official documentation definitions and explain them using practical examples. If you haven’t already, check out the previous video on Shared and Exclusive Locks here: ua-cam.com/video/NO2hnTZVUOw/v-deo.html. If you find this video helpful, don’t forget ...

MySql Select for Share and Select for Update Explained (Shared Lock and Exclusive Lock)

MySql Select for Share and Select for Update Explained (Shared Lock and Exclusive Lock)

MySql Select for Share and Select for Update Explained (Shared Lock and Exclusive Lock)

Переглядів 3321 день тому

This video talks about MySql Select for Share and Select for Update. As well as MySql Shared lock and Exclusive lock. Understanding row-level locking is essential to prevent potential issues in concurrent transactions.

MySql - Repeatable Read and Serializable Isolation (Phantom Read by Examples)

MySql - Repeatable Read and Serializable Isolation (Phantom Read by Examples)

MySql - Repeatable Read and Serializable Isolation (Phantom Read by Examples)

Переглядів 20Місяць тому

Continue on MySql transaction isolation levels: repeatable read and serializable, as well as the common issues phantom read. With practical examples on MySql latest version. Previous video related to read uncommitted and read committed. ua-cam.com/video/E9geOy2C78g/v-deo.html 0:00 Intro 0:15 Repeatable Read 0:40 Repeatable Read Explain 1:16 Phantom Read 1:32 Phantom Read 2:52 Serializable 4:11 ...

MySql - Read Uncommitted and Read Committed (Dirty Read and Non-repeatable Read by Examples)

MySql - Read Uncommitted and Read Committed (Dirty Read and Non-repeatable Read by Examples)

MySql - Read Uncommitted and Read Committed (Dirty Read and Non-repeatable Read by Examples)

Переглядів 24Місяць тому

Let’s explore relational database MySql transaction isolation levels: read uncommitted, read committed, as well as the common issues dirty read and non-repeatable read. With some practical examples on MySql latest version. For each isolation level, I will begin by explaining the definition, then discuss the issues associated with that level, and conclude with the corresponding solutions. This c...

КОМЕНТАРІ

@timotheafleming422 11 днів тому
The video is great, you need to keep promoting your channel. Is not hard.
@SethiAbhinav 20 днів тому
Another nice and concise video on locks! In the case of indexed columns, taking a lock on all affected rows makes sense. Say, I try to select * from table where id > x for update. All rows after x should be locked and x itself should also be locked. But, I can't seem to reason as to why innodb would need to take the gap lock on the prev index range as shown in the video?
@stockoverflowrecursive 19 днів тому
Hello, regarding your example, id > x. If previous index range is (x-1, x] and x itself is locked. No lock on range (-inf, x-1]. Please check the example in video when user_id > 3, T2 successfully inserted row when user_id = 2.
@SethiAbhinav 19 днів тому
@stockoverflowrecursive Oh right, thank you. I think I misunderstood what taking a lock on row x meant. A lock on row with user_id = x would be taking a record lock on (x-1, x], right?
@stockoverflowrecursive 17 днів тому
@@SethiAbhinav for queries like "user_id = x". Record lock directly locks the row with user_id = x.
@SethiAbhinav 25 днів тому
Really great content. The slides and example-first explanation definitely helps drive the idea home. Keep making more great content and sharing your knowledge. Thanks!