Hi Zardosht,
I don't know progress of "online alter table" in MariaDB.
But, you can do "online alter table" by using Vertical Partitioning
Storage Engine.
Please see
http://www.slideshare.net/Kentoku/spider-muc2010-20100414
P.26 "How to change the schema"
Thanks,
Kentoku
2010/9/16 Zardosht Kasheff
Hello all,
I saw the following on planet mysql today, http://www.facebook.com/note.php?note_id=430801045932, and it got me thinking. I remember at the 2010 storage engine summit, we discussed having more types of alter table be done online. Here are the meeting notes on that topic:
Smarter "ALTER TABLE" Comment: Need to fix ALTER TABLE to fully support online operations. Jonas: This is already implemented, but currently only in the -telco cluster trees. Antony is willing to look into backporting new ALTER TABLE to MariaDB
Does anyone know if any investigation has been done? I am curious to learn about people's findings. I have done a little poking at the mysql cluster code that has this feature, but I do not understand it well enough to know integration risk and complexity.
Does anyone have any thoughts? I am curious to learn more.
Thanks -Zardosht
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp