LOCK TABLES FOR WRITE with mysqldump imports
5 Apr
2024
5 Apr
'24
9:16 a.m.
I noticed that my data archiving process has been adding LOCK TABLES (table) FOR WRITE to the mysqldump file. I am now worried that if I ever need to import this data into the 3 node Galera cluster it will cause deadlocking as described in the MariaDB known issues article. Does MariaDB with Galera still lock up when this statement is executed or would it just ignore the LOCK TABLES command?
223
Age (days ago)
223
Last active (days ago)
0 comments
1 participants
participants (1)
-
stephan.vos@metacom.net