• Different storage engines implement their own locking policies and granularities but some commands overcome storage engines. For example “Alter table” locks whole table regardless of engine.
  • Basically there are two levels of locks – table lock and row lock.