Mahmoud Ashourmahmoudashour.hashnode.dev·Oct 8, 2024Locked In: The Hidden World of Database Locks"When debugging concurrency issues, remember: Schrödinger's bug may or may not exist until observed." In large applications which are accessed daily by thousands or millions of users, concurrency is inevitable. (especially in high transactional syst...Discuss·43 readsDatabases
Jyotiprakash Mishrablog.jyotiprakash.org·Oct 7, 2024A Primer on Cache Coherence ProtocolsIn modern multi-core processors, multiple cores operate in parallel, each with its own cache to store frequently accessed data. These caches are designed to reduce the time it takes for a processor to retrieve data from memory, speeding up overall pe...Discuss·341 readsweak consistency
Samuel Sorialsamuel-sorial.hashnode.dev·Feb 8, 2023Pessimistic Concurrency Control - 2PLIntroduction In today's high-traffic database management systems (DBMS), leveraging the full potential of hardware is essential. With the advent of modern CPUs, the opportunity for parallel processing has increased significantly. However, executing m...Discuss·146 readsDatabaseconcurrency
Lucian Lazarlucienlazar.hashnode.dev·Jul 19, 2022Application LockingWhether you are a manager or a developer, I’m sure you heard the complaints “the application is slow” or “the application is blocked”. They lead to unhappy clients and even lost contracts. This paper presents a way to get rid of waits and deadlocks c...DiscussPL/SQL
