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 <zardosht@gmail.com>:

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