blob: 13952459847de43e84b3ef2b5e14eb2b41a614d0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
--echo ===============
--echo After Restart Chekc the stats of the table
--echo ===============
-- echo # testcase : pass = 1 fail = 0
SELECT count(*) > 0 as "compress_stat"
FROM information_schema.innodb_cmp_per_index
WHERE
compress_ops_ok BETWEEN @comp_val AND 1000
AND uncompress_ops BETWEEN @uncomp_val AND 1000
AND table_name='tab5' AND database_name='test'
AND index_name like 'idx%' ;
|