| 1 |
ALTER TABLE t1 |
| 2 |
algorithm=inplace, |
| 3 |
max_rows=1111111; |
| 4 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: setting MAX_ROWS on table without MAX_ROWS. Try ALGORITHM=COPY. |
| 5 |
ALTER TABLE t1 |
| 6 |
algorithm=copy, |
| 7 |
max_rows=1111111; |
| 8 |
ALTER TABLE t3 |
| 9 |
algorithm=inplace, |
| 10 |
max_rows=4444444; |
| 11 |
ALTER TABLE t3 |
| 12 |
algorithm=copy, |
| 13 |
max_rows=5555555; |
| 14 |
ALTER TABLE t3 |
| 15 |
algorithm=copy, |
| 16 |
max_rows=33333 /* Small enough to get default number of frags */; |
| 17 |
ALTER TABLE t3 |
| 18 |
algorithm=inplace, |
| 19 |
max_rows=33332 /* Small enough to still be at default number of frags */; |
| 20 |
Note! The value of MAX_ROWS in NDB is still 33333 |
| 21 |
-- t3 -- |
| 22 |
Version: Any |
| 23 |
Fragment type: HashMapPartition |
| 24 |
K Value: 6 |
| 25 |
Min load factor: 78 |
| 26 |
Max load factor: 80 |
| 27 |
Temporary table: no |
| 28 |
Number of attributes: 3 |
| 29 |
Number of primary keys: 1 |
| 30 |
Length of frm data: XXX |
| 31 |
Max Rows: 33333 |
| 32 |
Row Checksum: 1 |
| 33 |
Row GCI: 1 |
| 34 |
SingleUserMode: 0 |
| 35 |
ForceVarPart: 1 |
| 36 |
PartitionCount: 8 |
| 37 |
FragmentCount: 8 |
| 38 |
PartitionBalance: SPECIFIC |
| 39 |
ExtraRowGciBits: 0 |
| 40 |
ExtraRowAuthorBits: 0 |
| 41 |
TableStatus: Retrieved |
| 42 |
Table options: readbackup |
| 43 |
HashMap: DEFAULT-HASHMAP-3840-8 |
| 44 |
-- Attributes -- |
| 45 |
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY |
| 46 |
b Longvarchar(1020;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY |
| 47 |
c Datetime2(0) NULL AT=FIXED ST=MEMORY |
| 48 |
-- Indexes -- |
| 49 |
PRIMARY KEY(a) - UniqueHashIndex |
| 50 |
PRIMARY(a) - OrderedIndex |
| 51 |
b(b) - OrderedIndex |
| 52 |
a(a, b, c) - OrderedIndex |
| 53 |
ALTER TABLE t3 |
| 54 |
algorithm=inplace, |
| 55 |
reorganize partition; |
| 56 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY. |
| 57 |
ALTER TABLE t3 |
| 58 |
algorithm=inplace, |
| 59 |
max_rows=0; |
| 60 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Setting MAX_ROWS to 0 is not supported online. Try ALGORITHM=COPY. |
| 61 |
ALTER TABLE t3 |
| 62 |
algorithm=copy, |
| 63 |
max_rows=0; |
| 64 |
ALTER TABLE t3 |
| 65 |
algorithm=inplace, |
| 66 |
reorganize partition; |
| 67 |
INSERT INTO t3 VALUES(37, "MySQL Cluster", '2015-12-15'); |
| 68 |
SELECT b FROM t3 WHERE a > 10; |
| 69 |
b |
| 70 |
MySQL Cluster |
| 71 |
DELETE FROM t3 WHERE a = 37; |
| 72 |
ALTER TABLE t3 |
| 73 |
algorithm=copy, |
| 74 |
max_rows=444444444 /* Large with many frags */; |
| 75 |
ALTER TABLE t3 |
| 76 |
algorithm=inplace, |
| 77 |
max_rows=0 /* Not allowed since number of frags reduced */; |
| 78 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Online reduction in number of fragments not supported. Try ALGORITHM=COPY. |
| 79 |
ALTER TABLE t3 |
| 80 |
algorithm=copy, |
| 81 |
max_rows=0 /* Back to zero by using copying */; |
| 82 |
ALTER TABLE t3 |
| 83 |
algorithm=inplace, |
| 84 |
reorganize partition; |
| 85 |
INSERT INTO t3 VALUES(37, "MySQL Cluster", '2015-12-15'); |
| 86 |
SELECT b FROM t3 WHERE a > 10; |
| 87 |
b |
| 88 |
MySQL Cluster |
| 89 |
DELETE FROM t3 WHERE a = 37; |
| 90 |
ALTER TABLE t2 |
| 91 |
algorithm=copy, |
| 92 |
max_rows=33333; |
| 93 |
ALTER TABLE t2 |
| 94 |
algorithm=inplace, |
| 95 |
max_rows=0; |
| 96 |
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Setting MAX_ROWS to 0 is not supported online. Try ALGORITHM=COPY. |
| 97 |
ALTER TABLE t2 |
| 98 |
algorithm=copy, |
| 99 |
max_rows=0; |
| 100 |
== verify_mysql_dd.inc == |