maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #03599
Re: online alter table in MariaDB?
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@xxxxxxxxx>:
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp
>
References