-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
The snapshot.locking.mode=none should ideally not hold any locks against tables/dbs while performing a snapshot.This works correctly when innoDB(since it has row-level locking) is the engine for the table meaning, while a snapshot is being performed, inserts/updates can happen on the same table . However, MyISAM engine tends to hold table level locks the result of which is that when snapshot is being performed, no updates/inserts can be made.
This basically negates the usage of the snapshot.locking.mode value set to none for MyISAM engine tables as what we desire is no locks should be held.
This behavior should be explored more and if no other alternatives can be found, then the documentation should be updated.