Locking Issues – MySQL Tutorials

MySQL can manage the contention for table contents by using Locking :

Internal Locking can be performed in the MySQL server itself for managing the contention for table content by multiple threads. This locking is known as internal because this locking is performed entirely by the server and it does not involve any other programs.
      
External locking [...]