That’s pretty much the question. When using mysqldump to backup data, how do or do not my tables lock? If they do not lock, is there a way to get a consistent snapshot without having to use the --where flag? Thank you.
1 Like
Hi Mino. Welcome to the SingleStore forums!
The --add-locks option on mysqldump tries to use LOCK TABLES, which gives a warning message in SingleStore. So mysqldump probably will procede but won’t lock anything. If you want a truly consistent snapshot of your data then, you may need to make your apps stop changing the data in some other way while you run mysqldump.
But of course, each SELECT statement run by mysqldump will run in a transaction, and will only see committed data, based on our standard multi-version concurrency control approach.
1 Like