| 1 |
Create table |
| 2 |
NoLogging to avoid redo overload issues + increase write rate |
| 3 |
create table t1 (a int primary key, y int, b text, c text, d text, e int) engine=ndb comment='NDB_TABLE=NOLOGGING=1'; |
| 4 |
create procedure blob_work() |
| 5 |
begin |
| 6 |
set @x = 0; |
| 7 |
set @y = 0; |
| 8 |
repeat |
| 9 |
update t1 set y=@y+ 0, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 10 |
update t1 set y=@y+ 1, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 11 |
update t1 set y=@y+ 2, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 12 |
update t1 set y=@y+ 3, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 13 |
update t1 set y=@y+ 4, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 14 |
update t1 set y=@y+ 5, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 15 |
update t1 set y=@y+ 6, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 16 |
update t1 set y=@y+ 7, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 17 |
update t1 set y=@y+ 8, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 18 |
update t1 set y=@y+ 9, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 19 |
update t1 set y=@y+10, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 20 |
update t1 set y=@y+11, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 21 |
update t1 set y=@y+12, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 22 |
update t1 set y=@y+13, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 23 |
update t1 set y=@y+14, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50; |
| 24 |
set @y = @y+15; |
| 25 |
select count(1) into @x from t1 where a=10000; |
| 26 |
until @x > 0 |
| 27 |
end repeat; |
| 28 |
end% |
| 29 |
Starting blob work on server 1 |
| 30 |
call blob_work(); |
| 31 |
Starting adding columns to t1 on server 2 |
| 32 |
alter table t1 add column i100 int column_format dynamic; |
| 33 |
alter table t1 add column i99 int column_format dynamic; |
| 34 |
alter table t1 add column i98 int column_format dynamic; |
| 35 |
alter table t1 add column i97 int column_format dynamic; |
| 36 |
alter table t1 add column i96 int column_format dynamic; |
| 37 |
alter table t1 add column i95 int column_format dynamic; |
| 38 |
alter table t1 add column i94 int column_format dynamic; |
| 39 |
alter table t1 add column i93 int column_format dynamic; |
| 40 |
alter table t1 add column i92 int column_format dynamic; |
| 41 |
alter table t1 add column i91 int column_format dynamic; |
| 42 |
alter table t1 add column i90 int column_format dynamic; |
| 43 |
alter table t1 add column i89 int column_format dynamic; |
| 44 |
alter table t1 add column i88 int column_format dynamic; |
| 45 |
alter table t1 add column i87 int column_format dynamic; |
| 46 |
alter table t1 add column i86 int column_format dynamic; |
| 47 |
alter table t1 add column i85 int column_format dynamic; |
| 48 |
alter table t1 add column i84 int column_format dynamic; |
| 49 |
alter table t1 add column i83 int column_format dynamic; |
| 50 |
alter table t1 add column i82 int column_format dynamic; |
| 51 |
alter table t1 add column i81 int column_format dynamic; |
| 52 |
alter table t1 add column i80 int column_format dynamic; |
| 53 |
alter table t1 add column i79 int column_format dynamic; |
| 54 |
alter table t1 add column i78 int column_format dynamic; |
| 55 |
alter table t1 add column i77 int column_format dynamic; |
| 56 |
alter table t1 add column i76 int column_format dynamic; |
| 57 |
alter table t1 add column i75 int column_format dynamic; |
| 58 |
alter table t1 add column i74 int column_format dynamic; |
| 59 |
alter table t1 add column i73 int column_format dynamic; |
| 60 |
alter table t1 add column i72 int column_format dynamic; |
| 61 |
alter table t1 add column i71 int column_format dynamic; |
| 62 |
alter table t1 add column i70 int column_format dynamic; |
| 63 |
alter table t1 add column i69 int column_format dynamic; |
| 64 |
alter table t1 add column i68 int column_format dynamic; |
| 65 |
alter table t1 add column i67 int column_format dynamic; |
| 66 |
alter table t1 add column i66 int column_format dynamic; |
| 67 |
alter table t1 add column i65 int column_format dynamic; |
| 68 |
alter table t1 add column i64 int column_format dynamic; |
| 69 |
alter table t1 add column i63 int column_format dynamic; |
| 70 |
alter table t1 add column i62 int column_format dynamic; |
| 71 |
alter table t1 add column i61 int column_format dynamic; |
| 72 |
alter table t1 add column i60 int column_format dynamic; |
| 73 |
alter table t1 add column i59 int column_format dynamic; |
| 74 |
alter table t1 add column i58 int column_format dynamic; |
| 75 |
alter table t1 add column i57 int column_format dynamic; |
| 76 |
alter table t1 add column i56 int column_format dynamic; |
| 77 |
alter table t1 add column i55 int column_format dynamic; |
| 78 |
alter table t1 add column i54 int column_format dynamic; |
| 79 |
alter table t1 add column i53 int column_format dynamic; |
| 80 |
alter table t1 add column i52 int column_format dynamic; |
| 81 |
alter table t1 add column i51 int column_format dynamic; |
| 82 |
alter table t1 add column i50 int column_format dynamic; |
| 83 |
alter table t1 add column i49 int column_format dynamic; |
| 84 |
alter table t1 add column i48 int column_format dynamic; |
| 85 |
alter table t1 add column i47 int column_format dynamic; |
| 86 |
alter table t1 add column i46 int column_format dynamic; |
| 87 |
alter table t1 add column i45 int column_format dynamic; |
| 88 |
alter table t1 add column i44 int column_format dynamic; |
| 89 |
alter table t1 add column i43 int column_format dynamic; |
| 90 |
alter table t1 add column i42 int column_format dynamic; |
| 91 |
alter table t1 add column i41 int column_format dynamic; |
| 92 |
alter table t1 add column i40 int column_format dynamic; |
| 93 |
alter table t1 add column i39 int column_format dynamic; |
| 94 |
alter table t1 add column i38 int column_format dynamic; |
| 95 |
alter table t1 add column i37 int column_format dynamic; |
| 96 |
alter table t1 add column i36 int column_format dynamic; |
| 97 |
alter table t1 add column i35 int column_format dynamic; |
| 98 |
alter table t1 add column i34 int column_format dynamic; |
| 99 |
alter table t1 add column i33 int column_format dynamic; |
| 100 |
alter table t1 add column i32 int column_format dynamic; |
| 101 |
alter table t1 add column i31 int column_format dynamic; |
| 102 |
alter table t1 add column i30 int column_format dynamic; |
| 103 |
alter table t1 add column i29 int column_format dynamic; |
| 104 |
alter table t1 add column i28 int column_format dynamic; |
| 105 |
alter table t1 add column i27 int column_format dynamic; |
| 106 |
alter table t1 add column i26 int column_format dynamic; |
| 107 |
alter table t1 add column i25 int column_format dynamic; |
| 108 |
alter table t1 add column i24 int column_format dynamic; |
| 109 |
alter table t1 add column i23 int column_format dynamic; |
| 110 |
alter table t1 add column i22 int column_format dynamic; |
| 111 |
alter table t1 add column i21 int column_format dynamic; |
| 112 |
alter table t1 add column i20 int column_format dynamic; |
| 113 |
alter table t1 add column i19 int column_format dynamic; |
| 114 |
alter table t1 add column i18 int column_format dynamic; |
| 115 |
alter table t1 add column i17 int column_format dynamic; |
| 116 |
alter table t1 add column i16 int column_format dynamic; |
| 117 |
alter table t1 add column i15 int column_format dynamic; |
| 118 |
alter table t1 add column i14 int column_format dynamic; |
| 119 |
alter table t1 add column i13 int column_format dynamic; |
| 120 |
alter table t1 add column i12 int column_format dynamic; |
| 121 |
alter table t1 add column i11 int column_format dynamic; |
| 122 |
alter table t1 add column i10 int column_format dynamic; |
| 123 |
alter table t1 add column i9 int column_format dynamic; |
| 124 |
alter table t1 add column i8 int column_format dynamic; |
| 125 |
alter table t1 add column i7 int column_format dynamic; |
| 126 |
alter table t1 add column i6 int column_format dynamic; |
| 127 |
alter table t1 add column i5 int column_format dynamic; |
| 128 |
alter table t1 add column i4 int column_format dynamic; |
| 129 |
alter table t1 add column i3 int column_format dynamic; |
| 130 |
alter table t1 add column i2 int column_format dynamic; |
| 131 |
alter table t1 add column i1 int column_format dynamic; |
| 132 |
100 columns added |
| 133 |
Finish test |
| 134 |
insert into t1 (a) values (10000); |
| 135 |
drop procedure blob_work; |
| 136 |
drop table test.t1; |