drop table if exists t1, t2, t3, t4; drop table if exists t1, t2, t3, t4; flush status; create table t1 (a int) engine=ndbcluster; create table t2 (a int) engine=ndbcluster; insert into t1 value (2); insert into t2 value (3); select * from t1; a 2 select * from t2; a 3 show status like 'handler_discover%'; Variable_name Value Handler_discover 0 select * from t1; a 2 drop table t1; create table t1 (a int) engine=ndbcluster; insert into t1 value (2); select * from t1; a 2 show status like 'handler_discover%'; Variable_name Value Handler_discover 0 drop table t1; create table t1 (a int) engine=ndbcluster; insert into t1 value (2); select * from t1; a 2 flush status; select * from t1; a 2 update t1 set a=3 where a=2; show status like 'handler_discover%'; Variable_name Value Handler_discover 0 create table t3 (a int not null primary key, b varchar(22), c int, last_col text) engine=ndb; insert into t3 values(1, 'Hi!', 89, 'Longtext column'); create table t4 (pk int primary key, b int) engine=ndb; select * from t1; a 3 select * from t3; a b c last_col 1 Hi! 89 Longtext column show tables like 't4'; Tables_in_test (t4) t4 show tables; Tables_in_test t1 t2 t3 t4 drop table t1, t2, t3, t4; create table t1(c1 int key)ENGINE=MyISAM; insert into t1 values(1),(3),(5); select * from t1 order by c1; c1 1 3 5 create table t1(c1 int key)ENGINE=MyISAM; insert into t1 values(100),(344),(533); select * from t1 order by c1; c1 100 344 533 alter table t1 engine=ndb; show tables; Tables_in_test t1 Warnings: Warning 1050 Local table test.t1 shadows ndb table select * from t1 order by c1; c1 100 344 533 drop table t1; select * from t1 order by c1; c1 1 3 5 drop table t1;