Tag:Row lock

  • MySQL global lock and table lock

    Time:2021-7-12

    MySQL locks can be divided into three categories Global lock Watch lock Row lock Global lock Lock the entire database instance The order isFlush tables with read lock (FTWRL)When you make the whole database read-only, you can use this. After that, all the addition, deletion and modification operations of other threads will be blocked, including […]