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