Comments on: Online ALTER TABLE now available in openark kit https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit Blog by Shlomi Noach Tue, 24 May 2016 05:31:46 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Saurav Kothari https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-359996 Tue, 24 May 2016 05:31:46 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-359996 Lots of broken links. Links to oak-online-alter-table from openark homepage and other pages are broken.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-41840 Wed, 01 Jun 2011 05:29:08 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-41840 @Ronald: thanks, fixed

]]> By: Ronald Bradford https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-41837 Wed, 01 Jun 2011 05:13:55 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-41837 The link to oak-online-alter-table in your post is now broken.

]]> By: Jon d https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-3459 Sun, 23 Aug 2009 20:27:34 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-3459 Thanks for the tool im using it now… Ive been doing similar things myself manually, first create schema, then do a first pass, then copy the remaining rows. Then rename/drop. Great script.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1526 Thu, 09 Apr 2009 16:04:38 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1526 Mohammad,
please do, I will appreciate any feedback

Regards

]]> By: Mohammad Lahlouh https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1525 Thu, 09 Apr 2009 11:44:31 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1525 Great work, I interest in test it

]]> By: Pythian Group - Blog https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1325 Fri, 27 Mar 2009 17:18:32 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1325 […] Shlomi Noach has some news about a MySQL toolkit. No, not that one. openark. The news is: online ALTER TABLE is now available in openark kit. […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1323 Fri, 27 Mar 2009 16:29:22 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1323 @flytox,

I’m actually running this on live servers (my own…) and find that load average does not increase significantly. What’s most affected is slave lag. Using the correct –sleep-time allows for slaves for better follow ups.

]]> By: flytox https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1321 Fri, 27 Mar 2009 15:35:55 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1321 Interesting work. I’m curious to check the generated overhead while altering the table.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/online-alter-table-now-available-in-openark-kit/comment-page-1#comment-1273 Wed, 25 Mar 2009 05:38:12 +0000 https://shlomi-noach.github.io/blog/?p=629#comment-1273 @Arjen
Disk space – you get the same issue when doing normal ALTER TABLE, either directly, or with M-M replication. At any case you’re spending disk space (unless you dump+import, which is a pain in itself)

]]>