[MDEV-37461] Limit tmp file usage by online alter - Jira

XML

Word

Printable

~~MDEV-9101~~ Introduced a way to track and limit files created by IO_CACHE

Our docs describe its usage.

It's rather expected for online alter to follow them as well and reflect the values in status vars and be guided by system vars of that feature.

In the following scenario, alter table is expected to fail:

set global max_tmp_total_space_usage = 65536*5;

create table t (x int) engine=innodb;

set debug_sync= 'alter_table_copy_end SIGNAL ended WAIT_FOR end';

insert t select * from seq_1_to_50000;

--send

alter table t add y int, lock=none, algorithm=copy;

--connect (con2, localhost, root,,)

set debug_sync= 'now WAIT_FOR ended';

start transaction ;

update t set x = x + 200;

commit;

set debug_sync= 'now SIGNAL end';

--connection default

--reap

After it's done, it should be documented in the ALTER TABLE/Online schema change topics

relates to

MDEV-9101 Limit size of created disk temporary files and tables

MDEV-16329 Engine-independent online ALTER TABLE

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.