Re: [Maria-developers] InnoDB: Instant ADD COLUMN that works on old data files

Hi Jan, On Wed, Jan 11, 2017 at 9:07 AM, Jan Lindström wrote: > Number of the fields indeed would solve the ADD COLUMN default case but has > some limitations > > ADD COLUMN m default xxx; would be still slow, xxx = NULL maybe possible, in > other cases could we store

Re: [Maria-developers] InnoDB: Instant ADD COLUMN that works on old data files

Hi, Number of the fields indeed would solve the ADD COLUMN default case but has some limitations ADD COLUMN m default xxx; would be still slow, xxx = NULL maybe possible, in other cases could we store default on SYS_COLUMNS? DROP COLUMN would be still slow Problem naturally is that we do not

[Maria-developers] InnoDB: Instant ADD COLUMN that works on old data files

I would like to seek technical review and feedback for an idea. In the long term, I would like InnoDB to support instant ALTER TABLE for a larger set of operations: https://jira.mariadb.org/browse/MDEV-11424 Instant ALTER TABLE of failure-free record format changes Probably one of the most