1create table t1( 2id bigint not null primary key auto_increment, 3a varchar(255) not null, 4b bigint, 5index t1_1(b) 6) engine=rocksdb; 7create table t2( 8id bigint not null primary key auto_increment, 9a varchar(255) not null, 10b bigint, 11index t2_1(b) comment 'cf_t3' 12) engine=rocksdb; 13create table t3( 14id bigint not null primary key auto_increment, 15a varchar(255) not null, 16b bigint, 17index t3_1(b) comment 'rev:cf_t4' 18) engine=rocksdb; 19SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE() and table_name <> 't1'; 20table_name table_rows 21t2 1000 22t3 1000 23SELECT CASE WHEN table_rows < 100000 then 'true' else 'false' end from information_schema.tables where table_name = 't1'; 24CASE WHEN table_rows < 100000 then 'true' else 'false' end 25true 26set global rocksdb_force_flush_memtable_now = true; 27SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE(); 28table_name table_rows 29t1 1000 30t2 1000 31t3 1000 32SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE(); 33table_name data_length>0 index_length>0 34t1 1 1 35t2 1 1 36t3 1 1 37# restart 38SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE(); 39table_name table_rows 40t1 1000 41t2 1000 42t3 1000 43SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE(); 44table_name data_length>0 index_length>0 45t1 1 1 46t2 1 1 47t3 1 1 48analyze table t1,t2,t3,t4,t5; 49Table Op Msg_type Msg_text 50test.t1 analyze status OK 51test.t2 analyze status OK 52test.t3 analyze status OK 53test.t4 analyze Error Table 'test.t4' doesn't exist 54test.t4 analyze status Operation failed 55test.t5 analyze Error Table 'test.t5' doesn't exist 56test.t5 analyze status Operation failed 57SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE(); 58table_name table_rows 59t1 1000 60t2 1000 61t3 1000 62SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE(); 63table_name data_length>0 index_length>0 64t1 1 1 65t2 1 1 66t3 1 1 67drop table t1, t2, t3; 68