MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. And MySQL either executes all the statement successfully or it doesn’t execute anyone. This can be achieved by the commit and rollback. When all the statements executes successfully then [...]

Continue reading...

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

Continue reading...