Tag:Row lock

  • MySQL global lock and table lock


    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 […]