Debian Codegraph @

mysql-test/suite/ndb/r/ndb_optimize_table.result

raw
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;