Comments on: Solving the non-atomic table swap, Take III: making it atomic https://shlomi-noach.github.io/blog/mysql/solving-the-non-atomic-table-swap-take-iii-making-it-atomic Blog by Shlomi Noach Thu, 07 Jul 2016 16:06:11 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/solving-the-non-atomic-table-swap-take-iii-making-it-atomic/comment-page-1#comment-366447 Thu, 07 Jul 2016 16:06:11 +0000 https://shlomi-noach.github.io/blog/?p=7577#comment-366447 @Rick, I’m not looking for a symmetric swap. I’m looking to replace one table with another, while under lock, such that I can finalize some last writes.

]]> By: Rick James https://shlomi-noach.github.io/blog/mysql/solving-the-non-atomic-table-swap-take-iii-making-it-atomic/comment-page-1#comment-366443 Thu, 07 Jul 2016 15:40:49 +0000 https://shlomi-noach.github.io/blog/?p=7577#comment-366443 That are the issues with this?

RENAME TABLE
tbl1 TO tmp,
tbl2 TO tbl1,
tmp TO tbl2;

]]>