What Is a Data Lock in MySQL

Q

What Is a Data Lock in MySQL?

✍: FYIcenter.com

A

MySQL uses two types of data locks at two levels to provide you the transaction isolation level you need:

  • Share Lock at Row Level (S) - A data row is locked by a transaction for reading.
  • Exclusive Lock at Row Level (X) - A data row is locked by a transaction for updating and deleting.
  • Intention Share Lock at Table Level (IS): A data table is locked by a transaction for placing share locks at row level.
  • Intention Exclusive Lock at Table Level (IX): A data table is locked by a transaction for placing exclusive lock at row level.

 

Transaction Management: Commit or Rollback in MySQL

⇒⇒MySQL Database Tutorials

2017-04-28, 355👍, 0💬