| 1 |
CREATE TABLE t1 ( |
| 2 |
pk INT NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 3 |
attr1 VARCHAR(1024), |
| 4 |
attr2 VARBINARY(1024), |
| 5 |
attr3 TEXT |
| 6 |
) ROW_FORMAT=DYNAMIC ENGINE=ndbcluster CHARACTER SET latin1; |
| 7 |
CREATE UNIQUE INDEX ui on t1(pk,attr1,attr2); |
| 8 |
set @val = "0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF"; |
| 9 |
set @val2 = 0x0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF0123456789ABCDEF; |
| 10 |
set ndb_autoincrement_prefetch_sz = 256; |
| 11 |
select count(*) from t1; |
| 12 |
count(*) |
| 13 |
10000 |
| 14 |
SET SESSION information_schema_stats_expiry=0; |
| 15 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 16 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 17 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 18 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 19 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 20 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 21 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 22 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 23 |
delete from t1 where mod(pk, 100) < 75 order by pk limit 1000; |
| 24 |
select count(*) from t1; |
| 25 |
count(*) |
| 26 |
2500 |
| 27 |
select count(*) from t1 where mod(pk, 100) < 75; |
| 28 |
count(*) |
| 29 |
0 |
| 30 |
set ndb_optimization_delay = 0; |
| 31 |
optimize table t1; |
| 32 |
Table Op Msg_type Msg_text |
| 33 |
test.t1 optimize status OK |
| 34 |
optimize worked ok! |
| 35 |
drop table t1; |
| 36 |
SET SESSION information_schema_stats_expiry=default; |