Files
oceanbase/test/mysql_test/include/check_stat.inc
oceanbase-admin cea7de1475 init push
2021-05-31 22:56:52 +08:00

26 lines
831 B
PHP

--disable_query_log
--disable_result_log
connection default;
let $tenant_id = query_get_value(select effective_tenant_id() as ID from dual, ID, 1);
connect (obsys_ydm,$OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
connection obsys_ydm;
let $__i__= 100;
while($__i__ > 0)
{
sleep 1;
dec $__i__;
## 检查有没有分区的列级统计信息还没有汇报上来
let $__num__ = query_get_value(select count(*) as num from oceanbase.__all_virtual_meta_table a where a.tenant_id = $tenant_id and not exists (select 1 from oceanbase.__all_virtual_column_statistic b where a.table_id = b.table_id and a.partition_id = b.partition_id and b.tenant_id = $tenant_id), num, 1);
if($__num__ == 0)
{
let $__i__ = -5;
}
}
connection default;
disconnect obsys_ydm;
--enable_query_log
--enable_result_log