[MDEV-9506] InnoDB Online DDL can fail when tmpdir is small Created: 2016-02-02 Updated: 2022-09-08 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table, Storage Engine - InnoDB |
| Affects Version/s: | 10.1.11 |
| Fix Version/s: | 10.1 |
| Type: | Bug | Priority: | Minor |
| Reporter: | MG | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | upstream-fixed | ||
| Description |
|
When using: ALTER TABLE foo ADD INDEX bar (a,b), ALGORITHM=INPLACE, LOCK=NONE The global tmpdir will be used instead of the datadir for sorts, which might be too small or too slow to complete the action. This is fixed upstream in InnoDB 5.6.29: https://bugs.mysql.com/bug.php?id=73250 A workaround is to use ALGORITHM=COPY but then LOCK=NONE is not supported |
| Comments |
| Comment by Elena Stepanova [ 2016-02-02 ] |
|
Since it was done in 5.6 (surprisingly), we'll get it with InnoDB/XtraDB merges when their 5.6.29 versions are out. |