use test; show create table standard; Table Create Table standard CREATE TABLE `standard` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 show create table maxrows_low; Table Create Table maxrows_low CREATE TABLE `maxrows_low` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=10000000 show create table maxrows_high; Table Create Table maxrows_high CREATE TABLE `maxrows_high` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000 show create table bykeycount; Table Create Table bykeycount CREATE TABLE `bykeycount` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 8 */ show create table bykeycount_big; Table Create Table bykeycount_big CREATE TABLE `bykeycount_big` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (a) PARTITIONS 32 */ show create table another; Table Create Table another CREATE TABLE `another` ( `a` int NOT NULL, `b` int DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LINEAR KEY (a) */ show tables; Tables_in_test another bykeycount bykeycount_big maxrows_high maxrows_low standard drop table standard; drop table maxrows_low; drop table maxrows_high; drop table bykeycount; drop table bykeycount_big; drop table another;