X. Introduction to MySQL Affairs

1.    MyISAM with memory support table level lock    BDB page level     lock 2. Table lock (not cousin) lock table    read   // read-only table lock, This means that after the lock is executed, the operation in the lock can only be read for the    select * from ...    unlock tables;        Lock  Tablewrite// read-write table lock, readable writable     Insert ...    Update ...    Select ...    Delete ...    unlock tables;        PS:: After the table is locked, other connected operations will be suspended until the locked connection is unlocked, and if the TM has been unlocked, it will be ruined !!! 3. Business     | | start transaction    | | Commit COMMIT TRANSACTION        PS: If you are performing a Mysiam table lock operation, but you have opened the transaction during the table lock, the lock will be executed unlock, which requires attention