Locking strategies

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