72 lines
2.2 KiB
Plaintext
72 lines
2.2 KiB
Plaintext
DROP TABLE IF EXISTS t1;
|
|
DROP TABLE IF EXISTS t2;
|
|
DROP TABLE IF EXISTS t3;
|
|
create table t1(
|
|
id bigint not null primary key auto_increment,
|
|
a varchar(255) not null,
|
|
b bigint,
|
|
index t1_1(b)
|
|
) engine=xengine;
|
|
create table t2(
|
|
id bigint not null primary key auto_increment,
|
|
a varchar(255) not null,
|
|
b bigint,
|
|
index t2_1(b) comment 'cf_t3'
|
|
) engine=xengine;
|
|
create table t3(
|
|
id bigint not null primary key auto_increment,
|
|
a varchar(255) not null,
|
|
b bigint,
|
|
index t3_1(b) comment 'rev:cf_t4'
|
|
) engine=xengine;
|
|
set information_schema_stats_expiry=1;
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE() and table_name <> 't1';
|
|
TABLE_NAME TABLE_ROWS
|
|
t2 1000
|
|
t3 1000
|
|
SELECT CASE WHEN table_rows < 10000 then 'true' else 'false' end from information_schema.tables where table_name = 't1';
|
|
CASE WHEN table_rows < 10000 then 'true' else 'false' end
|
|
true
|
|
set global xengine_force_flush_memtable_now = true;
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME TABLE_ROWS
|
|
t1 10000
|
|
t2 2999
|
|
t3 2999
|
|
SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME data_length>0 index_length>0
|
|
t1 1 1
|
|
t2 1 1
|
|
t3 1 1
|
|
# restart
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME TABLE_ROWS
|
|
t1 10000
|
|
t2 2999
|
|
t3 2999
|
|
SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME data_length>0 index_length>0
|
|
t1 1 1
|
|
t2 1 1
|
|
t3 1 1
|
|
analyze table t1,t2,t3,t4,t5;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 analyze status OK
|
|
test.t2 analyze status OK
|
|
test.t3 analyze status OK
|
|
test.t4 analyze Error Table 'test.t4' doesn't exist
|
|
test.t4 analyze status Operation failed
|
|
test.t5 analyze Error Table 'test.t5' doesn't exist
|
|
test.t5 analyze status Operation failed
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME TABLE_ROWS
|
|
t1 10000
|
|
t2 2999
|
|
t3 2999
|
|
SELECT table_name, data_length>0, index_length>0 FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME data_length>0 index_length>0
|
|
t1 1 1
|
|
t2 1 1
|
|
t3 1 1
|
|
drop table t1, t2, t3;
|