• Summary of MySQL lock knowledge


    The concept of lock ① Lock, in real life, is a tool that we want to hide from the outside world. ② In a computer, it is a mechanism to coordinate multiple processes or threads to access a resource concurrently. ③ In the database, in addition to the traditional computing resources (CPU, ram, I / […]

  • How Java annotations implement distributed locks based on redission


    This article mainly introduces how to realize the distributed lock based on Redission with Java annotation. The sample code in this article is very detailed, which has a certain reference value for everyone to learn or work 1. Define annotation class @Target({ ElementType.METHOD }) @Retention(RetentionPolicy.RUNTIME) @Documented public @interface DistributedLock { //Lock name String lockName() default […]

  • The method of implementing distributed lock in redis database


    Distributed lock is a very useful primitive in many environments. It is the only way for different processes to mutually exclusive and share resources. There are many development libraries and blogs that describe how to use redis to implement DLM (distributed lock manager), but each development library uses a different way, and compared with more […]

  • [database] MySQL lock mechanism, hot standby and table splitting


    Welcome to the public address.Love code】If you need background reply2019Give1t learning materialsOh Note: most of this article comes from the Internet, with many words and basic concepts. If you want to have a deeper understanding, you need to find your own articles to study. Table lock and row lock mechanism Table lock (MyISAM and InnoDB) […]

  • Database lock (notes)


    Introduction MyISAMTransaction is not supported. What is the difference between MyISAM and InnoDB in terms of locks MyISAMTable level lock is used by default, row level lock is not supported. InnoDBRow level locks are used by default, and table level locks are also supported. Read lock / shared lock: othersessionCan read, but can’t write. Write […]

  • IOS knowledge combing – multi thread (3) lock


    Under the multithreading model, lock is an unavoidable topic because of the conflict risk of shared memory. About locks First of all, from the perspective of platform independence, from the perspective of capabilities, there are mainly the following types of locks: Mutex: the most common lock, blocking wait, a binary lock mechanism, which allows only […]

  • Correct posture of unlocking redis lock


    Correct posture of unlocking redis lock Redis is a good friend of PHP. In the process of writing business in PHP, sometimes the concept of lock is used. At the same time, only one person can operate a certain behavior. We’re going to use locks at this time. There are several ways to lock. PHP […]

  • Lock overhead optimization and a brief description of CAS


    Lock overhead optimization and a brief description of CAS lock Mutex is used to protect a critical area, that is, to protect a program fragment accessing shared resources, which can not be accessed by multiple threads at the same time. When a thread enters a critical section, other threads or processes must wait. When it […]

  • MySQL Lock Mechanism, Hot Standby, Tables


    Welcome to the Public Number:【Love Coding】Background reply if necessary2019Give1T Learning MaterialsOh Note: This article mostly comes from the Internet, with more words and basic concepts. If you want to have a deeper understanding, you need to find your own articles for research. Table lock and row lock mechanism Table Locks (MyISAM and InnoDB) Advantages of […]

  • Java lock, is it really so complicated?


    Preface The author has also written several articles about concurrent programming in Java, as well as the basic knowledge of threading and volatility. I am interested in reading the author’s original blog. I hope I can help you by explaining the two kinds of locks in Java today. This article was originally published by Zhaosir. […]

  • Analysis of a MySQL deadlock scenario


    Recently, I encountered a deadlock problem of MySQL at RR level. It feels a little interesting. Let’s study it and make a record.Knowledge Points: Shared Lock, Exclusive Lock, Intentional Lock, Gap Lock, Insert Intentional Lock, Lock Waiting Queue If it’s helpful, just praise it. Pay attention to the column database. Don’t run away.The knowledge and […]