Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

Should you go with an Optimistic or Pessimistic Concurrency Control Database?

Автор: Hussein Nasser

Загружено: 2021-07-01

Просмотров: 21334

Описание:

MongoDB, Postgres, Microsoft SQL Server, or MySQL, or any other database manages concurrency control differently. There are two methods, pessimistic and optimistic, both have their pros and cons. Let explore how different databases implement this and what is the effect on performance/scalability.

This is often known as Optimistic vs pessimistic locking. Although I don't really like to use locking with this because it confuses the story.

0:00 Intro
2:20 What is Concurrency Control
6:00 Pessimistic Concurrency Control
14:50 Optimistic Concurrency Control

Resources
https://www.postgresql.org/docs/13/mv...
http://source.wiredtiger.com/develop/...
https://docs.microsoft.com/en-us/trou...



Become a Member on YouTube
   / @hnasr  

🔥 Members Only Content
   • Members-only videos  

Support my work on PayPal
https://bit.ly/33ENps4


🧑‍🏫 Courses I Teach
https://husseinnasser.com/courses

🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com

💾 Database Engineering Videos
   • Database Engineering  

🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
https://partner.canva.com/c/2766475/6...

🎙️ Mic Gear
Shure SM7B Cardioid Dynamic Microphone
https://amzn.to/3o1NiBi

Cloudlifter
https://amzn.to/2RAeyLo

XLR cables
https://amzn.to/3tvMJRu

Focusrite Audio Interface
https://amzn.to/3f2vjGY


📷 Camera Gear
Canon M50 Mark II
https://amzn.to/3o2ed0c

Micro HDMI to HDMI
https://amzn.to/3uwCxK3

Video capture card
https://amzn.to/3f34pyD

AC Wall for constant power
https://amzn.to/3eueoxP


Stay Awesome,
Hussein

Should you go with an Optimistic or Pessimistic Concurrency Control Database?

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(10) { [0]=> object(stdClass)#5726 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "VLTPqImLapM" ["related_video_title"]=> string(40) "Can Redis be used as a Primary database?" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(14) "Hussein Nasser" } [1]=> object(stdClass)#5699 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "oebtXK16WuU" ["related_video_title"]=> string(55) "when indexes are useless | The Backend Engineering Show" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(14) "Hussein Nasser" } [2]=> object(stdClass)#5724 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "uFbMtOdjEOE" ["related_video_title"]=> string(58) "Table Clustering in MySQL and Postgres - The pros and cons" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(14) "Hussein Nasser" } [3]=> object(stdClass)#5731 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "gOB3hpAVIIQ" ["related_video_title"]=> string(81) "Что такое ACID? | Самый частый вопрос бэкендеру" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> string(13) "Over Engineer" } [4]=> object(stdClass)#5710 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "iHNovZUZM3A" ["related_video_title"]=> string(36) "When should you shard your database?" ["posted_time"]=> string(19) "5 лет назад" ["channelName"]=> string(14) "Hussein Nasser" } [5]=> object(stdClass)#5728 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "-qNSXK7s7_w" ["related_video_title"]=> string(45) "Database Indexing Explained (with PostgreSQL)" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> string(14) "Hussein Nasser" } [6]=> object(stdClass)#5723 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "eMotoFvgdUo" ["related_video_title"]=> string(46) "Optimistic Locking - What, When, Why, and How?" ["posted_time"]=> string(19) "1 год назад" ["channelName"]=> string(13) "Arpit Bhayani" } [7]=> object(stdClass)#5733 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "2RE5LFmSEQE" ["related_video_title"]=> string(133) "Чиновники на ПМЭФ: всё плохо, Россия на грани рецессии, ресурсы исчерпаны" ["posted_time"]=> string(24) "18 часов назад" ["channelName"]=> string(27) "Владимир Милов" } [8]=> object(stdClass)#5709 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "UzHl2VzyZS4" ["related_video_title"]=> string(37) "B-tree vs B+ tree in Database Systems" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(14) "Hussein Nasser" } [9]=> object(stdClass)#5727 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "aAbgaF-d8Ug" ["related_video_title"]=> string(103) "Белковский: Кремль заколбасило от идеи грохнуть аятоллу" ["posted_time"]=> string(24) "13 часов назад" ["channelName"]=> string(18) "The Breakfast Show" } }
Can Redis be used as a Primary database?

Can Redis be used as a Primary database?

when indexes are useless | The Backend Engineering Show

when indexes are useless | The Backend Engineering Show

Table Clustering in MySQL and Postgres - The pros and cons

Table Clustering in MySQL and Postgres - The pros and cons

Что такое ACID? | Самый частый вопрос бэкендеру

Что такое ACID? | Самый частый вопрос бэкендеру

When should you shard your database?

When should you shard your database?

Database Indexing Explained (with PostgreSQL)

Database Indexing Explained (with PostgreSQL)

Optimistic Locking - What, When, Why, and How?

Optimistic Locking - What, When, Why, and How?

Чиновники на ПМЭФ: всё плохо, Россия на грани рецессии, ресурсы исчерпаны

Чиновники на ПМЭФ: всё плохо, Россия на грани рецессии, ресурсы исчерпаны

B-tree vs B+ tree in Database Systems

B-tree vs B+ tree in Database Systems

Белковский: Кремль заколбасило от идеи грохнуть аятоллу

Белковский: Кремль заколбасило от идеи грохнуть аятоллу

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]