Debian Codegraph @

mysql-test/suite/innodb/include/innodb_stats_table_flag_analyze.inc

raw
1 SHOW CREATE TABLE test_ps_flag;
2
3 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag';
4 DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag';
5
6 # must be 0, we have just deleted the rows
7 SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag';
8
9 ANALYZE TABLE test_ps_flag;
10
11 # if the table is PS enabled, then this should be 1 and 0 otherwise
12 SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag';