22 lines
939 B
Plaintext
22 lines
939 B
Plaintext
set max_heap_table_size = 286720000;
|
|
create table t1 (a int key) engine=memory;
|
|
load data local infile 'suite/ndb/data/table_data10000.dat' into table t1 columns terminated by ' ' (a, @col2);
|
|
insert into t1 select a + 10000 from t1;;
|
|
insert into t1 select a + 10000 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
|
|
insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
|
|
select count(*) from t1;
|
|
count(*)
|
|
5120000
|
|
alter table t1 engine=ndbcluster comment='NDB_TABLE=NOLOGGING' partition by key() partitions 1;
|
|
alter table t1 engine=memory;
|
|
select count(*) from t1;
|
|
count(*)
|
|
5120000
|
|
drop table t1;
|