1 SHOW CREATE
TABLE test_ps_flag;
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';
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';
9 ANALYZE
TABLE test_ps_flag;
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';